Snowflake SnowPro Advanced: Data Analyst Certification - DAA-C01 Exam Practice Test
What potential problem can be identified in the Query profile below?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
How can a Data Analyst automatically create a table structure for loading a Parquet file?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
A Data Analyst has a Parquet file stored in an Amazon S3 staging area. Which query will copy the data from the staged Parquet file into separate columns in the target table?
Correct Answer: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
A Data Analyst needs a sample of 10 rows from a table FCT_SALES that has billions of rows. Which commands can be used to accomplish this? (Select TWO).
Correct Answer: D,E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Which Snowflake feature allows users to encapsulate a series of SQL statements into a reusable database object, facilitating modular code development?
Correct Answer: D
Vote an answer
A Data Analyst has created a custom filter called branch_region on a Snowflake dashboard. The filter contains a list of regions where the company has stores. How should the filter be referenced in dashboard queries?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
This command was executed:
SQL
SELECT seq4(), uniform(1, 10, RANDOM(12))
FROM TABLE(GENERATOR(TIMELIMIT => NULL))
ORDER BY 1;
How many rows will be generated?
SQL
SELECT seq4(), uniform(1, 10, RANDOM(12))
FROM TABLE(GENERATOR(TIMELIMIT => NULL))
ORDER BY 1;
How many rows will be generated?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).