Snowflake SnowPro Core COF-C03 Practice Test 49
Question 480
[Partner onboarding review] A privacy reviewer checks a collaboration rollout before new partner access is granted. A multinational organization requires a recoverable approved dataset in another supported Snowflake account region for resilience planning. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which Snowflake action best meets this specific requirement?
- Use zero-copy cloning for an authorized internal copy and distinguish it from a cross-account secure share.
- Create a supported zero-copy clone of the database or selected schema and track later divergence.
- Evaluate and provision a Snowflake reader account with authorized shares and documented provider billing responsibilities.
- Configure supported database or account replication and plan promotion or failover procedures for the desired recovery objectives.
Explanation
Correct Answer
D:Replication moves supported data and metadata across account or region boundaries and differs from a local zero-copy clone. In this partner onboarding review setting, the intended validation is: Replication status and a controlled secondary-account query confirm the expected dataset and documented lag.
Incorrect Answers
A:That action is relevant when A data owner must provide its internal analytics team with an independently modifiable copy of a large dataset for an experiment. Replication moves supported data and metadata across account or region boundaries and differs from a local zero-copy clone.
B:That action is relevant when A product team needs a quick editable test copy of a large database but cannot afford to duplicate all stored bytes immediately. It is not the primary action for the stated replication across regions for availability need.
C:That action is relevant when A small research partner needs curated data but has no existing Snowflake account and the provider wants a controlled hosted-consumer path. It is not the primary action for the stated replication across regions for availability need.
Question 481
[Architecture planning workshop] An internal platform architecture group is assessing the initial design. A risk team must retain a permanent table's recoverable history for more than one day and also wants enterprise governance capabilities. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which specific design mistake would most directly defeat the intended result?
- Set a 90-day retention value in an unsupported edition and presume the statement will override product limits.
- Put a window function directly inside a WHERE predicate and assume WHERE executes after window evaluation.
- Run an ordinary current-state SELECT and claim it reconstructs the overwritten values without a historical reference.
- Assume ordinary SQL grants automatically create a private cloud endpoint or satisfy infrastructure-level isolation requirements.
Explanation
Correct Answer
A:The supportable direction is: Confirm that the account edition and object support the requested extended Time Travel retention, then set a supported retention period. The discriminating technical reason is: Extended retention for permanent objects is edition-dependent; selecting an appropriate edition precedes setting a longer recoverability window.
Incorrect Answers
B:That is a mistake for a different qualify after window expression task, where A table contains several rows per customer and an analyst wants exactly the latest row for each customer after computing ROW_NUMBER. Under architecture planning workshop conditions, Put a window function directly inside a WHERE predicate and assume WHERE executes after window evaluation.
C:Under architecture planning workshop conditions, Run an ordinary current-state SELECT and claim it reconstructs the overwritten values without a historical reference.
D:That is a mistake for a different business critical private connectivity task, where A financial-services project requires a supported private connectivity pattern and enhanced compliance options rather than access from arbitrary public networks. Under architecture planning workshop conditions, Assume ordinary SQL grants automatically create a private cloud endpoint or satisfy infrastructure-level isolation requirements.
Question 482
[Production compliance review] A compliance reviewer is checking which safeguard actually enforces the stated boundary. A user has an approved reporting role and a separate engineering role but a worksheet unexpectedly lacks SELECT even though the second role has the grant. The conclusion must be justified with observable verification rather than an undocumented assumption. Which specific design mistake would most directly defeat the intended result?
- Give the general reporting group SECURITYADMIN to avoid maintaining a custom analysis role.
- Resize the warehouse without checking session role activation because compute can substitute for a dormant access role.
- Use a temporary table as a long-lived shared data contract for a scheduled job that opens a new session.
- Duplicate broad ACCOUNTADMIN grants to every role and assume inheritance cannot be inspected.
Explanation
Correct Answer
B:The supportable direction is: Inspect the active primary role and secondary-role configuration rather than assuming all granted roles participate in each statement. This directly undermines primary and secondary role session in the specified context.
Incorrect Answers
A:Under production compliance review conditions, Give the general reporting group SECURITYADMIN to avoid maintaining a custom analysis role.
C:That is a mistake for a different temporary session-bound data task, where A SQL worksheet needs a scratch table only for calculations performed in a single session and must not expose it as a durable shared object. Under production compliance review conditions, Use a temporary table as a long-lived shared data contract for a scheduled job that opens a new session.
D:Under production compliance review conditions, Duplicate broad ACCOUNTADMIN grants to every role and assume inheritance cannot be inspected. That is a mistake for a different inherited functional role grants task, where A data science team needs the privileges of its reader role plus a limited set of model-development privileges without maintaining a duplicate grant list.
Question 483
[Query performance review] A performance engineer is benchmarking representative queries before accepting changes. Python engineers built Snowpark DataFrame transformations and want to avoid accidental collection of millions of protected records to a laptop. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which specific design mistake would most directly defeat the intended result?
- Enable an extra data analyst role and assume it automatically creates a cloud PrivateLink endpoint.
- Assume a standard tiny warehouse can execute an arbitrary in-memory dataframe operation regardless of memory demand.
- Call collect on the entire raw table first and assume all later dataframe operations still execute inside Snowflake.
- Treat the suspended warehouse's local cache as a permanent table copy that must remain available after shutdown.
Explanation
Correct Answer
C:The discriminating technical reason is: Snowpark can execute supported transformations near governed data; eager client collection changes scale and exposure risks. The supportable direction is: Keep supported DataFrame operations in Snowflake and inspect query execution before invoking local collect operations.
Incorrect Answers
A:That is a mistake for a different private network endpoint verification task, where A sensitive integration requires clients to use supported private cloud networking instead of routing all traffic through public endpoints. Under query performance review conditions, Enable an extra data analyst role and assume it automatically creates a cloud PrivateLink endpoint.
B:That is a mistake for a different snowpark optimized workload isolation task, where A Python Snowpark pipeline uses large in-memory intermediate processing and repeatedly runs out of memory on a standard virtual warehouse. Under query performance review conditions, Assume a standard tiny warehouse can execute an arbitrary in-memory dataframe operation regardless of memory demand.
D:That is a mistake for a different warehouse local data cache task, where A repeated large scan runs faster on the same warm warehouse, but the speedup disappears after the warehouse has been suspended. Under query performance review conditions, Treat the suspended warehouse's local cache as a permanent table copy that must remain available after shutdown.
Question 484
[Post-rollout service review] A reviewer recommends: Build a supported Cortex Search service over appropriately prepared text and filterable metadata. The requirement remains: An operations group is reassessing the installed data platform after a representative workload trial. A support application must retrieve relevant passages from a collection of policy documents to ground an answer. The conclusion must be justified with observable verification rather than an undocumented assumption. Which explanation best justifies this recommendation?
- Cortex Analyst is oriented toward analytical natural-language questions over modeled structured data, not an ungoverned document search engine.
- A generative or summarization function fits a text transformation task, whereas a SQL COUNT does not express a message summary.
- Hybrid tables support row-oriented transactional use cases that differ from purely analytical columnar standard tables.
- Cortex Search is designed for low-latency hybrid document/text retrieval, which differs from semantic text-to-SQL analytics.
Explanation
Correct Answer
D:In this post-rollout service review context, Cortex Search is designed for low-latency hybrid document/text retrieval, which differs from semantic text-to-SQL analytics. The recommendation is linked to observable evidence for this exact case: Queries return relevant authorized passages and identifiers that the application can cite or display to reviewers. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:That option concerns cortex analyst structured nl-to-sql, not the requirement in this case. It does not justify the specific cortex search document retrieval action or its validation path: Queries return relevant authorized passages and identifiers that the application can cite or display to reviewers.
B:That option concerns cortex generative text operation, not the requirement in this case. It does not justify the specific cortex search document retrieval action or its validation path: Queries return relevant authorized passages and identifiers that the application can cite or display to reviewers.
C:That option concerns hybrid table transactional access, not the requirement in this case. It does not justify the specific cortex search document retrieval action or its validation path: Queries return relevant authorized passages and identifiers that the application can cite or display to reviewers.
Question 485
[Security control assessment] The team proposes: Configure a supported federated SSO security integration and verify identity, certificates, and account routing. Its actual requirement is: A quarterly access-control audit requires an evidence-backed answer. An enterprise uses a corporate identity provider and wants centrally controlled employee login instead of unmanaged separate passwords. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which observation most directly validates success?
- A test user signs in through the approved identity provider and receives only the expected Snowflake role access.
- A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured.
- The reader account signs in and queries the intended shared database while billing and warehouse usage are monitored by the provider.
- Analyst queries work under the custom role while CREATE WAREHOUSE and global role-management attempts are denied.
Explanation
Correct Answer
A:A test user signs in through the approved identity provider and receives only the expected Snowflake role access. This is an outcome test of the specified federated single sign-on action under the security control assessment conditions. Federated authentication delegates sign-in to the organization's identity provider while object access still depends on Snowflake roles.
Incorrect Answers
B:In this security control assessment context, A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured. This is an outcome for a different requirement: An unattended ingestion service needs noninteractive authentication without embedding an employee's reusable password into scripts. It cannot by itself validate the proposed federated single sign-on action; the appropriate test is: A test user signs in through the approved identity provider and receives only the expected Snowflake role access.
C:In this security control assessment context, The reader account signs in and queries the intended shared database while billing and warehouse usage are monitored by the provider. This is an outcome for a different requirement: A small research partner needs curated data but has no existing Snowflake account and the provider wants a controlled hosted-consumer path. It cannot by itself validate the proposed federated single sign-on action; the appropriate test is: A test user signs in through the approved identity provider and receives only the expected Snowflake role access.
D:In this security control assessment context, Analyst queries work under the custom role while CREATE WAREHOUSE and global role-management attempts are denied. This is an outcome for a different requirement: A new team proposes using SYSADMIN as the day-to-day analyst role solely because it conveniently creates warehouses. It cannot by itself validate the proposed federated single sign-on action; the appropriate test is: A test user signs in through the approved identity provider and receives only the expected Snowflake role access.
Question 486
[Security control assessment] A quarterly access-control audit requires an evidence-backed answer. An unattended ingestion service needs noninteractive authentication without embedding an employee's reusable password into scripts. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which Snowflake action best meets this specific requirement?
- Configure a supported federated SSO security integration and verify identity, certificates, and account routing.
- Use an appropriately supported programmatic identity with managed key-pair authentication and rotation controls.
- Configure an authorized storage integration and external stage with the required cloud trust and path restrictions.
- Evaluate a Snowpark-optimized warehouse with adequate memory and workload-specific configuration.
Explanation
Correct Answer
B:Key-pair authentication supports service access while avoiding hard-coded interactive user passwords, subject to secure private-key handling. In this security control assessment setting, the intended validation is: A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured.
Incorrect Answers
A:That action is relevant when An enterprise uses a corporate identity provider and wants centrally controlled employee login instead of unmanaged separate passwords. It is not the primary action for the stated workload identity key-pair authentication need.
C:That action is relevant when A cloud operations group needs to load CSVs from a controlled S3 bucket but security prohibits permanent cloud storage secrets in SQL scripts. Key-pair authentication supports service access while avoiding hard-coded interactive user passwords, subject to secure private-key handling.
D:That action is relevant when A Python Snowpark pipeline uses large in-memory intermediate processing and repeatedly runs out of memory on a standard virtual warehouse. Key-pair authentication supports service access while avoiding hard-coded interactive user passwords, subject to secure private-key handling.
Question 487
[Query performance review] A reviewer recommends: Inspect pruning and the overlap of the filter column's values, then tune a supported clustering strategy if warranted. The requirement remains: A performance engineer is benchmarking representative queries before accepting changes. A daily operational report filters on a narrow event-time range yet scans nearly the entire multi-terabyte event table. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which explanation best justifies this recommendation?
- Automatic Clustering may improve partition organization for repeated filters, but maintenance consumes credits and is not free on every table.
- Stored procedures are suited to multi-statement procedural logic; ordinary scalar UDFs have different side-effect and execution constraints.
- Partition metadata lets Snowflake skip micro-partitions whose ranges cannot satisfy the filter, but scattered values limit effective pruning.
- QUALIFY filters the results of window functions in Snowflake and is suited to post-window row selection.
Explanation
Correct Answer
C:In this query performance review context, Partition metadata lets Snowflake skip micro-partitions whose ranges cannot satisfy the filter, but scattered values limit effective pruning. The recommendation is linked to observable evidence for this exact case: The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:That option concerns automatic clustering cost tradeoff, not the requirement in this case. It does not justify the specific selective filter micro-partition pruning action or its validation path: The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work.
B:That option concerns stored procedure multi-step operation, not the requirement in this case. It does not justify the specific selective filter micro-partition pruning action or its validation path: The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work.
D:That option concerns qualify after window expression, not the requirement in this case. It does not justify the specific selective filter micro-partition pruning action or its validation path: The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work.
Question 488
[Ingestion design acceptance] A data engineering team is checking the design before promoting a pipeline. A team needs a stable staging location where several engineers can PUT source files and run repeatable bulk loads for the same project. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which specific design mistake would most directly defeat the intended result?
- Use an unrelated Snowflake warehouse as a file-storage namespace and assume tables automatically locate files by warehouse.
- Treat a SELECT against an empty user table as a guaranteed live list of all PDFs in unrelated cloud buckets.
- Specify JSON as the file format for this delimited feed and expect COPY to infer the entire quoting contract.
- Rely on one engineer's user stage as a durable team-owned contract without assigning the required permissions.
Explanation
Correct Answer
D:The supportable direction is: Create an appropriately permissioned named internal stage and define a compatible file format for the incoming files. This directly undermines named internal stage for file reuse in the specified context.
Incorrect Answers
A:Under ingestion design acceptance conditions, Use an unrelated Snowflake warehouse as a file-storage namespace and assume tables automatically locate files by warehouse.
B:That is a mistake for a different directory table unstructured metadata task, where A document processing workflow keeps PDFs on a Snowflake stage and needs a queryable inventory of staged files before extraction. Under ingestion design acceptance conditions, Treat a SELECT against an empty user table as a guaranteed live list of all PDFs in unrelated cloud buckets.
C:That is a mistake for a different reusable csv file format task, where One source feed uses pipe-delimited UTF-8 files with a header and quoted embedded delimiters, and every daily load must interpret them consistently. Under ingestion design acceptance conditions, Specify JSON as the file format for this delimited feed and expect COPY to infer the entire quoting contract.
Question 489
[Production cutover rehearsal] A data integration group runs a controlled replay with representative files or events. A financial batch is required to fail atomically when any unexpected malformed source record appears rather than silently omit data. The conclusion must be justified with observable verification rather than an undocumented assumption. Which Snowflake action best meets this specific requirement?
- Select a strict COPY INTO error policy such as ABORT_STATEMENT and reconcile source counts before releasing downstream results.
- Use Snowflake's load metadata/history and carefully controlled COPY retry behavior to identify already ingested files.
- Use an appropriate permanent table with supported Time Travel retention and understand its Fail-safe protection.
- Use zero-copy cloning for an authorized internal copy and distinguish it from a cross-account secure share.
Explanation
Correct Answer
A:COPY error behavior determines whether load execution aborts or continues past bad rows; strict policy fits completeness-sensitive feeds. In this production cutover rehearsal setting, the intended validation is: The malformed test file causes the controlled load to abort without accepting an incomplete batch of financial rows.
Incorrect Answers
B:That action is relevant when A nightly pipeline may retry an earlier bulk load after a network timeout and must avoid inadvertently duplicating files that were already committed. It is not the primary action for the stated copy into error-handling choice need.
C:That action is relevant when An audited production dataset requires recovery mechanisms beyond a short staging lifecycle, and accidental deletion is a realistic threat. It is not the primary action for the stated copy into error-handling choice need.
D:That action is relevant when A data owner must provide its internal analytics team with an independently modifiable copy of a large dataset for an experiment. It is not the primary action for the stated copy into error-handling choice need.
Question 490
[Pipeline incident investigation] An on-call ingestion engineer needs a targeted fix that preserves source-to-target reconciliation. A third-party reporting product accepts standard database connectivity drivers and needs Snowflake queries under a service identity. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which Snowflake action best meets this specific requirement?
- Configure an appropriate OAuth authorization flow and token scopes along with Snowflake role privileges.
- Install and configure the appropriate Snowflake JDBC or ODBC driver, connection parameters, and least-privilege role.
- Configure an authorized storage integration and external stage with the required cloud trust and path restrictions.
- Create a narrowly scoped reader role with USAGE on parent containers and SELECT on the approved view, then grant it to the user.
Explanation
Correct Answer
B:Standard drivers provide supported client SQL connectivity; the correct account, network, authentication, and role settings remain mandatory. In this pipeline incident investigation setting, the intended validation is: A connection test reaches the expected account and a low-risk SELECT returns rows authorized for the service identity.
Incorrect Answers
A:That action is relevant when A managed business application requires scoped delegated Snowflake access on behalf of an authorized person without collecting their database password. It is not the primary action for the stated jdbc or odbc application connection need.
C:That action is relevant when A cloud operations group needs to load CSVs from a controlled S3 bucket but security prohibits permanent cloud storage secrets in SQL scripts. Standard drivers provide supported client SQL connectivity; the correct account, network, authentication, and role settings remain mandatory.
D:That action is relevant when A finance analyst needs SELECT on a curated reporting view but must not modify the underlying transactions table or own the database. It is not the primary action for the stated jdbc or odbc application connection need.