Where would a Snowflake user find information about query activity from 90 days ago?
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. Reference: [COF-C02] SnowPro Core Certification Exam Study Guide Snowflake Documentation on Account Usage Schema1
Question 748
Which of the following objects can be shared through secure data sharing?
Correct Answer: D
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared: Tables External tables Secure views Secure materialized views Secure UDFs Snowflake enables the sharing of databases through shares, which are created by data providers and "imported" by data consumers. https://docs.snowflake.com/en/user-guide/data-sharing-intro.html#:~:text=Secure%20Data%20Sharing%20enables%20sharing,External%20tables
Question 749
What does Snowflake recommend for a user assigned the ACCOUNTADMIN role?
Correct Answer: C
For users assigned theACCOUNTADMINrole, Snowflake recommends enforcing Multi-Factor Authentication (MFA) to enhance security. TheACCOUNTADMINrole has extensive permissions, making it crucial to secure accounts held by such users against unauthorized access. MFA adds an additional layer of security by requiring a second form of verification beyond just the username and password, significantly reducing the risk of account compromise. References: Snowflake Security Best Practices
