ExamGecko
Search Search Login
Home Home / Snowflake / ADA-C01
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

In general, the monthly billing for database replication is proportional to which variables? (Select TWO).
A Snowflake Administrator is investigating why a query is not re-using the persisted result cache. The Administrator found the two relevant queries from the SNOWFLAKE. ACCOUNT_USAGE. QUERY_HISTORY view: Why is the second query re-scanning micro-partitions instead of using the first query's persisted result cache?
A Snowflake account is configured with SCIM provisioning for user accounts and has bi-directional synchronization for user identities. An Administrator with access to SECURITYADMIN uses the Snowflake UI to create a user by issuing the following commands: use role USERADMIN; create or replace role DEVELOPER_ROLE; create user PTORRES PASSWORD = 'hello world!' MUST_CHANGE_PASSWORD = FALSE default_role = DEVELOPER_ROLE; The new user named PTORRES successfully logs in, but sees a default role of PUBLIC in the web UI. When attempted, the following command fails: use DEVELOPER_ROLE; Why does this command fail?
If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?
A Snowflake Administrator created a role ROLE_MANAGED_ACCESS and a schema SCHEMA_MANAGED_ACCESS as follows: USE ROLE SECURITYADMIN; CREATE ROLE ROLE_MANAGED_ACCESS; GRANT ROLE ROLE_MANAGED_ACCESS TO ROLE SYSADMIN; GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE ROLE_MANAGED_ACCESS; GRANT ALL privileges ON DATABASE WORK TO ROLE ROLE_MANAGED_ACCESS; USE ROLE ROLE_MANAGED_ACCESS; CREATE SCHEMA SCHEMA_MANAGED_ACCESS WITH MANAGED ACCESS; USE ROLE SECURITYADMIN; GRANT SELECT, INSERT ON FUTURE TABLES IN SCHEMA SCHEMA MANAGED ACCESS to ROLE_MANAGED_ACCESS; The Administrator now wants to disable the managed access on the schema. How can this be accomplished?
What are characteristics of data replication in Snowflake? (Select THREE).
A Snowflake Administrator needs to set up Time Travel for a presentation area that includes facts and dimensions tables, and receives a lot of meaningless and erroneous loT data. Time Travel is being used as a component of the company's data quality process in which the ingestion pipeline should revert to a known quality data state if any anomalies are detected in the latest load. Data from the past 30 days may have to be retrieved because of latencies in the data acquisition process. According to best practices, how should these requirements be met? (Select TWO).
Which statement allows this user to access this Snowflake account from a specific IP address (192.168.1.100) while blocking their access from anywhere else?
What roles can be used to create network policies within Snowflake accounts? (Select THREE).
What is a characteristic of Snowflake's transaction locking and concurrency modeling?

Question 66 - ADA-C01 discussion

Report
Export

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?

A.
The EXPLAIN results always include a 10-15% safety factor in order to provide conservative estimates.
Answers
A.
The EXPLAIN results always include a 10-15% safety factor in order to provide conservative estimates.
B.
The GlobalStats partition assignment includes the micro-partitions that will be assigned for preservation of the query results.
Answers
B.
The GlobalStats partition assignment includes the micro-partitions that will be assigned for preservation of the query results.
C.
Runtime optimizations such as join pruning can reduce the number of partitions and bytes scanned during query execution.
Answers
C.
Runtime optimizations such as join pruning can reduce the number of partitions and bytes scanned during query execution.
D.
In-flight data compression will result in fewer micro-partitions being scanned at the virtual warehouse layer than were identified at the storage layer.
Answers
D.
In-flight data compression will result in fewer micro-partitions being scanned at the virtual warehouse layer than were identified at the storage layer.
Suggested answer: C

Explanation:

The EXPLAIN command returns the logical execution plan for a query, which shows the upper bound estimates for the number of partitions and bytes that might be scanned by the query1. However, these estimates do not account for the runtime optimizations that Snowflake performs to improve the query performance and reduce the resource consumption2. One of these optimizations is join pruning, which eliminates unnecessary partitions from the join inputs based on the join predicates2. This can result in fewer partitions and bytes scanned than the estimates from the EXPLAIN output3. Therefore, the actual partitions scanned value in the Query Profile can be lower than the partitionsAssigned value in the EXPLAIN output4.

Show Answer
asked 23/09/2024
Mehr Khan
37 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms