ExamGecko
Search Search Login
Home Home / Snowflake / COF-R02

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

Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
A sales table FCT_SALES has 100 million records. The following Query was executed SELECT COUNT (1) FROM FCT__SALES; How did Snowflake fulfill this query?
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 minimum Snowflake edition allows for a dedicated metadata store?
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
What is a responsibility of Snowflake’s virtual warehouses?
Which TABLE function helps to convert semi-structured data to a relational representation?
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Question 61

Report
Export
Collapse

How a Snowpipe charges calculated?

A.
Per-second/per Warehouse size
A.
Per-second/per Warehouse size
Answers
B.
Per-second/per-core granularity
B.
Per-second/per-core granularity
Answers
C.
Number of Pipes in account
C.
Number of Pipes in account
Answers
D.
Total storage bucket size
D.
Total storage bucket size
Answers
Suggested answer: B

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html

Question 62

Report
Export
Collapse

True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: A

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

Question 63

Report
Export
Collapse

True or False: Snowflake supports federated authentication in all editions.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: A

Explanation:

Reference: https://community.snowflake.com/s/news/federated-authentication-sso-now-availablein-all-snowflake-editions-MC6N3I63LJGNGMHCTKGKFDH4NH2Q

Question 64

Report
Export
Collapse

True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: A

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

Question 65

Report
Export
Collapse

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: B

Explanation:

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

Question 66

Report
Export
Collapse

True or False: During data unloading, only JSON and CSV files can be compressed.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: B

Explanation:

Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html

Question 67

Report
Export
Collapse

True or False: Data Providers can share data with only the Data Consumer.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: B

Explanation:

Topic 2, Exam pool B

Question 68

Report
Export
Collapse

The fail-safe retention period is how many days?

A.
1 day
A.
1 day
Answers
B.
7 days
B.
7 days
Answers
C.
45 days
C.
45 days
Answers
D.
90 days
D.
90 days
Answers
Suggested answer: B

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html

Question 69

Report
Export
Collapse

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: A

Explanation:

You can experiment the same with snowflake UI.

Question 70

Report
Export
Collapse

How would you determine the size of the virtual warehouse used for a task?

A.
Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
A.
Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
Answers
B.
Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
B.
Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
Answers
C.
If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
C.
If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
Answers
D.
Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
D.
Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
Answers
Suggested answer: C
Total 330 questions
Go to page: of 33
ExamGecko

Copyright @2023 ExamGecko | All right reserved

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