A provider wants to create a reader account for a consumer. The consumer is in a region where Snowflake is not available. What should the provider do?

Create the reader account in the nearest available region.

Create a full Snowflake account in the consumer's region.

Use a different cloud provider for the reader account.

Share the data using a direct share to the consumer's existing account.

A provider has a reader account that is approaching its consumption limit. The provider wants to be notified before the limit is reached so they can take action. What should the provider do?

Set up an email notification in the reader account.

Query the usage views daily and manually check.

Increase the consumption limit to avoid reaching it.

Set up a resource monitor on the reader account.

Which SQL command is used to permanently remove a reader account?

ALTER READER ACCOUNT ... SET STATUS = DROPPED

A reader account has been created for a partner. The partner's team has a data analyst who needs to query shared data, and a manager who should only see metadata. The provider wants to grant the analyst the ability to query but not modify data. What should the provider do?

Create a user and assign the PUBLIC role.

Grant the analyst the ACCOUNTADMIN role in the reader account.

Create a role in the reader account with USAGE on the share and grant it to the analyst.

Share the data directly with the analyst's email address.

SnowPro® Core Certification

Domain 5Objective 3

Manage Reader Accounts COF-C03 Practice Questions (Page 3)

Part of the Data Collaboration domain, which accounts for 10% of the COF-C03 exam.

25questions here

5free pages

6concepts

10%of the exam

Questions 11–15

11expert · hard
A provider wants to create a reader account for a consumer. The consumer is in a region where Snowflake is not available. What should the provider do?
Select an answer first
12foundation · easy
Which SQL command is used to create a reader account in Snowflake?
Select an answer first
13expert · hard
A provider has a reader account that is approaching its consumption limit. The provider wants to be notified before the limit is reached so they can take action. What should the provider do?
Select an answer first
14foundation · easy
Which SQL command is used to permanently remove a reader account?
Select an answer first
15application · medium
A reader account has been created for a partner. The partner's team has a data analyst who needs to query shared data, and a manager who should only see metadata. The provider wants to grant the analyst the ability to query but not modify data. What should the provider do?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to COF-C03

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. “COF-C03” is a trademark of its owner, used for identification only.