A provider has a reader account with a consumption limit of 100 credits per month. The consumer has used 80 credits in the first week. The provider expects the consumer's usage to remain steady. The provider wants to ensure the consumer can continue using the account for the rest of the month without exceeding the limit. What should the provider do?

Set the consumption limit to unlimited.

Keep the limit at 100 credits and monitor usage.

Increase the consumption limit to 200 credits.

Create a second reader account and share the data again.

A provider has created a reader account for a consumer. The provider wants to share a specific table from a database with the consumer. What must the provider do to make the table visible and queryable in the reader account?

Create a share, add the table to the share, and grant USAGE on the share to the reader account.

Copy the table to the reader account using CREATE TABLE AS SELECT.

Create a view in the reader account and point it to the provider's table.

Grant SELECT on the table directly to the reader account.

A provider wants to share a view that joins data from two tables with a reader account. The provider has created the view in the provider's database. What must the provider do to make the view available to the reader account?

Share the underlying tables and let the consumer create the view.

Add the view to a share and grant USAGE on the share to the reader account.

Create the same view in the reader account.

Grant SELECT on the underlying tables to the reader account.

What is the purpose of assigning a role to a user within a reader account?

To specify the cloud region where the user's queries run

To determine the billing rate for the user's queries

To set the password policy for the user

To control the privileges the user has on shared data

Which command would you use to change the admin user's password for a reader account?

ALTER USER ... SET PASSWORD = ...

UPDATE READER ACCOUNT ... SET PASSWORD = ...

ALTER READER ACCOUNT ... SET ADMIN_PASSWORD = ...

SET PASSWORD FOR READER ACCOUNT

SnowPro® Core Certification

Domain 5Objective 3

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

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 1–5

1expert · hard
A provider has a reader account with a consumption limit of 100 credits per month. The consumer has used 80 credits in the first week. The provider expects the consumer's usage to remain steady. The provider wants to ensure the consumer can continue using the account for the rest of the month without exceeding the limit. What should the provider do?
Select an answer first
2application · medium
A provider has created a reader account for a consumer. The provider wants to share a specific table from a database with the consumer. What must the provider do to make the table visible and queryable in the reader account?
Select an answer first
3application · medium
A provider wants to share a view that joins data from two tables with a reader account. The provider has created the view in the provider's database. What must the provider do to make the view available to the reader account?
Select an answer first
4foundation · easy
What is the purpose of assigning a role to a user within a reader account?
Select an answer first
5foundation · easy
Which command would you use to change the admin user's password for 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.