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: Aug 26, 2026

Add To Cart

Question 1

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 2

A single variant data column table RAW_SOURCE has the following JSON records:A Data Analyst needs to get the value of the "f" field and have it in a consumable, tabular format. Whichquery should be used to meet this requirement?

A : select data:events:f::number from raw_source;

B : select value:f::number from raw_source, lateral flatten( input => data );

C : select src.events:f::number from raw_source src;

D : select value:f::number from raw_source, lateral flatten( input => data:events );

Answer: D

Question 3

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 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

In data modeling for BI requirements, when is it preferable to use a flattened data set instead of a data model?

A : For quick and simple data exploration

B : For situations requiring high data normalization

C : For scenarios necessitating extensive data transformations

D : For complex data analysis needs

Answer: A

Page: 1 / 48

Total 236 Questions | Updated On: Aug 26, 2026

Add To Cart