SNOWPRO-CORE Practice Questions: Account Access and Security Domain

Published: August 21, 2025 | 10 min read

Test your SNOWPRO-CORE knowledge with 5 practice questions from the Account Access and Security domain. Includes detailed explanations and answers.

SNOWPRO-CORE Practice Questions

Master the Account Access and Security Domain

Test your knowledge in the Account Access and Security domain with these 5 practice questions. Each question is designed to help you prepare for the SNOWPRO-CORE certification exam with detailed explanations to reinforce your learning.

Question 1

Which feature is unique to the Snowflake Business Critical Edition?

A) Time Travel for 90 days

B) Support for HIPAA compliance

C) Data sharing across different cloud platforms

D) External functions

Show Answer & Explanation

Correct Answer: B

Explanation: The Business Critical Edition of Snowflake includes support for HIPAA compliance, which is not available in lower editions. Option A is incorrect because Time Travel for 90 days is available in other editions as well. Option C is incorrect because data sharing across cloud platforms is available in other editions. Option D is incorrect because external functions are available in other editions.

Question 2

What is the primary purpose of using network policies in Snowflake?

A) To enforce multi-factor authentication (MFA) for users.

B) To restrict access to Snowflake based on IP address.

C) To manage user roles and privileges.

D) To encrypt data at rest.

Show Answer & Explanation

Correct Answer: B

Explanation: Network policies in Snowflake are used to restrict access to the Snowflake account based on IP addresses, allowing organizations to control which IPs can connect to their Snowflake environment. MFA enforcement is handled through authentication policies, not network policies (option A is incorrect). User roles and privileges are managed through the RBAC model (option C is incorrect). Data encryption is a separate feature not managed by network policies (option D is incorrect).

Question 3

What is the primary purpose of a resource monitor in Snowflake?

A) To control user access to specific databases.

B) To track and limit credit usage within a Snowflake account.

C) To manage network access policies.

D) To enforce MFA for all users.

Show Answer & Explanation

Correct Answer: B

Explanation: The primary purpose of a resource monitor in Snowflake is to track and limit credit usage within a Snowflake account, helping to manage costs. Option A is incorrect because user access is controlled through roles and privileges. Option C is incorrect because resource monitors do not manage network access. Option D is incorrect because resource monitors are not related to MFA enforcement.

Question 4

What is the best practice for managing access to different database environments (e.g., development, testing, production) in Snowflake?

A) Use the same role for all environments and manage access through network policies.

B) Create separate roles for each environment and assign privileges accordingly.

C) Rely on MFA to differentiate user access between environments.

D) Use a single account-wide role with full privileges for simplicity.

Show Answer & Explanation

Correct Answer: B

Explanation: The best practice is to create separate roles for each environment (development, testing, production) and assign privileges accordingly to ensure proper access control. Using the same role or a single account-wide role does not provide granular control, and MFA is for authentication, not authorization.

Question 5

What is a recommended practice for managing user access to sensitive data in Snowflake?

A) Grant all users the ACCOUNTADMIN role to simplify management.

B) Use role-based access control and grant the least privilege necessary.

C) Create a single role with all privileges and assign it to all users.

D) Disable role hierarchy to prevent privilege escalation.

Show Answer & Explanation

Correct Answer: B

Explanation: The recommended practice for managing user access to sensitive data in Snowflake is to use role-based access control (RBAC) and grant the least privilege necessary to perform their job functions. Granting all users the ACCOUNTADMIN role (option A) or creating a single role with all privileges (option C) violates the principle of least privilege and can lead to security risks. Disabling role hierarchy (option D) is not a recommended practice as it reduces the flexibility of access management.

Ready to Accelerate Your SNOWPRO-CORE Preparation?

Join thousands of professionals who are advancing their careers through expert certification preparation with FlashGenius.

✅ Unlimited practice questions across all SNOWPRO-CORE domains
✅ Full-length exam simulations with real-time scoring
✅ AI-powered performance tracking and weak area identification
✅ Personalized study plans with adaptive learning
✅ Mobile-friendly platform for studying anywhere, anytime
✅ Expert explanations and study resources

Start Free Practice Now

Already have an account? Sign in here

About SNOWPRO-CORE Certification

The SNOWPRO-CORE certification validates your expertise in account access and security and other critical domains. Our comprehensive practice questions are carefully crafted to mirror the actual exam experience and help you identify knowledge gaps before test day.