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

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

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 91

Report
Export
Collapse

A user needs to create a materialized view in the schema MYDB.MYSCHEMA.

Which statements will provide this access?

A.
GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
A.
GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
Answers
B.
GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
B.
GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
Answers
C.
GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
C.
GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
Answers
D.
GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
D.
GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
Answers
Suggested answer: B

Question 92

Report
Export
Collapse

What is the default character set used when loading CSV files into Snowflake?

A.
UTF-8
A.
UTF-8
Answers
B.
UTF-16
B.
UTF-16
Answers
C.
ISO S859-1
C.
ISO S859-1
Answers
D.
ANSI_X3.A
D.
ANSI_X3.A
Answers
Suggested answer: A

Explanation:

https://docs.snowflake.com/en/user-guide/intro-summaryloading.html#:~:text=For%20delimited%20files%20(CSV%2C%20TSV,encoding%20to%20use%20for%20loading.

For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any other characters sets, you must explicitly specify the encoding to use for loading. For the list of supported character sets, see Supported Character Sets for Delimited Files (in this topic).

Question 93

Report
Export
Collapse

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.
Query against the result set cache
A.
Query against the result set cache
Answers
B.
Query against a virtual warehouse cache
B.
Query against a virtual warehouse cache
Answers
C.
Query against the most-recently created micro-partition
C.
Query against the most-recently created micro-partition
Answers
D.
Query against the metadata excite
D.
Query against the metadata excite
Answers
Suggested answer: D

Question 94

Report
Export
Collapse

Which cache type is used to cache data output from SQL queries?

A.
Metadata cache
A.
Metadata cache
Answers
B.
Result cache
B.
Result cache
Answers
C.
Remote cache
C.
Remote cache
Answers
D.
Local file cache
D.
Local file cache
Answers
Suggested answer: B

Explanation:

https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

Question 95

Report
Export
Collapse

What is a key feature of Snowflake architecture?

A.
Zero-copy cloning creates a mirror copy of a database that updates with the original
A.
Zero-copy cloning creates a mirror copy of a database that updates with the original
Answers
B.
Software updates are automatically applied on a quarterly basis
B.
Software updates are automatically applied on a quarterly basis
Answers
C.
Snowflake eliminates resource contention with its virtual warehouse implementation
C.
Snowflake eliminates resource contention with its virtual warehouse implementation
Answers
D.
Multi-cluster warehouses allow users to run a query that spans across multiple clusters
D.
Multi-cluster warehouses allow users to run a query that spans across multiple clusters
Answers
E.
Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
E.
Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
Answers
Suggested answer: D

Question 96

Report
Export
Collapse

What is a limitation of a Materialized View?

A.
A Materialized View cannot support any aggregate functions
A.
A Materialized View cannot support any aggregate functions
Answers
B.
A Materialized View can only reference up to two tables
B.
A Materialized View can only reference up to two tables
Answers
C.
A Materialized View cannot be joined with other tables
C.
A Materialized View cannot be joined with other tables
Answers
D.
A Materialized View cannot be defined with a JOIN
D.
A Materialized View cannot be defined with a JOIN
Answers
Suggested answer: D

Explanation:

There are several limitations to using materialized views:

A materialized view can query only a single table.

Joins, including self-joins, are not supported.

Question 97

Report
Export
Collapse

What features does Snowflake Time Travel enable?

A.
Querying data-related objects that were created within the past 365 days
A.
Querying data-related objects that were created within the past 365 days
Answers
B.
Restoring data-related objects that have been deleted within the past 90 days
B.
Restoring data-related objects that have been deleted within the past 90 days
Answers
C.
Conducting point-in-time analysis for Bl reporting
C.
Conducting point-in-time analysis for Bl reporting
Answers
D.
Analyzing data usage/manipulation over all periods of time
D.
Analyzing data usage/manipulation over all periods of time
Answers
Suggested answer: B

Explanation:

Snowflake Time Travel enables accessing historical data (i.e. data that has been changed or deleted) at any point within a defined period. It serves as a powerful tool for performing the following tasks:

Restoring data-related objects (tables, schemas, and databases) that might have been accidentally or intentionally deleted.

Duplicating and backing up data from key points in the past.

Analyzing data usage/manipulation over specified periods of time.

https://docs.snowflake.com/en/user-guide/data-time-travel.html

Question 98

Report
Export
Collapse

Which statement about billing applies to Snowflake credits?

A.
Credits are billed per-minute with a 60-minute minimum
A.
Credits are billed per-minute with a 60-minute minimum
Answers
B.
Credits are used to pay for cloud data storage usage
B.
Credits are used to pay for cloud data storage usage
Answers
C.
Credits are consumed based on the number of credits billed for each hour that a warehouse runs
C.
Credits are consumed based on the number of credits billed for each hour that a warehouse runs
Answers
D.
Credits are consumed based on the warehouse size and the time the warehouse is running
D.
Credits are consumed based on the warehouse size and the time the warehouse is running
Answers
Suggested answer: D

Explanation:

Snowflake credits are used to pay for the consumption of resources on Snowflake. A Snowflake credit is a unit of measure, and it is consumed only when a customer is using resources, such as when a virtual warehouse is running, the cloud services layer is performing work, or serverless features are used.

https://docs.snowflake.com/en/user-guide/what-are-credits.html

Question 99

Report
Export
Collapse

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

A.
The ability to scale up warehouses
A.
The ability to scale up warehouses
Answers
B.
The use of warehouse auto scaling
B.
The use of warehouse auto scaling
Answers
C.
The ability to resize warehouses
C.
The ability to resize warehouses
Answers
D.
Use of multi-clustered warehouses
D.
Use of multi-clustered warehouses
Answers
E.
The use of warehouse indexing
E.
The use of warehouse indexing
Answers
Suggested answer: B, D

Question 100

Report
Export
Collapse

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

A.
Use multi-clustered warehousing to scale out warehouse capacity.
A.
Use multi-clustered warehousing to scale out warehouse capacity.
Answers
B.
Scale up the warehouse size to allow Queries to execute faster.
B.
Scale up the warehouse size to allow Queries to execute faster.
Answers
C.
Stop and start the warehouse to clear the queued queries
C.
Stop and start the warehouse to clear the queued queries
Answers
D.
Migrate some queries to a new warehouse to reduce load
D.
Migrate some queries to a new warehouse to reduce load
Answers
E.
Limit user access to the warehouse so fewer queries are run against it.
E.
Limit user access to the warehouse so fewer queries are run against it.
Answers
Suggested answer: A, D
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