Free DAA-C01 – SnowPro Advanced: Data Analyst Certification Exam Practice Test Question

Select an option, then click Submit answer.

• ○ One time bulk data migration
• ○ Automatic table clustering maintenance
• ○ Continuous near real time ingestion
• ○ Query result caching service

Select an option, then click Submit answer.

• ○ CSV file format definition
• ○ Parquet file format definition
• ○ Avro file format definition
• ○ JSON file format definition

Select an option, then click Submit answer.

• ○ Behavior when file errors occur
• ○ Whether warehouses resume automatically
• ○ How long data is retained
• ○ Which users can query

Select an option, then click Submit answer.

• ○ SHOW TABLES in schema
• ○ LIST command on stage
• ○ DESCRIBE the target table
• ○ SELECT from information schema

Select all that apply, then click Submit answer.

• ○ COPY INTO bulk loading
• ○ Snowpipe continuous ingestion
• ○ Snowflake data sharing replication
• ○ Automatic clustering reclustering service

Select all that apply, then click Submit answer.

• ○ Fixed width text only
• ○ JSON document text format
• ○ Image binary file format
• ○ Parquet columnar file format

Answer is in the explanation below.

Answer is in the explanation below.

Select all that apply, then click Submit answer.

• ○ Drop entire source tables
• ○ Rename database objects randomly
• ○ Standardize values with CASE
• ○ Handle nulls with COALESCE

Answer is in the explanation below.