COF-C03 Data Collaboration Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  GRANT IMPORTED PRIVILEGES ON DATABASE REGIONAL_SALES_SHARE TO ACCOUNT CONSUMER_ACCT;

  Why it's wrong here

  GRANT IMPORTED PRIVILEGES is used by a consumer to grant a role the ability to access a shared database, but it is not used to grant a consumer account access to a share. Additionally, REGIONAL_SALES_SHARE is a share, not a database, so this command would fail. The provider must use ALTER SHARE to add the consumer account.

• ✗

  GRANT USAGE ON SHARE REGIONAL_SALES_SHARE TO ACCOUNT CONSUMER_ACCT;

  Why it's wrong here

  This syntax is invalid because the GRANT USAGE ON SHARE privilege is used to grant a role the ability to use a share within the provider's account, not to grant a consumer account access to the share. To add a consumer account to a share, the correct command is ALTER SHARE ... ADD ACCOUNT. Using GRANT here would result in a syntax error.

• ✓

  ALTER SHARE REGIONAL_SALES_SHARE ADD ACCOUNT = CONSUMER_ACCT;

  Why this is correct

  The ALTER SHARE command with the ADD ACCOUNT clause is the correct way to grant a consumer account access to a share. This command adds the specified account to the share's list of authorized accounts, allowing the consumer to create a database from the share. It is the standard method for sharing data with specific accounts.

• ✗

  CREATE SHARE REGIONAL_SALES_SHARE GRANT TO ACCOUNT CONSUMER_ACCT;

  Why it's wrong here

  This command is syntactically incorrect. The CREATE SHARE statement is used to create a new share, but it does not include a GRANT TO ACCOUNT clause. To add a consumer account to an existing share, you must use ALTER SHARE. This option would fail with a syntax error.