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: Apr 29, 2026

Add To Cart

Question 1

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

Given the following data:This SELECT statement is executed: What will be the result?

A : 200

B : 20

C : 1.84

D : 1.8

Answer: B

Question 4

Which aspects are important when making predictions based on data for forecasting purposes? (Select all that apply)

A : Incorporating statistical methods for accurate predictions

B : Using only basic arithmetic functions for forecasting

C : Considering trends and anomalies in historical data

D : Relying solely on historical data without considering external factors

Answer: A,C

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: Apr 29, 2026

Add To Cart