Snowflake Exam ADA-C01 Topic 4 Question 12 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 12
Topic #: 4

An Administrator is evaluating a complex query using the EXPLAIN command. The Globalstats operation indicates 500 partitionsAssigned.

The Administrator then runs the query to completion and opens the Query Profile. They notice that the partitions scanned value is 429.

Why might the actual partitions scanned be lower than the estimate from the EXPLAIN output?

AThe EXPLAIN results always include a 10-15% safety factor in order to provide conservative estimates.

BThe GlobalStats partition assignment includes the micro-partitions that will be assigned for preservation of the query results.

CRuntime optimizations such as join pruning can reduce the number of partitions and bytes scanned during query execution.

DIn-flight data compression will result in fewer micro-partitions being scanned at the virtual warehouse layer than were identified at the storage layer.

Show Suggested Answer

Suggested Answer: B

When future grants are defined on the same object type for a database and a schema in the same database, the schema-level grants take precedence over the database level grants, and the database level grants are ignored4. This behavior applies to privileges on future objects granted to one role or different roles4. Future grants allow defining an initial set of privileges to grant on new (i.e. future) objects of a certain type in a database or a schema3. As soon as the new objects are created inside the database or schema, the predefined set of privileges are assigned to the object automatically without any manual intervention3.

by Kristeen at Apr 26, 2024, 11:22 PM

Limited Time Offer

25%

Off

Get Premium ADA-C01 Questions as Interactive Web-Based Practice Test or PDF