ExamDumpster

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.

Question 1Choose one

An analyst runs a query filtering on a `transaction_date` column against a 500GB table. The Query Profile indicates that 100% of the micro-partitions were scanned, despite the query returning only 1% of the data. What is the most likely cause of this poor partition pruning? flowchart TD A[Query Execution] --> B[TableScan] B --> C[Partitions Scanned: 15,000 / 15,000] B --> D[Rows Returned: 10,000]

Question 2Choose one

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?

Question 3Choose 2

Which of the following scenarios are appropriate use cases for Data Metric Functions (DMFs) in Snowflake? (Select TWO)

Question 4Choose one

Snowflake Standard Edition allows configuring Time Travel data retention periods for up to 90 days on permanent tables.

Question 5Choose one

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;

Question 6Choose one

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.

Create account