Snowflake SnowPro Core - Practice Exam 2
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
How many tasks can a tree of tasks have?
Q2
Which commands from the following list are not available for Snowflake reader accounts?
Q3
Snowflake context consists of:
Q4
Which programming languages and drivers are natively supported by Snowflake?
Q5
Which of the sizes listed below does not represent a Snowflake data warehouse size?
Q6
Is Fail-Safe period for temporary and transient tables 0?
Q7
Which of the following sentences is an example of scaling up for a Snowflake virtual Warehouse?
Q8
When you sign up for a Snowflake trial account, what are the three Snowflake editions offered?
Q9
What is common between AWS Quicksight, PowerBI, and Tableau?
Q10
Does the time travel feature recover data with the cost of running constant backups?
Q11
How many predecessor tasks can a child task have?
Q12
A client has ODBC or JDBC available in their systems, but they do not have the Snowflake drivers. Is the client able to connect to Snowflake?
Q13
When data is staged to a Snowflake internal staging area using the PUT command, is the data automatically encrypted?
Q14
Where can we see the amount of storage used by Snowflake's Fail-Safe functionality in the User Interface?
Q15
What are the key considerations when choosing a specific region for your Snowflake account? (Select all that apply)
Q16
How often does Snowpipe load the data?
Q17
What types of stages do we have?
Q18
Can Resource Monitors be replicated?
Q19
How can access a variant column using a BI tool?
Q20
Do streams ensure exactly-once semantics for new or changed data in a table?
Q21
Can multiple streams be created for the same table?
Q22
Can you query a Snowflake table with a different virtual warehouse than the one you used to load the data?
Q23
Which of the following is the correct storage hierarchy in Snowflake?
Q24
Can Snowpipe load a file with the same name, taking into account that the file has been modified later (e.g. if new rows were added)?
Q25
Are shared databases exclusively read-only databases?
Q26
A point-in-time snapshot of data, that can exist beyond the retention period, and can be updated by users is called…
Q27
Can a single storage integration support multiple external stages?
Q28
May the warehouse cache be reset if a running warehouse is suspended and resumes?
Q29
Are you forced to select the closest region to your office when creating a Snowflake account?
Q30
Can Snowflake carry out transformations after loading files staged by partner software (ELT)?
Q31
Does Snowflake allow only the load of structured data?
Q32
Do you have to link an internal stage to the cloud storage providers when you create it?
Q33
What is the use of the OVERWRITE=TRUE option in the PUT command?
Q34
Which of the following sentences is an example of scaling out for a Snowflake virtual Warehouse?
Q35
Do you have to link an external stage to the cloud storage providers when you create it?
Q36
Which mechanisms allow users to extend Snowflake functionalities?
Q37
What are the two modes in which a multi-cluster warehouse can run?
Q38
A table has a size of 100MB. If we clone this table, would we need 200MB of storage?
Q39
What object will you use to schedule a merge statement in Snowflake so that it runs every hour?
Q40
Are the interactions with the data initialized through the services layer?
Q41
Can the table functions in INFORMATION_SCHEMA be used to return account-level usage and historical information for storage, warehouses, user logins, and queries?
Q42
Is the query profiler only available for completed queries?
Q43
How many warehouses do you need to run to have Snowpipe constantly running?
Q44
Do data providers have to sign an agreement before making their data public on the Snowflake data marketplace?
Q45
What is common between Fivetran, Informatica, Stitch, and Talend?
Q46
What scaling policies are supported by Snowflake multi-cluster warehouses?
Q47
Which Snowflake edition allows only one day of Time Travel?
Q48
How many warehouses can a user have for a particular Snowflake session?
Q49
How many children tasks can a task have?
Q50
Does the warehouse cache size change with the warehouse-size?
Q51
Using COPY INTO <location> command, to which locations can you unload data from a table?
Q52
Which Snowflake role can set up a Snowflake Share?
Q53
What command will you execute if you want to disable the query cache?
Q54
Which network policy does Snowflake apply first?
Q55
Do the Snowflake JDBC and ODBC drivers support multi-factor authentication-based login?
Q56
Does re-clustering in Snowflake need to be manually triggered?
Q57
Can temporary tables be created with a clustering key defined?
Q58
What is the minimum Snowflake edition that you need for the Data Sharing capability?
Q59
If you load a file from a stage to a table, and then you load it again using the COPY INTO command, are you going to be able to load it without specifying any particular option?
Q60
What are the Snowpipe mechanisms for detecting if the staged files are available?
Q61
What would happen if we executed the following command?
CREATE OR REPLACE TABLE newTable
CLONE table1;
Q62
Which Cloud Provider doesn’t accept the OVERWRITE option in the PUT command?
Q63
Are Snowflake transactions ACID compliant?
Q64
Which of the following statements are true concerning the Snowflake release process?
Q65
In which Snowflake edition is Tri-Secret Secure option available?
Q66
How can a producer share a table with a consumer located in a different region?
Q67
Which options are correct regarding the data that is stored in micro-partition metadata?
Q68
In which Programming Languages can we extend the Snowflake functionality by creating Stored Procedures using Snowpark?
Q69
What options does Snowflake provide for resizing a data warehouse?
Q70
What file format provides the fastest load performance?
Q71
Where is Multi-Factor Authentication (MFA) supported in Snowflake?
Q72
Snowflake's approach to access control combines aspects of two different models. One model remarks, "each object has an owner, who can in turn grant access to that object". What is the name of this model?
Q73
A task went into a loop. How long will the task run before Snowflake finishes it?
Q74
Which of the following key concepts need to be considered while loading data into Snowflake?
Q75
A team runs the same query daily, generally with a frequency of fewer than 24 hours, and it takes around 10 minutes to execute. Because of this, they realized that the query was not using the results cache. What is a the most likely explanation for this behavior?
Q76
Column level security in Snowflake allows the application of a masking policy to a column within a table or view. Which two features are related to column-level security?
Q77
Which of these security features are supported by Snowflake?
Q78
Which of the following roles or privileges are required to view the table function TASK_HISTORY?
Q79
Can we load data into a Snowflake account hosted on AWS US-EAST-1 from a file staged in GCP US-EAST4?
Q80
A team runs the same query daily, generally with a frequency of fewer than 24 hours, and it takes around 10 minutes to execute. They realized that the underlying data changes because of an ETL process that runs every morning. How can they use the results cache to save the 10 minutes that the query is being executed?
Q81
Is the load history of the source table included in a cloned table?
Q82
You have the following data in a variant column from the table “myTable”. How can you query the favorite technology that Gonzalo uses?
{
"name": "Gonzalo",
"country": "Spain",
"favouriteTechnology": Snowflake,
"hobbies":[
{"name": "soccer"},
{"name": "music"},
{"name": "hiking"}
]
}
Q83
Which of the following are sub-categories from the Context Functions?
Q84
Which planned/scheduled release does Snowflake deploy every week?
Q85
Which role can create a Network Policy in Snowflake?
Q86
For how long are we billed if our warehouse runs for 48 seconds?
Q87
What type of data incur in Snowflake Storage costs?
Q88
Are Insert-only streams only supported on external tables?
Q89
Which encryption algorithm is used by Snowflake tables when we load data into them?
Q90
In (at least), how many availability zones does Snowflake replicate your data to?
Q91
A stream has been created on a table. A row is inserted in the table, and it’s updated later. Will the stream capture both events?
Q92
Which of the below columns will you consider while choosing a cluster key?
Q93
What are the main differences between the Virtual Private Snowflake (VPS) and Business Critical Editions?
Q94
Select all the possible correct Snowflake URLs from the following options considering that the Account Locator of my organization is “ab12345”.
Q95
Which of the following are valid context functions in Snowflake? (select all that apply)
Q96
Which functionality is not provided by the query profile?
Q97
The owner of a task (the one who has the OWNERSHIP privilege) is deleted. What will happen to the task?
Q98
Which answer is correct about the Tri-secret functionality?
Q99
Which of the below features are only available in both the Business Critical and VPS editions?
Q100
Which of the below columns are usually a good choice for clustering keys?