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.
How many tasks can a tree of tasks have?
Which commands from the following list are not available for Snowflake reader accounts?
Snowflake context consists of:
Which programming languages and drivers are natively supported by Snowflake?
Which of the following sizes is not a Warehouse Size?
Is Fail-Safe period for temporary and transient tables 0?
Which of the following sentences is an example of scaling up for a Snowflake virtual Warehouse?
When you sign up for a Snowflake trial account, what are the three Snowflake editions offered?
What is common between AWS Quicksight, PowerBI, and Tableau?
Does the time travel feature recover data with the cost of running constant backups?
How many predecessor tasks can a child task have?
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?
When data is staged to a Snowflake internal staging area using the PUT command, is the data automatically encrypted?
Where can we see the amount of storage used by Snowflake's Fail-Safe functionality in the User Interface?
What are the key considerations for choosing a specific region for your Snowflake account? (Select all that apply)
How often does Snowpipe load the data?
What types of stages do we have?
Can Resource Monitors be replicated?
How can access a variant column using a BI tool?
Do streams ensure exactly-once semantics for new or changed data in a table?
Can multiple streams be created for the same table?
Can you query a Snowflake table with a different virtual warehouse than the one you used to load the data?
What is the storage hierarchy in Snowflake?
Can Snowpipe load a file with the same name if it has been modified later?
Are shared databases exclusively read-only databases?
A point-in-time snapshot of data that can be updated by users is called…
Can a single storage integration support multiple external stages?
May the warehouse cache be reset if a running warehouse is suspended and resumes?
Are you forced to select the closest region to your office when creating a Snowflake account?
Can Snowflake carry out transformations after loading files staged by partner software (ELT)?
Does Snowflake allow only the load of structured data?
Do you have to link an internal stage to the cloud storage providers when you create it?
What is the use of the OVERWRITE=TRUE option in the PUT command?
Which of the following sentences is an example of scaling out for a Snowflake virtual Warehouse?
Do you have to link an external stage to the cloud storage providers when you create it?
Which mechanisms allow users to extend Snowflake functionalities?
What are the two modes in which a multi-cluster warehouse can run?
A table has a size of 100MB. If we clone this table, would we need 200MB of storage?
What object will you use to schedule a merge statement in Snowflake so that it runs every hour?
Are the interactions with the data initialized through the services layer?
Can the table functions in INFORMATION_SCHEMA be used to return account-level usage and historical information for storage, warehouses, user logins, and queries?
Is the query profiler only available for completed queries?
How many warehouses do you need to run to have Snowpipe constantly running?
Do data providers have to sign an agreement before making their data public on the Snowflake data marketplace?
What is common between Fivetran, Informatica, Stitch, and Talend?
What scaling policies are supported by Snowflake multi-cluster warehouses?
Which Snowflake edition allows only one day of Time Travel?
How many warehouses can a user have for a particular Snowflake session?
How many children tasks can a task have?
Does the warehouse cache size change with the warehouse-size?
Using COPY INTO <location> command, to which locations can you unload data from a table?
Which Snowflake role can set up a Snowflake Share?
What command will you execute if you want to disable the query cache?
Which network policy does Snowflake apply first?
Do the Snowflake JDBC and ODBC drivers support multi-factor authentication-based login?
Does re-clustering in Snowflake require manual configuration?
Can temporary tables be created with a clustering key defined?
What is the minimum Snowflake edition that you need for the Data Sharing capability?
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?
What are the Snowpipe mechanisms for detecting if the staged files are available?
What would happen if we executed the following command?
Which Cloud Provider doesn’t accept the OVERWRITE option in the PUT command?
Are Snowflake transactions ACID compliant?
Which of the following statements are true concerning the Snowflake release process?
In which Snowflake edition is Tri-Secret Secure option available?
How can a producer share a table with a consumer located in a different region?
Which options are correct regarding the data that is stored in micro-partition metadata?
In which Programming Languages can we extend the Snowflake functionality by creating Stored Procedures using Snowpark?
Which possibilities give us Snowflake to resize a Warehouse?
What file format provides the fastest load performance?
Where is Multi-Factor Authentication (MFA) supported in Snowflake?
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?
A task went into a loop. How long will the task run before Snowflake finishes it?
Which of the following key concepts need to be considered while loading data into Snowflake?
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?
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?
Which of these security features are supported by Snowflake?
Which of the following roles or privileges are required to view the table function TASK_HISTORY?
Can we load data into a Snowflake account hosted on AWS US-EAST-1 from a file staged in GCP US-EAST4?
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?
Is the load history of the source table included in a cloned table?
You have the following data in a variant column from the table “myTable”. How can you query the favorite technology that Gonzalo uses?
Which of the following are sub-categories from the Context Functions?
Which planned/scheduled release does Snowflake deploy every week?
Which role can create a Network Policy in Snowflake?
For how long are we billed if our warehouse runs for 48 seconds?
What type of data incur in Snowflake Storage costs?
Are Insert-only streams only supported on external tables?
Which encryption algorithm is used by Snowflake tables when we load data into them?
In (at least), how many availability zones does Snowflake replicate your data to?
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?
Which of the below columns will you consider while choosing a cluster key?
What are the main differences between the Virtual Private Snowflake (VPS) and Business Critical Editions?
Select all the possible correct Snowflake URLs from the following options considering that the Account Locator of my organization is “ab12345”.
Which of the following are valid context functions in Snowflake? (select all that apply)
Which functionality is not provided by the query profile?
The owner of a task (the one who has the OWNERSHIP privilege) is deleted. What will happen to the task?
Which answer is correct about the Tri-secret functionality?
Which of the below features are only available in both the Business Critical and VPS editions?
Which of the below columns are usually a good choice for clustering keys?