DAA-C01 SnowPro Advanced: Data Analyst Practice Questions
Prepare for DAA-C01 with more than an answer.
- Exam fee
- $375 USD
- Time limit
- 115 minutes
- Questions on the exam
- 65
- Passing score
- 750 (scaled 0-1000)
- Level
- Advanced
- Valid for
- 2 years
Domains covered on the exam 4
- Data Ingestion and Data Preparation17%
- Data Transformation and Data Modeling23%
- Data Analysis32%
- Data Presentation and Data Visualization28%
- 1
Snowflake Standard Edition allows configuring Time Travel data retention periods for up to 90 days on permanent tables.
Show answer details
Correct answer: B
False. In Snowflake Standard Edition, Time Travel retention is limited to 1 day. Extending Time Travel up to 90 days requires Enterprise Edition or higher.
- 2
To parse an array of JSON objects stored in the
payloadvariant column of thetransactionstable into individual rows, which function fills in the blank?SELECT t.id, f.value
FROM transactions t, LATERAL ____(input => t.payload:items) f;Show answer details
Correct answer: D
The FLATTEN table function is used to unnest hierarchical data in Snowflake, converting arrays or objects into a set of rows.
- 3
A cybersecurity firm queries a 10TB log table. 99% of their queries are highly selective point lookups searching for a specific IP address (e.g.,
WHERE ip_address = '192.168.1.50'). The data is ingested chronologically and is not clustered by IP address. Which Snowflake feature is best suited to optimize these specific lookups?Show answer details
Correct answer: C
The Search Optimization Service (SOS) is specifically designed to significantly improve the performance of point lookup queries on massive tables that return a small number of rows, particularly when the table is not clustered on the search column.
- 4
A quantitative analyst at a hedge fund needs to align a table of executed stock trades with a table of quote prices. The requirement is to find the prevailing bid price at the exact moment or immediately before a trade occurred. The timestamps will rarely match exactly. Which approach is the most efficient and semantically correct in Snowflake?
Show answer details
Correct answer: A
An ASOF JOIN is specifically designed for time-series analysis where you need to join records based on the closest preceding (or exact) timestamp. It is highly optimized for this exact scenario, avoiding the massive performance overhead of a CROSS JOIN or complex window functions.
flowchart TD A[Trades Table] -->|Timestamp matching| B{ASOF JOIN} C[Quotes Table] -->|Most recent prior| B B --> D[Enriched Trade Data] - 5
A data engineer is loading millions of records from JSON files into Snowflake using the COPY INTO command. They anticipate that approximately 5% of the records will have schema mismatches or corrupt formatting. They want to load all valid records, skip the invalid ones, and capture the errors for later review without failing the entire load operation. Which TWO actions should they take? (Select TWO)
Show answer details
Correct answer: B, C
The VALIDATE table function is used to view all errors encountered during a previous execution of the COPY command, allowing the engineer to review the skipped records.
Setting ON_ERROR = CONTINUE instructs the COPY command to continue loading valid records even if it encounters errors in some rows.
- 6
The GENERATOR table function in Snowflake requires an existing physical table to produce synthetic rows.
Show answer details
Correct answer: B
False. The GENERATOR function creates rows of synthetic data natively based on the ROWCOUNT or TIMELIMIT parameters. It does not require an underlying physical table, making it ideal for generating test datasets efficiently.
