A user unloaded a Snowflake table called mytable to an internal stage called mystage.
Which command can be used to view the list of files that has been uploaded to the staged?
A. list @mytable; B. list @%raytable; C. list @ %m.ystage; D. list @mystage;
D. list @mystage;
Question 183:
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
A. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace. B. A Data Exchange allows groups of accounts to share data privately among the accounts. C. A Data Exchange allows accounts to share data with third, non-Snowflake parties. D. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher. E. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.
B. A Data Exchange allows groups of accounts to share data privately among the accounts.
Question 184:
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
A. Configure the Maximum Clusters setting to "Auto-Scale" B. Set the Warehouse type to "Auto" C. Set the Minimum Clusters and Maximum Clusters settings to the same value D. Set the Minimum Clusters and Maximum Clusters settings to the different values
D. Set the Minimum Clusters and Maximum Clusters settings to the different values
A. Zero-copy cloning creates a mirror copy of a database that updates with the original B. Software updates are automatically applied on a quarterly basis C. Snowflake eliminates resource contention with its virtual warehouse implementation D. Multi-cluster warehouses allow users to run a query that spans across multiple clusters E. Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
D. Multi-cluster warehouses allow users to run a query that spans across multiple clusters
Question 186:
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
A. 4 B. 8 C. 16 D. 32
B. 8
Explanation/Reference:
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:
Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
A. The number of queries executed B. The number of active users assigned to the warehouse C. The size of the virtual warehouse D. The length of time the warehouse is running E. The duration of the queries that are executed
A. The number of queries executed D. The length of time the warehouse is running
Question 188:
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
The Snowflake Search Optimization Services supports improved performance of which kind of query?
A. Queries against large tables where frequent DML occurs B. Queries against tables larger than 1 TB C. Selective point lookup queries D. Queries against a subset of columns in a table
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
A. Number of users B. Warehouse size C. Amount of data processed D. # of clusters for the Warehouse
B. Warehouse size D. # of clusters for the Warehouse
Explanation/Reference:
https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage "Snowflake credits are charged based on the number of virtual warehouses you use, how long they run, and their size."
Nowadays, the certification exams become more and more important and required by more and more
enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare
for the exam in a short time with less efforts? How to get a ideal result and how to find the
most reliable resources? Here on Vcedump.com, you will find all the answers.
Vcedump.com provide not only Snowflake exam questions,
answers and explanations but also complete assistance on your exam preparation and certification
application. If you are confused on your COF-R02 exam preparations
and Snowflake certification application, do not hesitate to visit our
Vcedump.com to find your solutions here.