How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?
A. The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.
B. The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.
C. The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.
D. The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?
A. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 30 days. Fail Safe retention time is 1 day.
B. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 365 days. Fail Safe retention time is 7 days.
C. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
D. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
E. Default Time Travel Retention is set to 7 days. Maximum Time Travel Retention is 1 day. Fail Safe retention time is 90 days.
F. Default Time Travel Retention is set to 90 days. Maximum Time Travel Retention is 7 days. Fail Safe retention time is 356 days.
Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
A. SHOW STORAGE BY TABLE;
B. SHOW TABLES;
C. Information Schema-> TABLE_HISTORY
D. Information Schema-> TABLE_FUNCTION
E. Information Schema-> TABLE_STORAGE_METRICS
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?
A. Use auto-ingest Snowpipes to load large files in a serverless model.
B. Produce the largest files possible, reducing the overall number of files to process.
C. Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.
D. Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.
A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:
1.
Runs a query that takes 3 minutes to complete
2.
Leaves for 15 minutes
3.
Returns and runs a query that takes 10 seconds to complete
4.
Manually suspends the warehouse as soon as the last query was completed
When the user returns, how much billable compute time will have been consumed?
A. 4 minutes
B. 10 minutes
C. 14 minutes
D. 24 minutes
Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)
A. Query execution
B. Data loading
C. Time Travel data
D. Security
E. Authentication and access control
A materialized view should be created when which of the following occurs? (Choose two.)
A. There is minimal cost associated with running the query.
B. The query consumes many compute resources every time it runs.
C. The base table gets updated frequently.
D. The query is highly optimized and does not consume many compute resources.
E. The results of the query do not change often and are used frequently.
What impacts the credit consumption of maintaining a materialized view? (Choose two.)
A. Whether or not it is also a secure view
B. How often the underlying base table is queried
C. How often the base table changes
D. Whether the materialized view has a cluster key defined
E. How often the materialized view is queried
In the Snowflake access control model, which entity owns an object by default?
A. The user who created the object
B. The SYSADMIN role
C. Ownership depends on the type of object
D. The role used to create the object
Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)
A. Management of metadata
B. Computing the data
C. Maintaining Availability Zones
D. Infrastructure security
E. Parsing and optimizing queries
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.