nerdexam
Snowflake

ADA-C01 · Question #5

What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Choose two.)

The correct answer is C. ACCOUNTADMIN D. IMPORT SHARE and CREATE DATABASE. According to the Accessing a Data Exchange documentation, a consumer account can request and get data from the Data Exchange using either the ACCOUNTADMIN role or a role with the IMPORT SHARE and CREATE DATABASE privileges. The ACCOUNTADMIN role is the top- level role that has…

Data Sharing and Collaboration

Question

What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Choose two.)

Options

  • ASYSADMIN
  • BSECURITYADMIN
  • CACCOUNTADMIN
  • DIMPORT SHARE and CREATE DATABASE
  • EIMPORT PRIVILEGES and SHARED DATABASE

How the community answered

(38 responses)
  • A
    11% (4)
  • B
    3% (1)
  • C
    82% (31)
  • E
    5% (2)

Explanation

According to the Accessing a Data Exchange documentation, a consumer account can request and get data from the Data Exchange using either the ACCOUNTADMIN role or a role with the IMPORT SHARE and CREATE DATABASE privileges. The ACCOUNTADMIN role is the top- level role that has all privileges on all objects in the account, including the ability to request and get data from the Data Exchange. A role with the IMPORT SHARE and CREATE DATABASE privileges can also request and get data from the Data Exchange, as these are the minimum privileges required to create a database from a share.

Topics

#Data Exchange#IMPORT SHARE#consumer account#ACCOUNTADMIN

Community Discussion

No community discussion yet for this question.

Full ADA-C01 Practice