Snowflake DAA-C01 Exam With Confidence Using Practice Dumps

To determine the correct result of the query, a Data Analyst must evaluate the nested functions according to standard SQL order of operations while correctly identifying how Snowflake handles NULL values in aggregate calculations.

Step 1: Evaluating AVG(GRADE)

The AVG() function calculates the arithmetic mean of the non-null values in a column. Based on the provided table data, the grades are: 4, 1, 2, 1, and 2. The sixth row contains a NULL grade. In Snowflake, as per ANSI SQL standards, aggregate functions ignore NULL values entirely. They are not treated as zeros, nor do they cause the function to return NULL (unless the entire column is null).

Sum of non-null values: $4 + 1 + 2 + 1 + 2 = 10$

Count of non-null values: $5$

Result: $10 / 5 = 2.0$

Step 2: Evaluating CEIL(..., 2)

The CEIL (or CEILING) function is typically used to return the smallest integer value that is greater than or equal to the input. However, Snowflake's CEIL function also supports an optional second argument for scale (precision).

The input is the result from the previous step: 2.0.

The scale argument is 2.

The function CEIL(2.0, 2) attempts to round the value up to the nearest value with two decimal places. Since 2.0 is already a whole number and has no fractional component beyond the specified scale, the ceiling remains 2.0.

Evaluating the Options:

Option A is incorrect as it represents a massive scaling error.

Option C and D are incorrect because they result from mathematical errors or incorrectly including the NULL row in the denominator (e.g., $10 / 6 = 1.66$, then rounded up).

Option B is the 100% correct answer. It accurately reflects the result of the AVG function ($2.0$) followed by the CEIL operation, which preserves the value as it is already at the target ceiling. This question tests precision in both mathematical logic and the technical nuances of Snowflake-specific SQL functions.

In Snowflake, the performance of a metadata-based query (like MAX, MIN, or COUNT) is typically near-instantaneous because Snowflake maintains constant-time statistics in its Cloud Services layer. For a standard table, SELECT MAX(num) does not even require a virtual warehouse to be active; it simply reads the value from the table's metadata.

However, when a Row Access Policy (RAP) is applied to a table, the query's behavior changes fundamentally. A row access policy is a security feature that restricts which rows are visible to a user based on their role or other attributes. To enforce this policy, Snowflake can no longer rely on the high-level metadata of the entire table because it must first determine which specific rows the user is authorized to see. Consequently, the query engine must scan the individual micro-partitions and evaluate the policy logic for every row (or block of rows) to filter out unauthorized data before calculating the maximum value. This turns a "metadata-only" operation into a data-scanning operation, which requires a running warehouse and significantly more time.

Evaluating the Options:

Option A is incorrect because the prompt states the tables are "similarly-sized." Even if it were slightly larger, a metadata lookup for a standard table would still be nearly instant.

Option C is incorrect because a multi-cluster warehouse helps with concurrency (multiple users), not the raw execution speed of a single simple aggregate query.

Option D is incorrect because USE_CACHED_RESULT refers to the Query Result Cache. While turning it off would prevent a "0ms" response from a previous run, it wouldn't explain a "significant" slowdown compared to a standard metadata fetch.

Option B is the 100% correct answer. The presence of a Row Access Policy forces a full data scan and policy evaluation, which is the most common reason for performance degradation in otherwise simple metadata queries.

When working within the Snowsight interface, the transition from a standalone worksheet to a dashboard component involves a change in how the underlying SQL and its associated metadata are managed. When a worksheet is converted or used to create a dashboard, the ownership and sharing model shifts to the dashboard level.

According to Snowflake's documentation on Snowsight collaboration, when a user creates a dashboard from a worksheet that was previously shared with others, the original worksheet's individual share settings are essentially superseded by the dashboard's own permissions. In many workflow scenarios within the UI, once the worksheet is finalized into a dashboard tile, the direct, independent access to that specific worksheet is severed for the original "sharees." Their permissions on that specific worksheet are revoked to prevent conflicting edits between the standalone version and the dashboard-integrated version.

Evaluating the Options:

Option A is incorrect because Snowsight manages the lifecycle of worksheets used in dashboards as part of the dashboard object; independent sharing of the underlying worksheet is typically disabled or revoked.

Option B and C are distractors; there is no mechanism in Snowsight that grants "additional" access or "temporary" loss during the creation process.

Option D is the 100% correct answer based on the SnowPro Data Analyst standard regarding Snowsight object ownership and sharing lifecycle. To allow others to see the work, the Analyst must now share the Dashboard itself, rather than relying on the previous worksheet-level permissions. This ensures a "single source of truth" for the visualization's logic.