Free DAA-C01 sample questions
Below are free DAA-C01 sample questions with answers and explanations. They test data cleaning, SQL analysis and dashboard design. Use them to check that your SQL holds up on analysis tasks.
Try them in the simulator Same questions, with study, timed and flashcard modes.
Showing 6 of 12 free sample questions.
A data analyst needs to deduplicate a table of customer events, keeping only the most recent event per customer based on the `event_timestamp`. Which query efficiently accomplishes this using Snowflake's native capabilities?
Which of the following scenarios are appropriate use cases for Data Metric Functions (DMFs) in Snowflake? (Select TWO)
Snowflake Standard Edition allows configuring Time Travel data retention periods for up to 90 days on permanent tables.
To parse an array of JSON objects stored in the `payload` variant column of the `transactions` table into individual rows, which function fills in the blank? SELECT t.id, f.value FROM transactions t, LATERAL ____(input => t.payload:items) f;
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?
6 more free samples are waiting
Create a free account to unlock the whole DAA-C01 sample bank, or get full access to all 150 practice questions in the simulator.