[May 02, 2023] Get to the Top with COF-R02 Practice Exam Questions [Q67-Q87]

5/5 - (1 vote)

[May 02, 2023] Get to the Top with COF-R02 Practice Exam Questions

Use Real COF-R02 Dumps Free Sample Questions and Practice Test Engine

Q67. What is a limitation of a Materialized View?

A Materialized View cannot support any aggregate functions

A Materialized View can only reference up to two tables

A Materialized View cannot be joined with other tables

A Materialized View cannot be defined with a JOIN

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.

Q68. True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

True

False

Reference: https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/

Q69. Which of the following objects is not covered by Time Travel?

Tables

Schemas

Databases

Stages

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

Q70. User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?

SHOW GRANTS ON ROLE DATA_SCIENCE

SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

SHOW GRANTS TO USER INQUISITIVE_PERSON

SHOW GRANTS OF ROLE DATA_SCIENCE

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

Standard

Enterprise

Business Critical

Virtual Private Snowflake

Q72. Which statement is true about running tasks in Snowflake?

A task can be called using a CALL statement to run a set of predefined SQL commands.

A task allows a user to execute a single SQL statement/command using a predefined schedule.

A task allows a user to execute a set of SQL commands on a predefined schedule.

A task can be executed using a SELECT statement to run a predefined SQL command.

Q73. True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

True

False

Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

Q74. What is the purpose of an External Function?

To call code that executes outside of Snowflake

To run a function in another Snowflake database

To share data in Snowflake with external parties

To ingest data from on-premises data sources

Explanation
https://docs.snowflake.com/en/sql-reference/external-functions.html

Q75. Which data type can store more than one type of data structure?

JSON

BINARY

VARCHAR

VARIANT

Q76. Using variables in Snowflake is denoted by using which SQL character?

Q77. What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Data is hashed by the cluster key to facilitate fast searches for common data values

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

Smaller micro-partitions are created for common data values to allow for more parallelism

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Q78. During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

STATEMENT_TIMEOUT__IN__SECONDS

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

MAX_CONCURRENCY__LEVEL

QUERY_TIMEOUT_IN_SECONDS

Explanation
The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit.
By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue
https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text

Q79. Where can a user find and review the failed logins of a specific user for the past 30 days?

The USERS view in ACCOUNT_USAGE

The LOGIN_HISTORY view in ACCOUNT_USAGE

The ACCESS_HISTORY view in ACCOUNT_USAGE

The SESSIONS view in ACCOUNT_USAGE

Q80. True or False: Pipes can be suspended and resumed.

True

False

Explanation
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe:

Q81. True or False: An active warehouse is required to run a COPY INTO statement.

True

False

Q82. Which statements are true concerning Snowflake’s underlying cloud infrastructure? (Select THREE),

Snowflake data and services are deployed in a single availability zone within a cloud provider’s region.

Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

Snowflake can be deployed in a customer’s private cloud using the customer’s own compute and storage resources for Snowflake compute and storage

Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

All three layers of Snowflake’s architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

Snowflake data and services are deployed in at least three availability zones within a cloud provider’s region

Q83. Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

The user has the appropriate privileges on the objects associated with the query

Micro-partitions have been reclustered since the query was last run

The new query is run using the same virtual warehouse as the previous query

The query includes a User Defined Function (UDF)

The query has been run within 24 hours of the previously-run query

Q84. When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

10-50 MB

100-250 MB

300-500 MB

1000-1500 MB

Q85. When loading data into Snowflake, how should the data be organized?

Into single files with 100-250 MB of compressed data per file

Into single files with 1-100 MB of compressed data per file

Into files of maximum size of 1 GB of compressed data per file

Into files of maximum size of 4 GB of compressed data per file

Q86. Users are responsible for data storage costs until what occurs?

Data expires from Time Travel

Data expires from Fail-safe

Data is deleted from a table

Data is truncated from a table

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

Metadata cache

Result cache

Remote cache

Local file cache

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

Loading …

Pass Snowflake COF-R02 exam – questions – convert Tets Engine to PDF: https://www.passleadervce.com/SnowPro-Core/reliable-COF-R02-exam-learning-guide.html

Leave a Reply Cancel reply