Free Snowflake DAA-C01 Exam Questions

Become Snowflake Certified with updated DAA-C01 exam questions and correct answers

Page: 1 / 48

Total 236 Questions | Updated On: Sep 15, 2026

Add To Cart

Question 1

What option would allow a Data Analyst to efficiently estimate cardinality on a data set that contains trillionsof rows?

A : Count(Distinct *)

B : HLL(*)

C : SYSTEM$ESTIMATE

D : Count(Distinct *)/Count(*)

Answer: B

Question 2

A Data Analyst needs to temporarily hide a tile in a dashboard. The data will need to be available in thefuture, and additional data may be added. Which tile should be used?

A : Show/Hide

B : Duplicate

C : Delete

D : Unplace

Answer: D

Question 3

What actions are involved in performing general DML (Data Manipulation Language) operations in Snowflake? (Select all that apply)

A : Updating existing data

B : Deleting data entirely

C : Inserting new data

D : Merging data from multiple tables

Answer: A,B,C

Question 4

How can a Data Analyst automatically create a table structure for loading a Parquet file?

A : Use the INFER_SCHEMA together with the CREATE TABLE LIKE command.

B : Use INFER_SCHEMA together with the CREATE TABLE USING TEMPLATE command.

C : Use the GENERATE_COLUMN_DESCRIPTION with the CREATE TABLE USING TEMPLATEcommand.

D : Use the GENERATE_COLUMN_DESCRIPTION with the CREATE TABLE LIKE command.

Answer: B

Question 5

Why would a Data Analyst use a dimensional model rather than a single flat table to meet BI requirements fora virtual warehouse? (Select TWO).

A : Dimensional modelling will improve query performance over a single table.

B : Dimensional modelling will save on storage space since it is denormalized.

C : Combining facts and dimensions in a single flat table limits the scalability and flexibility.

D : Dimensions and facts allow power users to run ad-hoc analyses.

E : Snowflake generally performs better with dimensional modelling.

Answer: C,D

Page: 1 / 48

Total 236 Questions | Updated On: Sep 15, 2026

Add To Cart