ExamGecko
Login
Home / Snowflake / COF-R02
Ask Question

Snowflake COF-R02 Practice Test - Questions Answers, Page 18

Question list
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
What is the default character set used when loading CSV files into Snowflake?
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
Which of the following terms best describes Snowflake’s database architecture?
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
Which of the following are best practices for loading data into Snowflake? (Choose three.)
A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?
What are the three layers that make up Snowflake’s architecture? Choose 3 answer

Question 171

Report
Export
Collapse

A user is preparing to load data from an external stage

Which practice will provide the MOST efficient loading performance?

Organize files into logical paths
Organize files into logical paths
Store the files on the external stage to ensure caching is maintained
Store the files on the external stage to ensure caching is maintained
Use pattern matching for regular expression execution
Use pattern matching for regular expression execution
Load the data in one large file
Load the data in one large file
Suggested answer: D
asked 23/09/2024
Simon Merlin AGHOKENG
39 questions

Question 172

Report
Export
Collapse

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

4
4
8
8
16
16
32
32
Suggested answer: B

Explanation:

Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:

Snowflake COF-R02 image Question 172 explanation 74008 09232024004436000000

https://docs.snowflake.com/en/user-guide/warehouses-overview.html

asked 23/09/2024
Dewald Van Schalkwyk
32 questions

Question 173

Report
Export
Collapse

Which command sets the Virtual Warehouse for a session?

COPY WAREHOUSE FROM <<config file>>;
COPY WAREHOUSE FROM <<config file>>;
SET WAREHOUSE = <<warehouse name>>;
SET WAREHOUSE = <<warehouse name>>;
USE WAREHOUSE <<warehouse name>>;
USE WAREHOUSE <<warehouse name>>;
USE VIRTUAL_WAREHOUSE <<warehouse name>>;
USE VIRTUAL_WAREHOUSE <<warehouse name>>;
Suggested answer: C

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

asked 23/09/2024
Emanuel Popescu
37 questions

Question 174

Report
Export
Collapse

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

The Pipe load history is reset to empty.
The Pipe load history is reset to empty.
The REFRESH command is executed.
The REFRESH command is executed.
The stage will be purged.
The stage will be purged.
The destination table is truncated.
The destination table is truncated.
Suggested answer: B
asked 23/09/2024
Mark Churly
31 questions

Question 175

Report
Export
Collapse

True or False: Snowpipe via REST API can only reference External Stages as source.

True
True
False
False
Suggested answer: B

Explanation:

Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

asked 23/09/2024
antoine sala
35 questions

Question 176

Report
Export
Collapse

Which of the following are best practices for loading data into Snowflake? (Choose three.)

Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
Enclose fields that contain delimiter characters in single or double quotes.
Enclose fields that contain delimiter characters in single or double quotes.
Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.
Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.
Suggested answer: B, C, E
asked 23/09/2024
Kevin Taylor
30 questions

Question 177

Report
Export
Collapse

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
Scaling out adds clusters of varying sizes to a virtual warehouse.
Scaling out adds clusters of varying sizes to a virtual warehouse.
Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
Scaling up resizes a virtual warehouse so it can handle more complex workloads.
Scaling up resizes a virtual warehouse so it can handle more complex workloads.
Scaling up adds additional database servers to an existing running cluster to handle larger workloads.
Scaling up adds additional database servers to an existing running cluster to handle larger workloads.
Suggested answer: A, E
asked 23/09/2024
sushil divate
35 questions

Question 178

Report
Export
Collapse

What is the minimum Snowflake edition that has column-level security enabled?

Standard
Standard
Enterprise
Enterprise
Business Critical
Business Critical
Virtual Private Snowflake
Virtual Private Snowflake
Suggested answer: B
asked 23/09/2024
Mustafa Kubha
44 questions

Question 179

Report
Export
Collapse

When cloning a database, what is cloned with the database? (Choose two.)

Privileges on the database
Privileges on the database
Existing child objects within the database
Existing child objects within the database
Future child objects within the database
Future child objects within the database
Privileges on the schemas within the database
Privileges on the schemas within the database
Only schemas and tables within the database
Only schemas and tables within the database
Suggested answer: B, E
asked 23/09/2024
Rickey Dickens
38 questions

Question 180

Report
Export
Collapse

Which of the following describes the Snowflake Cloud Services layer?

Coordinates activities in the Snowflake account
Coordinates activities in the Snowflake account
Executes queries submitted by the Snowflake account users
Executes queries submitted by the Snowflake account users
Manages quotas on the Snowflake account storage
Manages quotas on the Snowflake account storage
Manages the virtual warehouse cache to speed up queries
Manages the virtual warehouse cache to speed up queries
Suggested answer: A
asked 23/09/2024
Nathalie Yip
38 questions
Total 330 questions
Go to page: of 33

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy policy
Terms
Disclaimer
Refund policy
Copyright
Twitter X
Facebook
Medium