100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 190
A sensitive database should be accessible to service accounts only through approved access roles Which technical action is most appropriate under this requirement?
- Use a least-privilege role hierarchy and avoid direct PUBLIC grants
- Replace role grants with a nonsecure view name
- Give every service SYSADMIN ownership
- Grant all database tables to PUBLIC
Explanation
Correct Answer
A:Use a least-privilege role hierarchy and avoid direct PUBLIC grants. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: A sensitive database should be accessible to service accounts only through approved access roles. The appropriate decision: Use a least-privilege role hierarchy and avoid direct PUBLIC grants.
C:The problem: A sensitive database should be accessible to service accounts only through approved access roles. The appropriate decision: Use a least-privilege role hierarchy and avoid direct PUBLIC grants.
D:The problem: A sensitive database should be accessible to service accounts only through approved access roles. The appropriate decision: Use a least-privilege role hierarchy and avoid direct PUBLIC grants.
Question 191
An ingestion team wants to load only a controlled subset of files from a shared stage Which technical action is most appropriate under this requirement?
- Resize a warehouse instead of specifying file selection
- Drop all stage contents before each selective load
- Use a database role name as the file prefix
- Specify the relevant FILES list, stage prefix or supported PATTERN in COPY
Explanation
Correct Answer
D:Specify the relevant FILES list, stage prefix or supported PATTERN in COPY. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: An ingestion team wants to load only a controlled subset of files from a shared stage. The appropriate decision: Specify the relevant FILES list, stage prefix or supported PATTERN in COPY.
B:The problem: An ingestion team wants to load only a controlled subset of files from a shared stage. The appropriate decision: Specify the relevant FILES list, stage prefix or supported PATTERN in COPY.
C:The problem: An ingestion team wants to load only a controlled subset of files from a shared stage. The appropriate decision: Specify the relevant FILES list, stage prefix or supported PATTERN in COPY.
Question 192
A table is naturally ordered by date and pruning is already strong Which unresolved finding would be a valid reason to block acceptance after the change?
- The relevant users retain exactly their approved access
- Change and rollback evidence is retained with the release
- Unnecessary reclustering consumes credits without improving important queries
- The team confirms: Representative scans retain good pruning with lower maintenance overhead
Explanation
Correct Answer
C:Unresolved failure: Unnecessary reclustering consumes credits without improving important queries. Correct and test it before acceptance.
Incorrect Answers
A:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Unnecessary reclustering consumes credits without improving important queries.
B:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Unnecessary reclustering consumes credits without improving important queries.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: Unnecessary reclustering consumes credits without improving important queries.
Question 193
A table is naturally ordered by date and pruning is already strong The team proposes: Do not add an expensive clustering key without measured benefit. Which test outcome is the strongest direct evidence that this change works?
- A single warm-cache run is cited without representative execution metrics
- Only a warehouse CPU chart improves while query latency and scan behavior are unmeasured
- The query finishes but returns a different business total
- Representative scans retain good pruning with lower maintenance overhead
Explanation
Correct Answer
D:Acceptance evidence: Representative scans retain good pruning with lower maintenance overhead. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Representative scans retain good pruning with lower maintenance overhead.
B:This observation is insufficient. The stronger validation is: Representative scans retain good pruning with lower maintenance overhead.
C:This observation is insufficient. The stronger validation is: Representative scans retain good pruning with lower maintenance overhead.
Question 194
An application key has been exposed and must no longer authenticate Which unresolved finding would be a valid reason to block acceptance after the change?
- A known stolen key remains usable for account access
- The team confirms: Connections using the leaked key fail while the replacement key succeeds
- Change and rollback evidence is retained with the release
- The relevant users retain exactly their approved access
Explanation
Correct Answer
A:Unresolved failure: A known stolen key remains usable for account access. Correct and test it before acceptance.
Incorrect Answers
B:This is a legitimate target or safeguard, not the unresolved failure described in the question: A known stolen key remains usable for account access.
C:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: A known stolen key remains usable for account access.
D:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: A known stolen key remains usable for account access.
Question 195
An operator wants to remove stale SELECT access from a retired contractor role Which unresolved finding would be a valid reason to block acceptance after the change?
- Change and rollback evidence is retained with the release
- The relevant users retain exactly their approved access
- Old memberships continue granting sensitive reads
- The team confirms: The retired role and its users no longer query the protected objects
Explanation
Correct Answer
C:Unresolved failure: Old memberships continue granting sensitive reads. Correct and test it before acceptance.
Incorrect Answers
A:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Old memberships continue granting sensitive reads.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Old memberships continue granting sensitive reads.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: Old memberships continue granting sensitive reads.
Question 196
An ETL role can select records but cannot run queries on its designated warehouse Which technical action is most appropriate under this requirement?
- Remove the database-level role
- Add a result-cache setting instead of warehouse USAGE
- Grant the appropriate USAGE privilege on the intended warehouse to its active role
- Transfer OWNERSHIP of every table to the ETL role
Explanation
Correct Answer
C:Grant the appropriate USAGE privilege on the intended warehouse to its active role. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: An ETL role can select records but cannot run queries on its designated warehouse. The appropriate decision: Grant the appropriate USAGE privilege on the intended warehouse to its active role.
B:The problem: An ETL role can select records but cannot run queries on its designated warehouse. The appropriate decision: Grant the appropriate USAGE privilege on the intended warehouse to its active role.
D:The problem: An ETL role can select records but cannot run queries on its designated warehouse. The appropriate decision: Grant the appropriate USAGE privilege on the intended warehouse to its active role.
Question 197
A team wants a central owner to control grants within a shared regulated schema Which unresolved finding would be a valid reason to block acceptance after the change?
- The team confirms: Only authorized grant managers change object permissions under the managed-access model
- Change and rollback evidence is retained with the release
- Individual object owners can grant access outside the governed schema rules
- The relevant users retain exactly their approved access
Explanation
Correct Answer
C:Unresolved failure: Individual object owners can grant access outside the governed schema rules. Correct and test it before acceptance.
Incorrect Answers
A:This is a legitimate target or safeguard, not the unresolved failure described in the question: Individual object owners can grant access outside the governed schema rules.
B:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Individual object owners can grant access outside the governed schema rules.
D:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Individual object owners can grant access outside the governed schema rules.
Question 198
A report needs a cumulative sales total separately for each region over calendar time The team proposes: Use SUM(amount) OVER with region partitioning and ordered window semantics. Which test outcome is the strongest direct evidence that this change works?
- Only a warehouse CPU chart improves while query latency and scan behavior are unmeasured
- The query finishes but returns a different business total
- A single warm-cache run is cited without representative execution metrics
- Running totals reset at region boundaries and progress by date
Explanation
Correct Answer
D:Acceptance evidence: Running totals reset at region boundaries and progress by date. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Running totals reset at region boundaries and progress by date.
B:This observation is insufficient. The stronger validation is: Running totals reset at region boundaries and progress by date.
C:This observation is insufficient. The stronger validation is: Running totals reset at region boundaries and progress by date.
Question 199
A support team wants to recover from accidental schema deletion without recreating every object manually The team proposes: Review supported Time Travel and UNDROP recovery options at the affected object scope. Which test outcome is the strongest direct evidence that this change works?
- The warehouse login succeeds but the required query fails
- An unrelated compute counter improves with no correctness check
- Recovered schema and eligible objects are validated before production traffic resumes
- A metadata row exists while no relevant data is tested
Explanation
Correct Answer
C:Acceptance evidence: Recovered schema and eligible objects are validated before production traffic resumes. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Recovered schema and eligible objects are validated before production traffic resumes.
B:This observation is insufficient. The stronger validation is: Recovered schema and eligible objects are validated before production traffic resumes.
D:This observation is insufficient. The stronger validation is: Recovered schema and eligible objects are validated before production traffic resumes.
Question 200
A team stores JSON as plain text and wants to use JSON path navigation in SQL Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Parse the JSON text into a VARIANT value using supported parsing functions
- Set a file format name as a SQL object path
- Add a second warehouse instead of parsing
- Nested attributes can be accessed by the intended SQL path syntax
- Cast the JSON text to BOOLEAN for object navigation
Explanation
Correct Answers
A:Parse the JSON text into a VARIANT value using supported parsing functions. This addresses the stated condition without bypassing the required boundary.
D:Acceptance evidence: Nested attributes can be accessed by the intended SQL path syntax. Completing configuration alone is insufficient.
Incorrect Answers
B:The problem: A team stores JSON as plain text and wants to use JSON path navigation in SQL. The appropriate decision: Parse the JSON text into a VARIANT value using supported parsing functions.
C:The problem: A team stores JSON as plain text and wants to use JSON path navigation in SQL. The appropriate decision: Parse the JSON text into a VARIANT value using supported parsing functions.
E:The problem: A team stores JSON as plain text and wants to use JSON path navigation in SQL. The appropriate decision: Parse the JSON text into a VARIANT value using supported parsing functions.
SnowPro Core COF-C03 Practice Tests