Snowflake SnowPro Core - Full Practice Exam 1

1. A batch load must continue past malformed records while exposing rejected rows for review. Which option should be evaluated?
2. A business partner has no full Snowflake account and needs controlled read access to shared data. What should the provider evaluate?
3. A CI job must manage Snowflake application resources and execute scripted commands without a browser. Which official interface should be evaluated?
4. A company wants consistent metadata identifying sensitive columns across many schemas. Which capability helps?
5. A cost team must inspect warehouse and supported serverless consumption rather than only warehouse credit thresholds. What should it evaluate?
6. A CSV column contains quoted delimiters and occasional embedded line breaks. What should the engineer verify before production loading?
7. A dashboard query is fast alone but waits in a busy warehouse queue. What metric distinguishes this from slow execution?
8. A database operation must execute a procedural sequence, potentially including several SQL statements. Which object should be evaluated?
9. A developer builds an interactive Python data app close to Snowflake data. Which feature should be considered?
10. A developer creates unquoted object sales_data and later queries SALES_DATA. Why does this normally resolve?
11. A dynamic table is configured with a target lag. What does that setting primarily express?
12. A huge table is frequently queried by highly selective equality lookups. Which feature should be evaluated where supported?
13. A Java BI application requires standard database-driver connectivity to Snowflake. Which interface should be evaluated?
14. A large sort spills heavily to local and remote storage. Which response is appropriate?
15. A local file must be uploaded to a named internal stage using a supported client. Which command fits?
16. A managed access schema is used to centralize grants on its objects. What is a key effect?
17. A multi-cluster warehouse is configured with MIN_CLUSTER_COUNT=1 and MAX_CLUSTER_COUNT=1. What follows?
18. A named internal stage contains CSV files with a header row and pipe-delimited fields. What should describe that parsing?
19. A network policy allows only approved client locations. What does it primarily control?
20. A private key used by an integration is exposed. What is the essential response?
21. A project uses Apache Iceberg tables with data in supported external object storage. Which statement is most appropriate?
22. A proposed clustering change improves one query but creates ongoing maintenance cost. What should determine adoption?
23. A provider must distribute a data product across regions or clouds. What should be evaluated rather than assumed?
24. A provider shares a standard Snowflake database with another Snowflake account. Who normally supplies compute for the consumer's queries?
25. A provider wants consumers to query a filtered interface without exposing the full underlying table or view definition. Which object should be evaluated?
26. A Python application needs to execute parameterized SQL and retrieve results from Snowflake. Which client is appropriate?
27. A Python engineer wants DataFrame transformations expressed in Python but executed within Snowflake's processing environment where supported. Which library fits?
28. A query computes ROW_NUMBER() partitioned by CustomerID ordered by UpdatedAt DESC. Which Snowflake clause can keep row number 1 without an extra nesting level?
29. A query is slow and the analyst needs operator-level execution details such as scanning and joins. Which tool is the best starting point?
30. A regular view is created over a table. Which statement distinguishes it from a stored table copy?
31. A repeated query is eligible for persisted-result reuse and its source data is unchanged. What benefit may result?
32. A resource monitor should suspend a warehouse after configured credit thresholds. What should the administrator verify?
33. A reusable computation returns one value per input row and should be called inside SQL expressions. Which object is generally appropriate?
34. A role has CREATE TABLE on a schema. Does that automatically give it SELECT on every existing table in that schema?
35. A role should inherit privileges from another role in a hierarchy. What does granting the child role to the parent generally do?
36. A selective date query scans nearly all micro-partitions. What should the team evaluate?
37. A single complex query spills heavily and runs slowly on a small warehouse. Which compute change should be tested first?
38. A Snowflake query result must be exported as files to an approved stage. Which operation fits?
39. A SQL session has the correct database but the wrong schema. How can an analyst unambiguously reference SALES in ANALYTICS.PUBLIC?
40. A staged-file load should report parsing errors without inserting rows. For a supported simple COPY operation, which feature fits?
41. A staging table must survive the creator's session but needs no Fail-safe protection. Which table type fits?
42. A standard stream tracks table changes. An analyst SELECTs from it without a consuming DML transaction. What normally happens to its offset?
43. A standard table declares a PRIMARY KEY. What should ingestion designers know?
44. A standard warehouse is suspended and later resumed. Which cache expectation should the engineer avoid?
45. A table has Quantity and UnitPrice per sale. Which expression calculates total extended revenue?
46. A table was dropped accidentally and remains within its supported retention period. Its name is available. Which command should be considered?
47. A team creates a zero-copy clone of a large table. What is true immediately after creation?
48. A team mixes large ingestion jobs and latency-sensitive BI on one warehouse. What is a reasonable isolation strategy?
49. A team needs queryable files in cloud storage to be referenced without loading their contents into ordinary internal tables. Which object type should be evaluated?
50. A team needs to store semi-structured JSON while retaining SQL access to nested fields. Which type is most relevant?
51. A team wants future tables in a schema to receive a defined SELECT grant. What should be configured?
52. A team wants to call supported managed AI functions on governed Snowflake data. Which capability is relevant?
53. A transformation must run on a schedule or supported trigger using managed task execution. Which Snowflake feature fits?
54. A user changes their active primary role before running a query. Why can this affect access?
55. A VARIANT column v contains {"customer":{"id":17}}. Which expression accesses the nested value and converts it to a number?
56. A warehouse consumes two credits per hour and runs continuously for thirty minutes. Ignoring other services, how many compute credits are consumed?
57. A warehouse is suspended while its permanent tables remain in storage. Which statement is correct?
58. A warehouse should resume automatically for authorized work after idle suspension. Which configuration is relevant?
59. An account-level resource monitor is configured. Which assumption is unsafe?
60. An analyst has SELECT on a table but cannot use its containing database or schema. What additional access may be required?
61. An analyst needs a table's state before an accidental update, within its configured retention period. Which feature is appropriate?
62. An analyst wants a browser interface for worksheets, query history, and administration. Which Snowflake interface fits?
63. An application produces records continuously and should ingest rows directly rather than first build staged files. Which capability should be evaluated?
64. An auditor needs historical evidence of who ran queries and when. Which feature is the appropriate starting point?
65. An engineer needs to load staged files into a Snowflake table. Which SQL operation is appropriate?
66. An expensive repeated query pattern may benefit from a materialized view. What tradeoff must be evaluated?
67. An external stage should access cloud storage without embedding long-lived cloud keys in its definition. Which capability fits?
68. An ingestion service needs specific table writes and warehouse use. Which approach follows least privilege?
69. An intermediate table should be visible only within the creating session and disappear when that session ends. Which type fits?
70. An intermittent warehouse stays idle for hours after short bursts. Which settings should be reviewed?
71. An operator reloads files with FORCE=TRUE after a previous successful COPY. What risk should be considered?
72. An organization wants enterprise identity-provider sign-in for employees. Which capability is most relevant?
73. An unattended application should avoid embedding a human user's reusable password. Which supported approach should be evaluated?
74. Files already exist in an approved cloud bucket. Snowflake should reference that location for loading. Which object should be configured?
75. Finance should see full account numbers while support sees redacted values through the same query interface. Which feature fits?
76. Hundreds of independent dashboard queries queue at peak time, but each query is fast when run alone. Which capability is most directly relevant?
77. Most queries filter a very large table by a date derived from a high-cardinality timestamp. What should a clustering-key evaluation consider?
78. New files should be ingested automatically after cloud-storage arrival notifications, without a continuously running user-managed warehouse. Which feature fits?
79. Query Profile shows a join generating far more rows than either input. What should be investigated first?
80. Sales has Region and Amount. You need one row per Region where total Amount exceeds 5,000. Which clause applies that aggregate threshold?
81. Sales staff should retrieve only rows for their assigned territories, regardless of which authorized SQL client they use. Which policy is relevant?
82. Two teams query the same Snowflake tables using separate virtual warehouses. What is a key architectural benefit?
83. Two warehouse sizes are benchmarked on the same workload. Why compare total credits as well as runtime?
84. What cost responsibility should a provider consider when creating a reader account?
85. What does FLATTEN over PARSE_JSON('[2,4,6]') normally expose?
86. Which distinction between Time Travel and Fail-safe is correct?
87. Which factors should be controlled when benchmarking a query change? Select 2 answers.
88. Which hierarchy correctly locates a normal Snowflake table?
89. Which layer manages authentication, metadata, and query optimization in Snowflake's architecture?
90. Which practices help a stream-and-task pipeline remain correct? Select 2 answers.
91. Which practices improve ingestion reliability? Select 2 answers.
92. Which practices protect automated integrations? Select 2 answers.
93. Which statements about a standard shared database are correct? Select 2 answers.
94. Which statements about AI-assisted data applications are appropriate? Select 2 answers.
95. Which statements about compute and data objects are correct? Select 2 answers.
96. Which statements about data protection are correct? Select 2 answers.
97. Which statements about role-based access are correct? Select 2 answers.
98. Which statements about stages and file formats are correct? Select 2 answers.
99. Which statements about transient and temporary tables are correct? Select 2 answers.
100. Why can micro-partition metadata improve query performance?

Comments — 0