Snowflake ADA-C02: SnowPro Advanced: Administrator

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

1. Question 1Data preparation and querying

   An analyst wants to see the total sales per region for the last month without changing the source table. Which Snowflake SQL pattern is most appropriate?

   1. AA SELECT with GROUP BY region and a WHERE clause on the order date
   2. BA COPY INTO statement that loads the totals from a staged file
   3. CA DELETE of last month's rows followed by a manual count
   4. DAn UPDATE statement that stores the totals in the source table
   Show answer and explanationHide answer

   Correct answer: A

   A SELECT with GROUP BY and a date filter returns the aggregate without modifying data. UPDATE, DELETE, and COPY INTO change data or load files and are not needed for a read-only analysis.

2. Question 2Data governance and security

   A column contains personal data that analysts may query, but only the compliance team should see the actual values. Which Snowflake feature enforces this?

   1. AA separate copy of the data for analysts with values removed by hand
   2. BA masking policy applied to the column based on the querying role
   3. CSharing the password for the compliance role
   4. DA comment on the column saying not to view it
   Show answer and explanationHide answer

   Correct answer: B

   A masking policy enforces role-based masking at query time. Comments and manual copies rely on people and risk leaks, and sharing a password breaks access control.

3. Question 3Data visualisation and dashboards

   A chart shows revenue on a y-axis that starts at 95 million, making small changes look dramatic. What should the analyst do?

   1. ARemove the chart title and subtitle so that the viewer's attention goes straight to the revenue bars
   2. BUse a 3D effect with shading on the bars to add visual emphasis to the trend
   3. CHide the y-axis labels and tick values so the revenue scale is not visible to the report readers
   4. DLabel the axis clearly and consider a baseline that starts at zero for honest comparison
   Show answer and explanationHide answer

   Correct answer: D

   A clearly labelled axis, ideally starting at zero for bar charts, avoids exaggerating changes. Hiding labels and adding 3D effects reduce accuracy.

4. Question 4Data quality and validation

   An analyst notices that a key report total changed unexpectedly after a load. Which check is most useful first?

   1. ACompare row counts and control totals between the source and the loaded table for the same period
   2. BRename the report to a new title and update its description, leaving figures unchanged
   3. CDelete the report from the dashboard server and recreate it with the same filters
   4. DChange the report colours, fonts, and chart palette to match the brand template
   Show answer and explanationHide answer

   Correct answer: A

   Reconciling row counts and control totals locates where the difference arose. Cosmetic changes and deleting reports do not diagnose the cause.

5. Question 5Performance and cost

   A warehouse is consistently underused, but its cost is high. Which action best reduces cost without affecting users?

   1. ACreate a separate new warehouse for each query and each refresh
   2. BKeep the warehouse running at its largest size without auto-suspend
   3. CDisable query history logging on the account to reduce overhead
   4. DEnable auto-suspend and reduce the warehouse size if the queries allow
   Show answer and explanationHide answer

   Correct answer: D

   Auto-suspend and right-sizing reduce idle and oversized compute. Maximum size all the time, many new warehouses, and disabled logging increase cost or reduce insight.