Snowflake SnowPro Core - Practice Exam 3
The SnowPro ™ Core Certification demonstrates an individual's knowledge to apply specific core expertise in implementing and migrating to Snowflake. A SnowPro ™ Core Certified individual has a thorough understanding of the Snowflake Cloud Data Platform and has the knowledge necessary to design, develop and manage secure, scalable Snowflake solutions to drive business objectives.
PDF Exam Questions
Cheat Sheet
Q1
What is the default value for the Time Travel functionality?
Q2
In which different ways can we query historical data?
Q3
How many warehouse credits will consume the following command?
SELECT COUNT(*)
FROM MYTABLE;Q4
Can the cost of computing and storage vary depending on some characteristics like the account location or the capacity options of your account (on-demand or pre-paid)?
Q5
Do micro-partitions change after being created?
Q6
What is SnowSQL?
Q7
Can we consider Snowflake an OLAP or OLTP service?
Q8
What would be the output if you create a sequence with a starting value of 1 and an increment of 4?
Q9
Which System-defined roles have access to the query profile functionality in the Snowflake UI?
Q10
Do transient tables support fail-safe?
Q11
How can we select the maximized mode for multi-cluster warehouses?
Q12
Is the ACCOUNTADMIN role forced to enable MFA in its account?
Q13
Which command can we use to restore a deleted table on Snowflake?
Q14
Does SnowSQL support multi-factor authentication-based login?
Q15
In which type of Cloud Computing Type can we classify Snowflake?
Q16
Which Snowflake objects are automatically created by default every time you create a database?
Q17
What is the main function of Business Intelligence tools (e.g., Tableau or Quicksight)?
Q18
Is scaling up a virtual warehouse an automatic process?
Q19
Does Snowflake support direct querying on data that is stored in AWS?
Q20
What is the main function of Data Integration tools (e.g., Fivetran or Stitch)?
Q21
Which of these features is NOT supported by Snowflake?
Q22
Does Snowflake support data unloading in external stages?
Q23
What property allows users to control the credits consumed by a multi-cluster warehouse?
Q24
What are the two main differences between views and materialized views?
Q25
What of the following file formats can we use to load semi-structured data on Snowflake?
Q26
Should the ACCOUNTADMIN roles be associated with an actual person’s email address?
Q27
Which planned/scheduled release does Snowflake deploy every week?
Q28
Can we use streams to track changes in materialized views?
Q29
Is it possible for different worksheets within the Snowflake UI to utilize different roles, warehouses, and databases?
Q30
Can we use Multi-factor Authentication to connect to Snowflake via the Snowflake JDBC driver?
Q31
Can a Store Procedure not return anything?
Q32
Does every user in Snowflake get the ‘PUBLIC’ role by default?
Q33
Is it mandatory to execute the ALTER WAREHOUSE ... RESUME command before running any queries?
Q34
Which of the following file formats is not supported by Snowflake?
Q35
What types of releases can we find in Snowflake?
Q36
What is the maximum file size that can be uploaded into Snowflake using Snowsight?
Q37
Which of these conditions must be met to be able to upload our datasets to the Snowflake Marketplace?
Q38
After suspending a Snowflake warehouse, is the warehouse cache still accessible?
Q39
Which of the following object types are stored within a schema?
Q40
Your data is stored in Amazon S3, but your Snowflake account was created using Azure. Can you still query the data stored in Amazon S3 from your Snowflake account?
Q41
Which of the following file formats are supported by Snowflake?
Q42
What are the two major cost categories in Snowflake?
Q43
What are the two types of partners in the Snowflake ecosystem?
Q44
Are User-Defined Functions (UDFs), User-Defined Table Functions (UDTFs), and Stored Procedures considered account-level or schema-level objects in Snowflake?
Q45
Which cache can also be referred to as SSD or local cache?
Q46
Can a UDF not return anything?
Q47
Is scaling out a virtual warehouse an automatic process?
Q48
Must all tasks in a tree of tasks be in the same schema?
Q49
Is auto-resume enabled by default in Snowflake data warehouses?
Q50
In which editions can we configure MFA Authentication?
Q51
Which of these reasons make Snowflake a “SaaS” product?
Q52
What different ways do we have to connect to Snowflake?
Q53
What options do you have if you want to connect an application to Snowflake that doesn’t appear in the Snowflake partner products ecosystem?
Q54
What types of constraints from the ANSI SQL Standard does Snowflake provide?
Q55
Which cache is never dumped, and it’s always up-to-date?
Q56
Which Snowflake object stores DML change made to tables and metadata about each change?
Q57
Which of the following objects are inside a Database?
Q58
What is the function of the PUBLIC schema in Snowflake?
Q59
How can we restart a warehouse that has been suspended because of a Resource Monitor action?
Q60
Are Snowflake transactions BASE compliant?
Q61
In which Programming Languages can we extend the Snowflake functionality by creating User-Defined Functions?
Q62
When is effective the maximized mode for multi-cluster warehouses?
Q63
Can Snowflake transactions span across multiple user sessions?
Q64
Does the SAMPLE_DATA share incur storage charges for your account?
Q65
You have the following data in a variant column called “person_data” from the table “myTable”. How can you query the second hobby of Gonzalo (“music”)?
{
"name": "Gonzalo",
"country": "Spain",
"favouriteTechnology": Snowflake,
"hobbies":[
{"name": "soccer"},
{"name": "music"},
{"name": "hiking"}
]
}Q66
What is the minimum billing charge for a virtual warehouse?
Q67
Which roles can create, alter or drop network policies?
Q68
What statements are true about the Snowflake History Page?
Q69
Can you share a non-secure view in an outbound share?
Q70
Does Snowflake support SSO (Single Sign-On)?
Q71
What are the two models that Snowflake combines as an approach to access control?
Q72
In which Snowflake edition(s) are the Snowflake Marketplace available?
Q73
What are the different types of listings in the Snowflake Data Marketplace?
Q74
What are the supported values for the "Frequency" property of the Resource Monitors?
Q75
What is the maximum size supported by the VARIANT column?
Q76
Snowflake's approach to access control combines aspects of two different models. One model remarks, "access privileges are assigned to roles, which are in turn assigned to users". What is the name of this model?
Q77
Which command can we use to access sequences in queries as expressions?
Q78
Are the running warehouses suspended immediately when a Resouce Monitor triggers the “Notify and Suspend” event?
Q79
Which file formats are supported by Snowflake to unload data?
Q80
Which factors influence the cost of a Snowflake Credit and data storage?
Q81
A task is still being executed before the next scheduled task. What is going to happen with the new scheduled task?
Q82
What do you need to take into account to open a Snowflake account?
Q83
What is the maximum number of clusters in a multi-cluster warehouse?
Q84
What is the Snowflake network policy by default?
Q85
Are Multi-cluster warehouses effective in improving individual queries’ performance?
Q86
What types of functionalities can a Full release include?
Q87
What types of constraints from the ANSI SQL Standard does Snowflake enforce?
Q88
Which of the following configurations enables the auto-scale mode for multi-cluster warehouses?
Q89
Is Federated authentication compliant with SAML2.0 in Snowflake?
Q90
In which Snowflake edition(s) is the Snowflake Data Exchange available?
Q91
By default, how many inbound share(s) have every Snowflake account?
Q92
Which of these statements are correct?
Q93
Is query load calculated by dividing the execution time (in seconds) of all queries in an interval by the total time (in seconds) for the interval?
Q94
How many cluster keys can we create for a Snowflake table?
Q95
What data can we infer from the following Snowflake URL?
https://ab12345.us-east-1.snowflakecomputing.comQ96
Which best practices would you do to increase the performance of a data ingestion workload?
Q97
Will a user created using the following syntax be able to access the tables that are only available for the SYSADMIN role?
CREATE ROLE MYROLE;
GRANT ROLE MYROLE TO ROLE SYSADMIN;
CREATE USER MYUSER PASSWORD=’ABC123’ DEFAULT_ROLE=MYROLE
MUST_CHANGE_PASSWORD=TRUE;Q98
Which privileges does a role need to clone a table?
Q99
Changes in the size of a warehouse will impact the following ways for large, complex, and long-running queries:
Q100
Which command can we use to query the table <my_table> as it was 15 minutes ago?