COF-C03 Practice Test 4 — 10 Questions

Question 1

Refer to the exhibit. Based on the JSON configuration for this Snowflake listing, who will be able to discover and access this data?

Accepted Answer

Only the specific accounts 'ORG_A.ACCOUNT_1' and 'ORG_B.ACCOUNT_2'.. The exhibit defines a Private Listing. Private listings are not visible in the public Snowflake Marketplace. Instead, they are only discoverable by the specific accounts listed in the 'target_accounts' array. This allows providers to use the Marketplace interface and management tools to share data with specific partners securely, without making the offering public to the entire Snowflake community.

Answer

Any Snowflake customer in the same region as the provider.

Answer

Only the users within the provider's own Snowflake account.

Answer

All accounts belonging to ORG_A and ORG_B, regardless of the individual account names.

Question 2

What is the primary role of the 'ORGANIZATIONADMIN' role in Snowflake?

Accepted Answer

To perform account-level management across the organization.. The ORGANIZATIONADMIN (ORGADMIN) role is responsible for managing tasks at the account-level across the entire organization. This includes creating and managing multiple accounts, monitoring organizational usage, and configuring global replication. This role is highly privileged and exists above the ACCOUNTADMIN level, allowing for centralized control over the enterprise's Snowflake footprint while maintaining segregation between different business units or environments within the same organization.

Answer

To manage data access within a single account.

Answer

To query all data across the entire organization.

Answer

To assign roles to users within a single database.

Question 3

When considering the implementation of a clustering key on a large table, which TWO scenarios indicate that clustering will provide the most significant performance benefit?

Accepted Answer

Queries against the table typically filter on a specific dimension column.. Clustering is most effective for large tables (typically multi-terabyte) where query performance has degraded over time due to poor data grouping. It benefits queries that use selective filters on specific columns, as it allows the optimizer to skip a high percentage of micro-partitions that do not contain relevant data.

Answer

The table is frequently updated with small DML operations.

Answer

The table size is less than 50 GB and fits in the local cache.

Answer

The table is used exclusively for full table scans and exports.

Question 4

Which component of the Snowflake architecture is responsible for managing data integrity, query optimization, and transaction management?

Accepted Answer

Cloud Services Layer. The Cloud Services layer acts as the 'brain' of Snowflake. It handles all authentication, metadata management, access control, and query optimization. By centralizing these tasks, the architecture keeps the compute layer decoupled and stateless. This is fundamental to Snowflake's design, as it allows users to perform DDL and DML operations, maintain security, and optimize query plans without requiring management of the underlying hardware or software infrastructure.

Answer

Compute Layer

Answer

Storage Layer

Answer

Database Layer

Question 5

A provider wants to share data with a consumer using a Direct Share. Which two statements accurately describe the consumer's experience after the share is mounted? (Choose two.)

Accepted Answer

The consumer can view the share's objects without any additional storage cost for the shared data.. With Direct Sharing, the consumer mounts a read-only database and queries it using their own compute. Storage remains with the provider, so the consumer incurs no storage cost for the shared data. The consumer cannot modify shared objects or add objects inside the shared database, which distinguishes sharing from copying data.

Answer

The consumer can modify the shared data directly because they own the mounted database.

Answer

The consumer must copy the shared data into their own tables before querying it.

Answer

The consumer can create their own tables in the same schema as the shared objects.

Question 6

A company wants to enforce that all data in a specific schema is protected by a data classification tag before it can be queried by analysts. The security team has created a tag named DATA_CLASS and a masking policy associated with that tag. Analysts report they can still see raw values in some columns. What is the most likely cause?

Accepted Answer

The masking policy was created but not associated with the DATA_CLASS tag.. Tag-based masking requires the masking policy to be attached to the tag. Creating both objects without linking them leaves tagged columns unmasked. The fix is to associate the policy with the tag so that every column carrying the tag is automatically protected.

Answer

The masking policy uses CURRENT_ROLE() and the analysts are using a role that is not listed in the policy's allowed roles.

Answer

The analysts have been granted the APPLY MASKING POLICY privilege on the tag.

Answer

The DATA_CLASS tag was created in a different database than the schema being protected.

Question 7

A developer is building a Change Data Capture (CDC) pipeline using Snowflake. Which TWO features are required to ensure that only new or modified data is processed and that the processing logic runs automatically whenever data arrives?

Accepted Answer

Streams. Modern data pipelines in Snowflake rely on the synergy between Streams and Tasks to achieve efficient CDC. Streams provide the ability to track changes at the row level without manual versioning, while Tasks provide the scheduling and execution framework. Together, they allow for automated, incremental processing that reduces latency and optimizes resource consumption.

Answer

External Tables

Answer

Stored Procedures

Answer

Dynamic Tables

Question 8

For optimal parallel loading performance using a Snowflake virtual warehouse, what is the generally recommended compressed file size range for data files in a stage?

Accepted Answer

10MB to 100MB. Snowflake's architecture is optimized for parallel processing, where each execution thread in a warehouse can process a separate file. To maximize this parallelism and avoid overhead, it is recommended to aim for file sizes between 10MB and 100MB when compressed. This ensures that the workload is distributed evenly across all available compute nodes without overwhelming the system with metadata management.

Answer

1KB to 100KB

Answer

1GB to 5GB

Answer

Exactly 256MB to match HDFS blocks

Question 9

Which component is responsible for orchestrating the lifecycle of a virtual warehouse, including start and stop operations?

Accepted Answer

The Cloud Services layer. The Cloud Services layer orchestrates the life cycle of virtual warehouses. When a query is received, the Cloud Services layer determines if the warehouse is running; if not, it triggers the start process. This is part of the 'serverless' experience Snowflake provides, allowing users to interact with the platform without manually managing compute resources. This automation is vital for maintaining high availability while optimizing cost through automated suspension and resumption.

Answer

The Storage layer

Answer

The Compute layer

Answer

The Object Storage API

Question 10

A Snowflake user needs to query data stored in an external cloud storage location (e.g., Amazon S3) without loading it into Snowflake tables. They want to minimize data movement and cost. Which Snowflake feature should they use?

Accepted Answer

External Tables. External tables enable querying data in external cloud storage directly, without loading it into Snowflake. This reduces data movement and cost because the data stays in its original location. Internal stages, materialized views, and Snowpipe all involve loading or storing data within Snowflake, which does not meet the requirement.

Answer

Snowpipe

Answer

Materialized Views

Answer

Internal Stages