What is the recommended compressed file size range for continuous data loads using Snowpipe?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
What is the following SQL command used for?
Select * from table(validate(t1, job_id => '_last'));
Which of the following statements describes a schema in Snowflake?
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)
A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?
What type of query benefits the MOST from search optimization?
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)
What is the maximum Time Travel retention period for a temporary Snowflake table?
Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),
In the Snowflake access control model, which entity owns an object by default?
Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?
When loading data into Snowflake, how should the data be organized?
Which SQL command can be used to see the CREATE definition of a masking policy?
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?
What are the default Time Travel and Fail-safe retention periods for transient tables?
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
When is the result set cache no longer available? (Select TWO)
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
Which data type can be used to store geospatial data in Snowflake?
What is a limitation of a Materialized View?
What is the default File Format used in the COPY command if one is not specified?
What is the recommended file sizing for data loading using Snowpipe?
What feature can be used to reorganize a very large table on one or more columns?
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
What happens when a virtual warehouse is resized?
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
Which copy INTO command outputs the data into one file?
What tasks can be completed using the copy command? (Select TWO)
True or False: Fail-safe can be disabled within a Snowflake account.
When unloading to a stage, which of the following is a recommended practice or approach?
The PUT command: (Choose two.)
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
Which type of table corresponds to a single Snowflake session?
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
Which of the following objects can be cloned? (Choose four.)
Which of the following objects is not covered by Time Travel?
True or False: A Snowflake account is charged for data stored in both Internal and External Stages.
True or False: A single database can exist in more than one Snowflake account.
Select the different types of Internal Stages: (Choose three.)
True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage?
(Choose all that apply.)
True or False: During data unloading, only JSON and CSV files can be compressed.
What privileges are required to create a task?
Copyright © 2021-2024 CertsTopics. All Rights Reserved
