We're so confident of our products that we provide no hassle product exchange.
Snowflake DAA-C01 Exam Overview:
| Certification Vendor: | Snowflake |
| Exam Name: | SnowPro Advanced: Data Analyst Certification Exam |
| Exam Number: | DAA-C01 |
| Exam Price: | $375 USD |
| Related Certifications: | SnowPro Core Certification |
| Exam Format: | Multiple Choice, Multiple Select, True/False |
| Exam Duration: | 115 minutes |
| Certificate Validity Period: | 2 years |
| Available Languages: | English |
| Passing Score: | 750 out of 1000 (scaled score) |
| Real Exam Qty: | 65 |
| Sample Questions: | Snowflake DAA-C01 Sample Questions |
| Exam Way: | Online via Pearson VUE (proctored) |
| Pre Condition: | Active SnowPro Core Certified credential required. 1 or more years of hands-on practical experience with Snowflake as a Data Analyst in a production environment recommended. Fluency with advanced SQL and knowledge of an additional computer language preferred. |
| Official Syllabus URL: | https://learn.snowflake.com/en/certifications/snowpro-advanced-dataanalyst |
Snowflake DAA-C01 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Data Transformation and Data Modeling | 22%-30% | - Design data models
|
| Data Analysis | 30%-32% | - Perform advanced analytics using SQL
|
| Data Ingestion and Data Preparation | 15%-20% | - Prepare data and load into Snowflake
|
| Data Presentation and Data Visualization | 28%-29% | - Integrate with BI tools
|
Snowflake SnowPro Advanced: Data Analyst Certification Sample Questions:
1. What is a benefit of using SQL queries that contain secure views?
A) Snowflake secure views are more performant than regular views.
B) Users will not be able to make observations about the quantity of underlying data.
C) Only the number of scanned micro-partitions is exposed, not the number of bytes scanned.
D) The amount of data scanned, and the total data volume are obfuscated.
2. What functionalities are available when a Snowflake worksheet is shared with other users? (Select TWO).
A) Collaborators can share the worksheet across Snowflake accounts.
B) If multiple users edit and run a shared worksheet at the same time, each run of the worksheet will create a new version.
C) If the worksheet is being edited, the collaborators will be able to see these edits in real-time.
D) Whenever a user with permissions runs a worksheet, the existing version history of the worksheet will be overwritten.
E) Users with edit permissions can view past versions of the worksheet.
3. A Data Analyst needs to generate a graphic that will identify any natural clusters in a data set containing details about completed orders. Which Snowsight chart should be used?
A) Scatter plot
B) Line chart
C) Heat grid
D) Bar chart
4. Table TB_A with column COL_B contains an ARRAY. Which statement will select the last element of the ARRAY?
A) SELECT LAST_VALUE(COL_B) FROM TB_A;
B) SELECT COL_B[-1] FROM TB_A;
C) SELECT COL_B[ARRAY_SIZE(COL_B)] FROM TB_A;
D) SELECT GET(COL_B, ARRAY_SIZE(COL_B)-1) FROM TB_A;
5. A Data Analyst created a model called modelX using SNOWFLAKE.ML.FORECAST. The Analyst needs to predict the next few values and save the result directly into tableX. What step does the Analyst need to take after calling the modelX!FORECAST function?
A) List the cache content, then use the data saved in the RESULT_SCAN for tableX.
B) Create the table by querying the RESULT_SCAN.
C) Load the function call results directly INTO tableX.
D) Pass the new table as a function argument.
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: B,C | Question # 3 Answer: A | Question # 4 Answer: D | Question # 5 Answer: B |
By Dorothy
