Free Practice Questions for Snowflake COF-C03 Exam

The correct answer is D. To control the potential costs associated with the Query Acceleration Service .

The Query Acceleration Service can use additional Snowflake-managed compute resources to accelerate eligible queries. The scale factor setting controls the maximum amount of additional compute that can be used relative to the warehouse.

Why D is correct:

A higher scale factor allows more acceleration resources to be used, which can improve performance but may increase credit consumption. A lower scale factor limits the amount of extra compute used, helping control cost.

Example concept:

ALTER WAREHOUSE my_wh

SET ENABLE_QUERY_ACCELERATION = TRUE

QUERY_ACCELERATION_MAX_SCALE_FACTOR = 4;

This limits the maximum acceleration scale factor for the warehouse.

Why the other options are incorrect:

A. Query Acceleration Service does not create clustering keys.

B. The scale factor does not control how many users can use the service.

C. The scale factor does not resize the virtual warehouse itself. It limits additional query acceleration resources.

Official Snowflake documentation reference:

Snowflake documentation explains that QUERY_ACCELERATION_MAX_SCALE_FACTOR limits the amount of compute resources that can be used by the Query Acceleration Service for a warehouse, which helps control cost.

In Snowflake, a table ' s clustering depth indicates the degree of micro-partition overlap based on the clustering keys defined for the table. A clustering depth of 1 implies that the table has no overlapping micro-partitions. This is an optimal scenario, indicating that the table ' s data is well-clustered according to the specified clustering keys. Well-clustered data can lead to more efficient query performance, as it reduces the amount of data scanned during query execution and improves the effectiveness of data pruning.

A materialized view stores precomputed results and is useful when a query is repeated and the underlying table does not change often. Since the query runs calculations on a stable table, materializing the result can reduce repeated computation.

To change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse, the warehouse must be in a suspended state. This ensures that no operations are disrupted during the modification process.

Suspend the Warehouse:Ensure that the warehouse is suspended.

ALTER WAREHOUSE my_warehouse SUSPEND;

Alter the Warehouse:Modify the warehouse to be Snowpark-optimized.

ALTER WAREHOUSE my_warehouse SET WAREHOUSE_TYPE = ' SNOWPARK-OPTIMIZED ' ;

Resume the Warehouse:Resume the warehouse to make it operational.

ALTER WAREHOUSE my_warehouse RESUME;

For Snowpipe auto-ingest on Amazon S3, cloud event notifications are configured so Snowflake is notified when new files arrive. The pipe must also be created with AUTO_INGEST = TRUE.

Why A and D are correct:

Amazon S3 event notifications can publish file arrival events through Amazon SNS/SQS integration, and Snowpipe uses those notifications when AUTO_INGEST is enabled.

Replication and failover groups are used to replicate databases and supported account-level objects across accounts, regions, and cloud platforms. Failover groups support disaster recovery by allowing clients and workloads to be redirected to a secondary account.

Snowflake warehouses can use different warehouse types and resource constraints. Snowpark-optimized warehouses use warehouse properties such as WAREHOUSE_TYPE and RESOURCE_CONSTRAINT to define the compute configuration.

The correct answer is C. A role with the OWNERSHIP privilege on the database .

A database role is scoped to a specific database. To create a database role, a role must have sufficient privileges on the database where the database role will be created.

Why C is correct:

The role that owns the database has control over that database and can create database roles within it.

Example:

CREATE DATABASE ROLE my_database.my_db_role;

To run this successfully, the executing role must have the required privilege on the database, such as OWNERSHIP.

Why the other options are incorrect:

A. SECURITYADMIN manages users, roles, and grants at the account level, but database role creation depends on privileges on the specific database.

B. A custom role being granted to SECURITYADMIN does not automatically mean it can create database roles in a database.

D. SYSADMIN commonly owns many account objects by default in recommended role models, but the required condition is privilege on the database, not simply holding the SYSADMIN role.

Official Snowflake documentation reference:

Snowflake documentation explains that database roles are created inside databases and require appropriate privileges on the database.

The correct answer is B. Processing: 51.8% .

A high percentage of query time spent in Processing indicates that the query is spending significant time on CPU-intensive work, such as joins, aggregations, sorting, window functions, or expression evaluation. Increasing the virtual warehouse size can provide more compute resources and may reduce processing time.

Why B is correct:

If the Query Profile shows a large portion of time spent in processing, scaling up the warehouse can help because a larger warehouse provides more compute power.

Why the other options are incorrect:

A. A high percentage scanned from cache is generally positive. It means much of the data was served from cache instead of remote storage.

C. High remote disk I/O may indicate data is being read from remote storage. Increasing warehouse size may not be the first or best fix; improving pruning, clustering, filters, or reducing scanned data may be more appropriate.

D. Bytes Scanned: 3.24 GB by itself is not enough to justify increasing warehouse size. The reason to scale up is usually compute pressure, not simply a raw scan number.

Official Snowflake documentation reference:

Snowflake documentation explains that Query Profile helps identify time spent in processing, local disk I/O, remote disk I/O, synchronization, and other execution categories. Increasing warehouse size can help when queries are constrained by compute processing.

To list all network policies available in an account, the correct command isSHOW NETWORK POLICIES. Network policies in Snowflake are used to define and enforce rules for how users can connect to Snowflake, including IP whitelisting and other connection requirements. TheSHOW NETWORK POLICIEScommand provides a list of all network policies defined within the account, along with their details.

TheDESCRIBE SESSION POLICYandDESCRIBE NETWORK POLICYcommands do not exist in Snowflake SQL syntax. TheSHOW SESSION POLICIEScommand is also incorrect, as it does not pertain to the correct naming convention used by Snowflake for network policy management.

UsingSHOW NETWORK POLICIESwithout any additional parameters will display all network policies in the account, which is useful for administrators to review and manage the security configurations pertaining to network access.

Masking policies in Snowflake are created and applied at the column level. These policies are used to obfuscate sensitive data by masking the values in a specific column. Masking policies can enforce data privacy and protection measures by dynamically masking the data based on the role of the user querying the data.

Snowflake Documentation: Dynamic Data Masking

Thefile formatoption in Snowflake can be specified in the following commands:

CREATE STAGE: This command allows users to define the file format when creating a stage, which applies to any data loaded or unloaded via that stage.

COPY INTO < location > : This command enables data export from a table to an external location, where the file format can be specified to ensure the data is structured as needed for downstream systems.

Other commands, such as PUT or GET, do not support the specification of file formats directly within the command syntax.