Snowflake DAA-C01: SnowPro Advanced: Data Analyst

Last checked October 22, 2026 against the official Snowflake exam page.

1. Question 1Snowflake data model and SQL

   In Snowflake, which object is the top-level container that holds schemas and is typically named for an environment or business unit?

   1. AWarehouse
   2. BDatabase
   3. CStream
   4. DStage
   Show answer and explanationHide answer

   Correct answer: B

   A database contains schemas and is the top-level container under an account. Warehouses provide compute, stages hold files, and streams track changes.

2. Question 2Data loading and transformation

   A team loads a large set of CSV files daily into a table and wants to avoid loading files that were already loaded. Which Snowflake feature tracks load history for this?

   1. ACOPY INTO with load metadata that prevents re-loading the same files
   2. BRenaming the incoming files with the same name each day
   3. CDeleting the internal stage object after each load run completes
   4. DLoading with TRUNCATE TABLE on every scheduled run before the new files are read
   Show answer and explanationHide answer

   Correct answer: A

   COPY INTO tracks file load metadata so already-loaded files are skipped by default. Truncating loses history, deleting stages removes files, and reusing names confuses tracking.

3. Question 3Data analysis fundamentals

   An analyst needs the total sales per region for the current year from a large sales table. Which SQL clause groups rows to compute the totals?

   1. AWHERE region keeps raw rows
   2. BGROUP BY region with SUM(sales)
   3. CORDER BY region sorts result rows
   4. DHAVING region filters the output rows
   Show answer and explanationHide answer

   Correct answer: B

   GROUP BY with an aggregate computes totals per group. ORDER BY sorts, WHERE filters rows before grouping, and HAVING filters groups after aggregation.

4. Question 4Analytics and visualization

   A business user wants a chart that shows the share of total revenue held by each product category at a single point in time. Which chart is most suitable?

   1. AA histogram of product names, binned by first letter of each name
   2. BA line chart of revenue tracked over several decades
   3. CA scatter plot of product IDs against the warehouse shipping weight
   4. DA 100 percent stacked bar or a pie chart with few categories
   Show answer and explanationHide answer

   Correct answer: D

   Part-to-whole comparisons suit stacked bars or pies with few categories. Trend lines, scatter plots of IDs and histograms of names do not show shares.

5. Question 5Governance and security

   A company must mask personal email addresses for analysts who do not have a specific privilege, while other analysts see the full value. Which Snowflake feature implements this?

   1. AA dynamic masking policy applied to the email column based on the role
   2. BA separate copy of the table with asterisks typed in by hand for each team member
   3. CRenaming the email column to a less revealing label such as contact_ref
   4. DEncrypting the entire database at rest with a single customer-managed key in storage
   Show answer and explanationHide answer

   Correct answer: A

   Dynamic masking policies apply role-based masking at query time. Manual copies, database-wide encryption alone and renaming do not implement role-based masking.