- (Topic 1)
Where would a Snowflake user find information about query activity from 90 days ago?

1. A. account usage . query history view
2. B. account usage.query history archive View
3. C. information schema . cruery_history view
4. D. information schema - query history_by_ses s i on view

Correct Answer: B
To find information about query activity from 90 days ago, a Snowflake user should use the account_usage.query_history_archive view. This view is designed to provide access to historical query data beyond the default 14-day retention period found in the standard query_history view. It allows users to analyze and audit past query activities for up to 365 days after the date of execution, which includes the 90-day period mentioned. References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Account Usage Schema1

- (Topic 3)
What action can a user take to address query concurrency issues?

1. A. Enable the query acceleration service.
2. B. Enable the search optimization service.
3. C. Add additional clusters to the virtual warehouse
4. D. Resize the virtual warehouse to a larger instance size.

Correct Answer: C
To address query concurrency issues, a user can add additional clusters to the virtual warehouse. This allows for the distribution of queries across multiple clusters, reducing the load on any single cluster and improving overall query performance2.

- (Topic 1)
What happens when a cloned table is replicated to a secondary database? (Select TWO)

1. A. A read-only copy of the cloned tables is stored.
2. B. The replication will not be successful.
3. C. The physical data is replicated
4. D. Additional costs for storage are charged to a secondary account
5. E. Metadata pointers to cloned tables are replicated

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 3)
Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

1. A. Query execution
2. B. Data loading
3. C. Time Travel data
4. D. Security
5. E. Authentication and access control

Correct Answer: DE
The cloud services layer of Snowflake architecture handles various aspects including security functions, authentication of user sessions, and access control, ensuring that only authorized users can access the data and services23.

- (Topic 3)
What is cached during a query on a virtual warehouse?

1. A. All columns in a micro-partition
2. B. Any columns accessed during the query
3. C. The columns in the result set of the query
4. D. All rows accessed during the query

Correct Answer: C
During a query on a virtual warehouse, the columns in the result set of the query are cached. This allows for faster retrieval of data if the same or a similar query is run again, as the system can retrieve the data from the cache rather than reprocessing the entire query. References: [COF-C02] SnowPro Core Certification Exam Study Guide