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

Questions 6–10

1. 6foundation · easy

   Which statement accurately describes how a reader account differs from a standard Snowflake account?

   • AA reader account is used to share data with another Snowflake account that has a different cloud provider
   • BA reader account is a temporary account that expires after a set period of time
   • CA reader account can only read data shared by its provider and cannot create its own shares
   • DA reader account is a full Snowflake account with all features enabled but is billed to the provider
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   What is the primary purpose of a reader account in Snowflake?

   • ATo provide a read-only replica of a database for disaster recovery within the same organization
   • BTo allow organizations without a Snowflake account to query data shared by a Snowflake account
   • CTo provide a secure way to share data with another Snowflake account that has its own storage
   • DTo allow a Snowflake account to read data from a different cloud provider without moving data
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A reader account has been created, and the provider wants to allow the consumer's team to manage their own users. The provider wants to delegate user management to a specific role in the reader account. What should the provider do?

   • AGrant the USERADMIN role to a user in the reader account.
   • BShare the account credentials with the consumer.
   • CCreate a custom role with CREATE USER privilege.
   • DGrant the ACCOUNTADMIN role to a user in the reader account.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A data provider wants to share a curated dataset with a partner organization that does not use Snowflake. The partner needs to query the data with standard SQL and run a few ad-hoc reports. The provider wants to avoid creating a full Snowflake account for the partner. What should the provider do?

   • ACreate a reader account and share the dataset with it via a share.
   • BCreate a database and grant the partner's IP address access to it.
   • CCreate a standard Snowflake account for the partner and grant them ACCOUNTADMIN.
   • DExport the data to a CSV file and email it to the partner.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which SQL command is used to set a consumption limit on a reader account?

   • ACREATE CONSUMPTION LIMIT
   • BALTER READER ACCOUNT ... SET CONSUMPTION_LIMIT = ...
   • CSET CONSUMPTION_LIMIT
   • DUPDATE READER ACCOUNT
   Reveal Solution Discussion Select an answer first