[Q97-Q118] Pass Your COF-C02 Exam Easily With 100% Exam Passing Guarantee [2024] : Free Exams Dumps Materials : http://exams.dumpsmaterials.com

NO.97 Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

ROLES

POLICY_REFERENCES

QUERY_HISTORY

RESOURCE_MONIT ORS

ACCESS_HISTORY

NO.98 Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.
How does Snowflake recommend resolving this issue?

Scale up the existing warehouse.

Create separate warehouses for each user.

Create separate warehouses for each workload.

Stop loading and querying data at the same time.

NO.99 How many resource monitors can be assigned at the account level?

1

2

3

4

NO.100 What are the main differences between the account usage views and the information schema views? (Select TWO).

No active warehouse to needed to query account usage views but one is needed to query information schema views.

Account usage views do not contain data about tables but information schema views do.

Account issue views contain dropped objects but information schema views do not.

Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.

Information schema views are read-only but account usage views are not.

NO.101 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

Store the files on the external stage to ensure caching is maintained

Use pattern matching for regular expression execution

Load the data in one large file

NO.102 How long can a data consumer who has a pre-signed URL access data files using Snowflake?

Indefinitely

Until the result_cache expires

Until the retention_time is met

Until the expiration time is exceeded

NO.103 When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

When users will be using compute at different times throughout a 24/7 period

When managing a steady workload

When the compute must be available with no delay or lag time

When you don’t want to have to manually turn on the Warehouse each time a user needs it

NO.104 Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

Internal stages

Incremental backups

Time Travel

Zero-copy clones

Fail-safe

NO.105 How many days is load history for Snowpipe retained?

1 day

7 days

14 days

64 days

NO.106 How would a user run a multi-cluster warehouse in maximized mode?

Configure the maximum clusters setting to “Maximum.”

Turn on the additional clusters manually after starting the warehouse.

Set the minimum Clusters and maximum Clusters settings to the same value.

Set the minimum clusters and maximum clusters settings to different values.

NO.107 Which Snowflake objects can be restored using Time Travel? (Select VNO).

Roles

Users

Databases

Schemas

Virtual warehouses

NO.108 What feature can be used to reorganize a very large table on one or more columns?

Micro-partitions

Clustering keys

Key partitions

Clustered partitions

NO.109 Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

Files

External tables

Secure User-Defined Functions (UDFs)

Sequences

Streams

NO.110 What will happen if a Snowflake user increases the size of a suspended virtual warehouse?

The provisioning of new compute resources for the warehouse will begin immediately.

The warehouse will remain suspended but new resources will be added to the query acceleration service.

The provisioning of additional compute resources will be in effect when the warehouse is next resumed.

The warehouse will resume immediately and start to share the compute load with other running virtual warehouses.

NO.111 How long is the Fail-safe period for temporary and transient tables?

There is no Fail-safe period for these tables.

1 day

7 days

31 days

90 days

NO.112 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

NO.113 Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?

Data classification

Query acceleration service

Search optimization service

Tagging

NO.114 What is cached during a query on a virtual warehouse?

All columns in a micro-partition

Any columns accessed during the query

The columns in the result set of the query

All rows accessed during the query

NO.115 A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

Increase the warehouse size from Medium to 2XL.

Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

Configure the warehouse to a multi-cluster warehouse.

Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

NO.116 Which Snowflake table supports unstructured data?