Snowflake SnowPro Core COF-C03 Practice Test 30
Question 290
[Peak traffic performance incident] A BI engineer is investigating the exact bottleneck observed under production-like load. A large GROUP BY and join spills extensively to remote storage and takes much longer than expected even without query queueing. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which specific design mistake would most directly defeat the intended result?
- Assume switching on the service guarantees every simple SELECT is accelerated without checking eligibility.
- Add extra multi-cluster warehouses alone to fix a single query's in-memory hash aggregation spill.
- Rewrite every simple SELECT's WHERE clause without investigating the queue that precedes its execution.
- Add idle multi-cluster capacity without investigating the one query's spill or plan shape.
Explanation
Correct Answer
B:The discriminating technical reason is: Remote spill reflects insufficient in-memory execution resources or excessive intermediate data, unlike simple concurrency queue time. This directly undermines remote spill diagnosis in the specified context.
Incorrect Answers
A:That is a mistake for a different query acceleration service suitability task, where Analytical reports experience sporadic expensive, selective scan work that can benefit from offloading qualifying fragments. It does not directly defeat the present remote spill diagnosis requirement, whose proper treatment is: Inspect spill and execution profile, then evaluate more memory, predicate reduction, or join/query restructuring.
C:That is a mistake for a different query queueing load analysis task, where A business-intelligence warehouse serves hundreds of short requests and most end-user delay occurs before the queries actually start. Under peak traffic performance incident conditions, Rewrite every simple SELECT's WHERE clause without investigating the queue that precedes its execution.
D:That is a mistake for a different warehouse scale-up for complex query task, where A warehouse consistently spills intermediate data on a single memory-intensive analytical join while the queue length is close to zero. It does not directly defeat the present remote spill diagnosis requirement, whose proper treatment is: Inspect spill and execution profile, then evaluate more memory, predicate reduction, or join/query restructuring.
Question 291
[Security control assessment] A quarterly access-control audit requires an evidence-backed answer. A security officer needs a centralized view of account configuration risks such as weak account controls and recommended fixes. 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?
- Assume ordinary schema ownership by a developer automatically centralizes every future grant in a managed-access model.
- Grant ACCOUNTADMIN to every analyst to avoid investigating the missing read privilege.
- Resize compute warehouses to hide a missing authentication policy finding from the security dashboard.
- Email unencrypted copies of all source tables nightly and claim that this is the only supported Snowflake collaboration model.
Explanation
Correct Answer
C:The discriminating technical reason is: Trust Center helps surface account security posture risks; it does not independently grant access or repair every issue automatically. This directly undermines trust center posture findings in the specified context.
Incorrect Answers
A:That is a mistake for a different managed access schema grants task, where A governance team wants object owners inside a schema to be unable to distribute arbitrary grants without review by the schema's grant administrator. Under security control assessment conditions, Assume ordinary schema ownership by a developer automatically centralizes every future grant in a managed-access model.
B:That is a mistake for a different least-privilege read role task, where A finance analyst needs SELECT on a curated reporting view but must not modify the underlying transactions table or own the database. Under security control assessment conditions, Grant ACCOUNTADMIN to every analyst to avoid investigating the missing read privilege.
D:That is a mistake for a different direct share cross-account access task, where A Snowflake data provider wants a business partner who already has a Snowflake account to query governed datasets without copying daily CSV exports. Under security control assessment conditions, Email unencrypted copies of all source tables nightly and claim that this is the only supported Snowflake collaboration model.
Question 292
[Collaboration operating audit] A platform owner must demonstrate that the proposed sharing model respects its access and recovery boundary. Two advertisers want to calculate joint audience overlap while preventing either company from freely inspecting the other's raw person-level records. The conclusion must be justified with observable verification rather than an undocumented assumption. 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.
- Evaluate Snowflake Data Exchange or a supported private listing arrangement with approved membership and governance.
- Evaluate and provision a Snowflake reader account with authorized shares and documented provider billing responsibilities.
- Evaluate a Snowflake Data Clean Room with approved collaboration templates and privacy controls for the intended aggregate analysis.
Explanation
Correct Answer
D:Data Clean Rooms enable governed joint analytics with protections around raw participant data and supported query results. In this collaboration operating audit setting, the intended validation is: The approved overlap result returns only permitted aggregate metrics and tests reject prohibited raw-identifier disclosures.
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. It is not the primary action for the stated privacy-preserving data clean room need.
B:That action is relevant when Several subsidiaries must exchange curated datasets inside a controlled organizational community rather than list them publicly. It is not the primary action for the stated privacy-preserving data clean room 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 privacy-preserving data clean room need.
Question 293
[Partner onboarding review] The team proposes: Evaluate and provision a Snowflake reader account with authorized shares and documented provider billing responsibilities. Its actual requirement is: A privacy reviewer checks a collaboration rollout before new partner access is granted. A small research partner needs curated data but has no existing Snowflake account and the provider wants a controlled hosted-consumer path. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which observation most directly validates success?
- The reader account signs in and queries the intended shared database while billing and warehouse usage are monitored by the provider.
- Account region details, provider listing or replication status, and receiver access demonstrate that the target geography was configured.
- A constrained test call reaches the approved gateway and a disallowed endpoint fails the integration restrictions.
- SELECT against the external table returns staged records after location metadata has been refreshed appropriately.
Explanation
Correct Answer
A:Reader accounts can let consumers without their own full Snowflake account access provider-shared data, subject to provisioning and cost controls. This is an outcome test of the specified reader account for external consumer action under the partner onboarding review conditions.
Incorrect Answers
B:In this partner onboarding review context, Account region details, provider listing or replication status, and receiver access demonstrate that the target geography was configured. This is an outcome for a different requirement: A company operates accounts on two clouds and wants to access a dataset from the second account without assuming storage instantly appears in both regions. It cannot by itself validate the proposed reader account for external consumer action; the appropriate test is: The reader account signs in and queries the intended shared database while billing and warehouse usage are monitored by the provider.
C:A constrained test call reaches the approved gateway and a disallowed endpoint fails the integration restrictions. This is an outcome for a different requirement: A Snowflake SQL process must invoke an allowed remote service through an established API gateway, with credentials controlled outside analyst worksheets. It cannot by itself validate the proposed reader account for external consumer action; the appropriate test is: The reader account signs in and queries the intended shared database while billing and warehouse usage are monitored by the provider.
D:In this partner onboarding review context, SELECT against the external table returns staged records after location metadata has been refreshed appropriately. This is an outcome for a different requirement: A data scientist needs governed SQL reads over files remaining in external object storage, without an ordinary Snowflake-managed load step. It cannot by itself validate the proposed reader account for external consumer action; the appropriate test is: The reader account signs in and queries the intended shared database while billing and warehouse usage are monitored by the provider.
Question 294
[Collaboration operating audit] A reviewer recommends: Create and govern a suitable Snowflake Marketplace listing with the intended visibility, terms, and fulfillment model. The requirement remains: A platform owner must demonstrate that the proposed sharing model respects its access and recovery boundary. A publisher needs customers to discover and request an approved dataset through a catalog rather than exchange account identifiers manually. The conclusion must be justified with observable verification rather than an undocumented assumption. Which explanation best justifies this recommendation?
- Native Apps distribute application capabilities with managed privileges and application artifacts under a supported deployment model.
- Listings support discoverability and controlled fulfillment, whereas a basic direct share is generally configured for known accounts.
- Replication moves supported data and metadata across account or region boundaries and differs from a local zero-copy clone.
- Private collaboration environments govern which organizations can discover and share listings beyond simple public marketplace exposure.
Explanation
Correct Answer
B:In this collaboration operating audit context, Listings support discoverability and controlled fulfillment, whereas a basic direct share is generally configured for known accounts. The recommendation is linked to observable evidence for this exact case: An eligible test consumer finds the listing and follows its access or request workflow without unauthorized source-table exposure. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:That option concerns native app distribution to consumers, not the requirement in this case. It does not justify the specific marketplace listing discovery action or its validation path: An eligible test consumer finds the listing and follows its access or request workflow without unauthorized source-table exposure.
C:That option concerns replication across regions for availability, not the requirement in this case. It does not justify the specific marketplace listing discovery action or its validation path: An eligible test consumer finds the listing and follows its access or request workflow without unauthorized source-table exposure.
D:That option concerns private data exchange collaboration, not the requirement in this case. That explanation applies to a different private data exchange collaboration problem: Several subsidiaries must exchange curated datasets inside a controlled organizational community rather than list them publicly.
Question 295
[Pipeline incident investigation] A reviewer recommends: Use COPY INTO a stage or external location from the approved SELECT with an explicit supported file format. The requirement remains: An on-call ingestion engineer needs a targeted fix that preserves source-to-target reconciliation. A downstream finance application requires an export of curated query results to an approved cloud storage path for a partner batch job. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which explanation best justifies this recommendation?
- Cloning provides an independent object snapshot with shared initial storage, while secure sharing is primarily provider-controlled consumption.
- A table stage gives a convenient table-associated internal landing location without creating a separate named stage.
- Snowflake's unload form of COPY INTO writes query results to staged files, unlike loading COPY INTO table from staged files.
- Validation mode checks parsing and load conditions for supported files without making the ordinary production table mutation.
Explanation
Correct Answer
C:In this pipeline incident investigation context, Snowflake's unload form of COPY INTO writes query results to staged files, unlike loading COPY INTO table from staged files. The recommendation is linked to observable evidence for this exact case: The exported object files have the expected schema, row counts, and authorized destination path. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:That option concerns zero-copy clone lifecycle in collaboration, not the requirement in this case. It does not justify the specific copy into location for unload action or its validation path: The exported object files have the expected schema, row counts, and authorized destination path.
B:That option concerns table stage file landing, not the requirement in this case. It does not justify the specific copy into location for unload action or its validation path: The exported object files have the expected schema, row counts, and authorized destination path.
D:That option concerns copy into validation preflight, not the requirement in this case. That explanation applies to a different copy into validation preflight problem: A 20GB batch contains uncertain date strings and the operator needs to discover load errors without committing partially incorrect target records.
Question 296
[Optimization regression test] A team is validating a targeted tuning plan against documented workloads and costs. A repeated large scan runs faster on the same warm warehouse, but the speedup disappears after the warehouse has been suspended. The conclusion must be justified with observable verification rather than an undocumented assumption. Which Snowflake action best meets this specific requirement?
- Test a larger warehouse size or a more efficient query plan to give the expensive join adequate resources.
- Inspect persisted query result cache eligibility, deterministic SQL, underlying data changes, and result reuse settings.
- Keep data in managed database storage and resume compute only when processing is needed.
- Account for local warehouse data-cache loss across suspension, and test steady-state cost/performance without assuming persistence.
Explanation
Correct Answer
D:Warehouse cache is local compute storage and is not the durable persisted-query-result cache or underlying table storage.
Incorrect Answers
A:That action is relevant when A warehouse consistently spills intermediate data on a single memory-intensive analytical join while the queue length is close to zero. It is not the primary action for the stated warehouse local data cache need.
B:That action is relevant when A team reruns an unchanged SELECT but sometimes receives cached results and sometimes spends compute again after underlying data changes. It is not the primary action for the stated warehouse local data cache need.
C:That action is relevant when An administrator suspends every reporting warehouse overnight and the operations manager fears that previously committed tables will be erased. It is not the primary action for the stated warehouse local data cache need.
Question 297
[Security control assessment] A quarterly access-control audit requires an evidence-backed answer. 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 reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which Snowflake action best meets this specific requirement?
- Inspect the active primary role and secondary-role configuration rather than assuming all granted roles participate in each statement.
- Create a clear role hierarchy and grant the reader role to an appropriate higher functional role with the additional privileges.
- Inspect CURRENT_DATABASE, CURRENT_SCHEMA, CURRENT_ROLE, and session context before resolving or qualifying the table.
- Configure an appropriate OAuth authorization flow and token scopes along with Snowflake role privileges.
Explanation
Correct Answer
A:Possessing roles is distinct from activating them; Snowflake authorization depends on session role context and enabled secondary roles. In this security control assessment setting, the intended validation is: A session test with the intended role context shows the expected access and CURRENT_ROLE identifies primary context.
Incorrect Answers
B:That action is relevant when 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. It is not the primary action for the stated primary and secondary role session need.
C:That action is relevant when Two analysts run identical unqualified table names but receive different results because their sessions point at different current databases. It is not the primary action for the stated primary and secondary role session need.
D: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 primary and secondary role session need.
Question 298
[Production migration readiness] The team proposes: Build a supported dynamic table with a SELECT definition, warehouse, and achievable TARGET_LAG setting. Its actual requirement is: A production migration team is preparing a controlled cutover; the solution must preserve existing account isolation. A reporting team wants a transformation query to maintain refreshed output automatically under a target freshness requirement. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which observation most directly validates success?
- A controlled INSERT/UPDATE leads to expected stream records, and the offset advances after the consuming transaction commits.
- Dynamic table refresh history and data timestamps show the defined query output meeting the practical freshness target.
- A staged file is visible through the table-stage reference and a controlled COPY loads the intended table.
- SELECT against the external table returns staged records after location metadata has been refreshed appropriately.
Explanation
Correct Answer
B:Dynamic tables express desired query results declaratively and Snowflake orchestrates refresh instead of requiring a bespoke stream/task graph for every stage. This is an outcome test of the specified dynamic table declarative refresh action under the production migration readiness conditions.
Incorrect Answers
A:A controlled INSERT/UPDATE leads to expected stream records, and the offset advances after the consuming transaction commits. This is an outcome for a different requirement: A warehouse engineer needs to process only changes to an operational table since the last successfully consumed offset. It cannot by itself validate the proposed dynamic table declarative refresh action; the appropriate test is: Dynamic table refresh history and data timestamps show the defined query output meeting the practical freshness target.
C:A staged file is visible through the table-stage reference and a controlled COPY loads the intended table. This is an outcome for a different requirement: An analyst must stage a small support file used only to load one existing target table, with no need for a shared named-stage contract. It cannot by itself validate the proposed dynamic table declarative refresh action; the appropriate test is: Dynamic table refresh history and data timestamps show the defined query output meeting the practical freshness target.
D:In this production migration readiness context, SELECT against the external table returns staged records after location metadata has been refreshed appropriately. This is an outcome for a different requirement: A data scientist needs governed SQL reads over files remaining in external object storage, without an ordinary Snowflake-managed load step. It cannot by itself validate the proposed dynamic table declarative refresh action; the appropriate test is: Dynamic table refresh history and data timestamps show the defined query output meeting the practical freshness target.
Question 299
[Collaboration operating audit] A platform owner must demonstrate that the proposed sharing model respects its access and recovery boundary. A multinational organization requires a recoverable approved dataset in another supported Snowflake account region for resilience planning. The conclusion must be justified with observable verification rather than an undocumented assumption. Which specific design mistake would most directly defeat the intended result?
- Assume a database is automatically replicated to every account merely because all accounts share the same organization.
- Grant access to a nonexistent consumer account identifier and assume Snowflake creates a working user interface automatically.
- Assume CLONE DATABASE in one account silently creates an always-current replica in every other geography.
- Export the entire database to CSV and reload it as the only supported cloning approach.
Explanation
Correct Answer
C:The supportable direction is: Configure supported database or account replication and plan promotion or failover procedures for the desired recovery objectives. This directly undermines replication across regions for availability in the specified context.
Incorrect Answers
A:Under collaboration operating audit conditions, Assume a database is automatically replicated to every account merely because all accounts share the same organization. That is a mistake for a different cross-region snowflake account planning task, where A company operates accounts on two clouds and wants to access a dataset from the second account without assuming storage instantly appears in both regions.
B:Under collaboration operating audit conditions, Grant access to a nonexistent consumer account identifier and assume Snowflake creates a working user interface automatically.
D:Under collaboration operating audit conditions, Export the entire database to CSV and reload it as the only supported cloning approach.
Question 300
[Production compliance review] The team proposes: Configure appropriate future grants for the required schema scope while preserving narrowly defined access roles. Its actual requirement is: A compliance reviewer is checking which safeguard actually enforces the stated boundary. Analysts repeatedly lose approved read access whenever the ingestion team creates another table in a governed reporting schema. The conclusion must be justified with observable verification rather than an undocumented assumption. Which observation most directly validates success?
- SHOW TABLES in the intended schema finds the table and the three-part object identifier resolves independently of warehouse name.
- SHOW GRANTS confirms the new owner and the required downstream roles retain the intended authorized operations.
- SHOW GRANTS and a controlled session verify inherited SELECT works while ungranted DDL remains forbidden.
- A newly created sample table receives the expected SELECT grant without adding unrelated elevated ownership.
Explanation
Correct Answer
D:A newly created sample table receives the expected SELECT grant without adding unrelated elevated ownership. This is an outcome test of the specified future grants in new schema action under the production compliance review conditions. Future grants apply designated privileges to newly created objects and avoid uncontrolled ad hoc grant repetition.
Incorrect Answers
A:In this production compliance review context, SHOW TABLES in the intended schema finds the table and the three-part object identifier resolves independently of warehouse name. This is an outcome for a different requirement: A developer tries to locate a table by naming a warehouse as its parent and cannot determine where the object should be created. It cannot by itself validate the proposed future grants in new schema action; the appropriate test is: A newly created sample table receives the expected SELECT grant without adding unrelated elevated ownership.
B:In this production compliance review context, SHOW GRANTS confirms the new owner and the required downstream roles retain the intended authorized operations. This is an outcome for a different requirement: A pipeline service role has object OWNERSHIP but its replacement needs controlled transfer with minimal risk to existing privilege chains. It cannot by itself validate the proposed future grants in new schema action; the appropriate test is: A newly created sample table receives the expected SELECT grant without adding unrelated elevated ownership.
C:In this production compliance review context, SHOW GRANTS and a controlled session verify inherited SELECT works while ungranted DDL remains forbidden. This is an outcome for a different requirement: 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. It cannot by itself validate the proposed future grants in new schema action; the appropriate test is: A newly created sample table receives the expected SELECT grant without adding unrelated elevated ownership.