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: Jun 16, 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 company is looking for new headquarters and wants to minimize the distances employees have to commute.The company has geographic data on employees' residences. Through the Snowflake Marketplace, thecompany obtained geographic data for possible locations of the new headquarters. How can the distancebetween an employee's residence and potential headquarters locations be calculated in meters with theLEAST operational overhead?

A : ST_HAUSDORFFDISTANCE

B : HAVERSINE

C : ST_LENGTH

D : ST_DISTANCE

Answer: D

Question 3

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

Question 4

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