nerdexam
Snowflake

ADA-C01 · Question #53

The ACCOUNTADMIN of Account 123 works with Snowflake Support to set up a Data Exchange. After the exchange is populated with listings from other Snowflake accounts, what roles in Account 123 are…

The correct answer is B. Any role with USAGE privilege on the Data Exchange. To request and get data from a Data Exchange, the role in Account 123 must have the USAGE privilege on the Data Exchange object. This privilege allows the role to view the listings and request access to the data. According to the Snowflake documentation, "To view the listings…

Data Sharing and Collaboration

Question

The ACCOUNTADMIN of Account 123 works with Snowflake Support to set up a Data Exchange. After the exchange is populated with listings from other Snowflake accounts, what roles in Account 123 are allowed to request and get data?

Options

  • AOnly the ACCOUNTADMIN role, and no other roles
  • BAny role with USAGE privilege on the Data Exchange
  • CAny role with IMPORT SHARE and CREATE DATABASE privileges
  • DAny role that the listing provider has designated as authorized

How the community answered

(17 responses)
  • A
    12% (2)
  • B
    82% (14)
  • C
    6% (1)

Explanation

To request and get data from a Data Exchange, the role in Account 123 must have the USAGE privilege on the Data Exchange object. This privilege allows the role to view the listings and request access to the data. According to the Snowflake documentation, "To view the listings in a data exchange, a role must have the USAGE privilege on the data exchange object. To request access to a listing, a role must have the USAGE privilege on the data exchange object and the IMPORT SHARE privilege on the account."

Topics

#Data Exchange#marketplace access#role privileges#listing access

Community Discussion

No community discussion yet for this question.

Full ADA-C01 Practice