CloudGuild · Blog · Cheat sheets · Lessons · Certifications
SnowPro Core Certification Exam Question Walkthrough: Logging User Activities
Master the SnowPro Core Certification with this detailed walkthrough of a logging question to ensure compliance in Snowflake.
A common challenge for candidates is understanding the specific features that support compliance in Snowflake. This question tests your knowledge of user activity logging, a critical aspect for many organizations.
The question
A company wants to ensure that all user activities are logged for compliance purposes. What feature should they enable in their Snowflake account?
- A. Data Retention Policies
- B. Query History
- C. Access History
- D. Snowpipe
Think before you scroll
Consider what each option provides in terms of logging user activities. Compliance requires thorough tracking of user actions, not just query executions. Focus on features that capture comprehensive access details.
The answer
The correct option is C. Access History. This feature logs all user activities, including logins and SQL statement executions, making it essential for compliance and auditing purposes. It offers a complete view of user interactions with the system.
Why the other options lose
A. Data Retention Policies: This option focuses on how long data is retained in Snowflake, not on logging user activities. While important for data management, it does not address compliance logging requirements.
B. Query History: Query History records executed queries but lacks comprehensive details on user access and activities. It is useful for performance analysis but insufficient for compliance needs.
D. Snowpipe: Snowpipe is a data ingestion tool that automates loading data into Snowflake. It does not log user activities, making it irrelevant for compliance purposes.
The concept behind it
Understanding user activity logging is essential for compliance in any database environment. Access History is the feature that provides the necessary audit trail of user interactions, ensuring organizations meet compliance standards. This principle applies not only in Snowflake but also in other database systems where tracking user actions is crucial.
Exam trap to remember
Remember: Access History is your go-to for compliance logging. It captures all user activities, which is vital for audits and compliance checks.