[Dec 30, 2022] Reliable COF-R02 Exam Tips Test Pdf Exam Material [Q151-Q175]

December 30, 2022 COF-R02, Snowflake 0 Comments

[Dec 30, 2022] Reliable COF-R02 Exam Tips Test Pdf Exam Material [Q151-Q175]

4.6/5 - (5 votes)

[Dec 30, 2022] Reliable COF-R02 Exam Tips Test Pdf Exam Material

New 2022 COF-R02 Test Tutorial (Updated 332 Questions)

NEW QUESTION 151
The Snowflake Cloud Data Platform is described as having which of the following architectures?

Shared-disk

Shared-nothing

Multi-cluster shared data

Serverless query engine

NEW QUESTION 152
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

VIEWS_HISTORY

OBJECT_HISTORY

ACCESS_HISTORY

LOGIN_HISTORY

NEW QUESTION 153
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

30 days

7 days

48 hours

24 hours

NEW QUESTION 154
What affects whether the query results cache can be used?

If the query contains a deterministic function

If the virtual warehouse has been suspended

If the referenced data in the table has changed

If multiple users are using the same virtual warehouse

NEW QUESTION 155
Which of the following statements are true about Schemas in Snowflake? (Choose two.)

A Schema may contain one or more Databases

A Database may contain one or more Schemas

A Schema is a logical grouping of Database Objects

Each Schema is contained within a Warehouse

Reference: https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html

NEW QUESTION 156
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)

JDBC

SnowSQL

Snowflake Web Interface (UI)

ODBC

Python
D18912E1457D5D1DDCBD40AB3BF70D5D

Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html

NEW QUESTION 157
In which use cases does Snowflake apply egress charges?

Data sharing within a specific region

Query result retrieval

Database replication

Loading data into Snowflake

Explanation
Cloud providers apply data egress charges in either of the following use cases:
* Data is transferred from one region to another within the same cloud platform.
* Data is transferred out of the cloud platform.
https://docs.snowflake.com/en/user-guide/billing-data-transfer.html#:~:text=Cloud%20providers%20apply%20d

NEW QUESTION 158
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

NEW QUESTION 159
What features does Snowflake Time Travel enable?

Querying data-related objects that were created within the past 365 days

Restoring data-related objects that have been deleted within the past 90 days

Conducting point-in-time analysis for Bl reporting

Analyzing data usage/manipulation over all periods of time

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

NEW QUESTION 160
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?

4 minutes

10 minutes

14 minutes

24 minutes

NEW QUESTION 161
What is the default file size when unloading data from Snowflake using the COPY command?

5 MB

8 GB

16 MB

32 MB

NEW QUESTION 162
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

Materialized view

Sequence

Secure view

Transient table

Clustered table

NEW QUESTION 163
How often are the Account and Table master keys automatically rotated by Snowflake?

30 Days

60 Days

90 Days

365 Days.

NEW QUESTION 164
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

Users

Tables

Databases

Internal Stages

NEW QUESTION 165
True or False: It is possible to load data into Snowflake without creating a named File Format object.

True

False

Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html

NEW QUESTION 166
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

Concurrency

Performance

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

NEW QUESTION 167
What are common issues found by using the Query Profile? (Choose two.)

Identifying queries that will likely run very slowly before executing them

Locating queries that consume a high amount of credits

Identifying logical issues with the queries

Identifying inefficient micro-partition pruning

Data spilling to a local or remote disk

NEW QUESTION 168
Which of the following describes a Snowflake stored procedure?

They can be created as secure and hide the underlying metadata from the user.

They can only access tables from a single database.

They can contain only a single SQL statement.

They can be created to run with a caller’s rights or an owner’s rights.

Reference: https://docs.snowflake.com/en/sql-reference/stored-procedures-overview.html

NEW QUESTION 169
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

To accommodate more queries

To accommodate more users

To accommodate fluctuations in workload

To accommodate a more complex workload

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

NEW QUESTION 170
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

The warehouse size does not change until all queries currently running in the warehouse have completed.

The warehouse size does not change until all queries currently in the warehouse queue have completed.

The warehouse size does not change until the warehouse is suspended and restarted.

It does not return from the command until the warehouse has finished changing its size.

NEW QUESTION 171
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

NEW QUESTION 172
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

An error will occur, as views with qualified references cannot be cloned.

An error will occur, as stored objects cannot be cloned.

The stored procedures and views will refer to tables in the source database.

NEW QUESTION 173
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

Custom Edition

Virtual Private Snowflake

Business Critical Edition

Standard Edition

Enterprise Edition

NEW QUESTION 174
Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

COPY INTO

CREATE PIPE

INSERT INTO

TABLE STREAM

NEW QUESTION 175
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

Business Critical Edition

Standard Edition

Virtual Private Snowflake (VPS)

Enterprise Edition

Loading …