SnowPro Core Recertification Exam
Last Update 3 days ago
Total Questions : 330
COF-R02 is stable now with all latest exam questions are added 3 days ago. Just download our Full package and start your journey with Snowflake SnowPro Core Recertification Exam certification. All these Snowflake COF-R02 practice exam questions are real and verified by our Experts in the related industry fields.
What is the minimum Snowflake edition required to create a materialized view?
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?
Which of the following statements describe features of Snowflake data caching? (Choose two.)
What is the maximum Time Travel retention period for a temporary Snowflake table?
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
Which of the following significantly improves the performance of selective point lookup queries on a table?
A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?
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?
If a Snowflake user decides a table should be clustered, what should be used as the cluster key?
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
Which file formats are supported for unloading data from Snowflake? (Choose two.)
True or False: During data unloading, only JSON and CSV files can be compressed.
True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.
Which of the following are true of multi-cluster Warehouses? Select all that apply below.
True or False: A Snowflake account is charged for data stored in both Internal and External Stages.
True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.
What are the three layers that make up Snowflake’s architecture?
Choose 3 answer
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?
Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?
Select one.
Which of the following statements are true of Snowflake releases: (Choose two.)
What are the three things customers want most from their enterprise data warehouse solution?
Choose 3 answers
True or False: Snowflake supports federated authentication in all editions.
True or False: An active warehouse is required to run a COPY INTO statement.
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
User-level network policies can be created by which of the following roles? (Select TWO).
Which command can be used to stage local files from which Snowflake interface?
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
Which command is used to unload data from a Snowflake table into a file in a stage?
True or False: Loading data into Snowflake requires that source data files be no larger than 16M
B.
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?
A user needs to create a materialized view in the schema MYD
B.
MYSCHEMA.
Which statements will provide this access?
Which Snowflake technique can be used to improve the performance of a query?
TESTED 28 Apr 2024
Hi this is Romona Kearns from Holland and I would like to tell you that I passed my exam with the use of exams4sure dumps. I got same questions in my exam that I prepared from your test engine software. I will recommend your site to all my friends for sure.
Our all material is important and it will be handy for you. If you have short time for exam so, we are sure with the use of it you will pass it easily with good marks. If you will not pass so, you could feel free to claim your refund. We will give 100% money back guarantee if our customers will not satisfy with our products.