- (Topic 1)
What happens when a cloned table is replicated to a secondary database? (Select TWO)
Correct Answer:
CE
When a cloned table is replicated to a secondary database in Snowflake, the following occurs:
✑ C. The physical data is replicated: The actual data of the cloned table is physically
replicated to the secondary database. This ensures that the secondary database has its own copy of the data, which can be used for read-only purposes or failover scenarios1.
✑ E. Metadata pointers to cloned tables are replicated: Along with the physical data,
the metadata pointers that refer to the cloned tables are also replicated. This metadata includes information about the structure of the table and any associated properties2.
It??s important to note that while the physical data and metadata are replicated, the secondary database is typically read-only and cannot be used for write operations. Additionally, while there may be additional storage costs associated with the secondary account, this is not a direct result of the replication process but rather a consequence of storing additional data.
References:
✑ SnowPro Core Exam Prep — Answers to Snowflake??s LEVEL UP: Backup and Recovery
✑ Snowflake SnowPro Core Certification Exam Questions Set 10
- (Topic 6)
In the Data Exchange, who can get or request data from the listings? (Select TWO).
Correct Answer:
AD
In the Snowflake Data Exchange, the ability to get or request data from listings is generally controlled by specific roles and privileges:
✑ A. Users with ACCOUNTADMIN role: This role typically has the highest level of
access within a Snowflake account, including the ability to manage and access all features and functions. Users with this role can access data listings within the Data Exchange.
✑ D. Users with import share privilege: This specific privilege is necessary for users
who need to import shared data from the Data Exchange. This privilege allows them to request and access data listings explicitly shared with them.
- (Topic 3)
How do Snowflake data providers share data that resides in different databases?
Correct Answer:
B
Snowflake data providers can share data residing in different databases through secure views. Secure views allow for the referencing of objects such as schemas, tables, and other views contained in one or more databases, as long as those databases belong to the same account. This enables providers to share data securely and efficiently with consumers. References: [COF-C02] SnowPro Core Certification Exam Study Guide
- (Topic 6)
Which type of workload traditionally benefits from the use of the query acceleration service?
Correct Answer:
B
The query acceleration service in Snowflake is beneficial for workloads that include on- demand data analyses. This service optimizes query performance by dynamically allocating additional resources to execute queries faster, particularly useful for ad-hoc analysis where data volume and complexity can vary.
References:
✑ Snowflake Documentation: Query Acceleration Service
- (Topic 5)
Which common query problems are identified by the Query Profile? (Select TWO.)
Correct Answer:
BD
The Query Profile in Snowflake can identify common query problems, including:
✑ B. Inefficient pruning: This refers to the inability of a query to effectively limit the amount of data being scanned, potentially leading to suboptimal performance.
✑ D. Queries too large to fit in memory: This indicates that a query requires more memory than is available in the virtual warehouse, which can lead to spilling to disk and degraded performance.
The Query Profile helps diagnose these issues by providing detailed execution statistics and visualizations, aiding in query optimization and troubleshooting.
References:
✑ Snowflake Documentation: Query Profile Top of Form
