A provider has a reader account with multiple users. The provider wants to allow one user to create other users but not to manage shares. What role should the provider grant to that user?

A custom role with CREATE USER privilege.

A provider wants to control costs associated with a reader account. The consumer is expected to run occasional queries, but the provider wants to limit the total compute usage per month. What should the provider do?

Set a consumption limit on the reader account.

Set a resource monitor on the provider's account.

Grant the reader account a limited role.

Use a warehouse with a small size in the reader account.

A provider is creating a reader account for a consumer in a different region. The provider wants to ensure the reader account is created in the same region as the provider's data to minimize latency. What should the provider do?

Create the reader account in the default region.

Specify the region in the CREATE READER ACCOUNT command.

Create a share and let Snowflake choose the region.

Use ALTER READER ACCOUNT to change the region after creation.

What is the first step in sharing data with a reader account?

Set up a data pipeline to replicate data to the reader account

Grant the reader account the ACCOUNTADMIN role

Create a share and add the reader account to it

Create a database in the reader account and copy data into it

SnowPro® Core Certification

Domain 5Objective 3

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

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 16–20

16expert · hard
A provider has a reader account with multiple users. The provider wants to allow one user to create other users but not to manage shares. What role should the provider grant to that user?
Select an answer first
17application · medium
A provider wants to control costs associated with a reader account. The consumer is expected to run occasional queries, but the provider wants to limit the total compute usage per month. What should the provider do?
Select an answer first
18application · medium
A provider is creating a reader account for a consumer in a different region. The provider wants to ensure the reader account is created in the same region as the provider's data to minimize latency. What should the provider do?
Select an answer first
19foundation · easy
What is the first step in sharing data with a reader account?
Select an answer first
20foundation · easy
Which SQL command is used to create a new user within a reader account?
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.