What is a key implication of using customer-managed keys (CMK) in Snowflake?

Snowflake stores the customer's key in plaintext for quick access

Snowflake cannot decrypt data if the customer's key is unavailable

The customer must manually rotate all keys using Snowflake's UI

Encryption is disabled for data at rest

A company has a Snowflake table containing employee salaries. The HR team should see actual salaries, but the finance team should see only masked values. Which feature should be used to achieve this requirement?

Encrypt the salary column with a different key for each role.

Create a masking policy on the salary column that returns the actual value for the HR role and a masked value for other roles.

Create a row-level access policy on the table that filters rows based on the user's role.

Create a view that excludes the salary column for the finance team.

What is the purpose of column-level masking in Snowflake?

To hide sensitive data from unauthorized users at query time

To physically delete sensitive data from tables

To encrypt data at rest in specific columns

To prevent all users from seeing the data

What is the primary function of a network policy in Snowflake?

To control which IP addresses can access the Snowflake account

To encrypt network traffic between clients and Snowflake

To manage firewall rules within Snowflake's internal network

To monitor data egress from Snowflake

At which levels can encryption be applied in Snowflake?

Account, database, schema, table, and stage

SnowflakeSnowPro Advanced — Architect

Domain 1Objective 3

Implement Data Protection and Encryption ARA-C01 Practice Questions (Page 1)

Part of the Accounts and Security domain, which accounts for 26% of the ARA-C01 exam.

29questions here

6free pages

10concepts

26%of the exam

Questions 1–5

1foundation · easy
What is a key implication of using customer-managed keys (CMK) in Snowflake?
Select an answer first
2application · medium
A company has a Snowflake table containing employee salaries. The HR team should see actual salaries, but the finance team should see only masked values. Which feature should be used to achieve this requirement?
Select an answer first
3foundation · easy
What is the purpose of column-level masking in Snowflake?
Select an answer first
4foundation · easy
What is the primary function of a network policy in Snowflake?
Select an answer first
5foundation · easy
At which levels can encryption be applied in Snowflake?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to ARA-C01

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “ARA-C01” is a trademark of its owner, used for identification only.