CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. DSA-C02

Free DSA-C02 Exam Braindumps (page: 5)

Page 4 of 17
PDF with 65 Questions

Which one is the incorrect option to share data in Snowflake?

  1. a Listing, in which you offer a share and additional metadata as a data product to one or more accounts.
  2. a Direct Marketplace, in which you directly share specific database objects (a share) to another account in your region using Snowflake Marketplace.
  3. a Direct Share, in which you directly share specific database objects (a share) to anoth-er account in your region.
  4. a Data Exchange, in which you set up and manage a group of accounts and offer a share to that group.

Answer(s): B

Explanation:

Options for Sharing in Snowflake
You can share data in Snowflake using one of the following options:
· a Listing, in which you offer a share and additional metadata as a data product to one or more ac- counts,
· a Direct Share, in which you directly share specific database objects (a share) to another account in your region,
· a Data Exchange, in which you set up and manage a group of accounts and offer a share to that group.



Data providers add Snowflake objects (databases, schemas, tables, secure views, etc.) to a share us- ing Which of the following options?

  1. Grant privileges on objects to a share via Account role.
  2. Grant privileges on objects directly to a share.
  3. Grant privileges on objects to a share via a database role.
  4. Grant privileges on objects to a share via a third-party role.

Answer(s): B,C

Explanation:

What is a Share?
Shares are named Snowflake objects that encapsulate all of the information required to share a database.
Data providers add Snowflake objects (databases, schemas, tables, secure views, etc.) to a share using either or both of the following options:
Option 1: Grant privileges on objects to a share via a database role. Option 2: Grant privileges on objects directly to a share. You choose which accounts can consume data from the share by adding the accounts to the share. After a database is created (in a consumer account) from a share, all the shared objects are accessible to users in the consumer account.
Shares are secure, configurable, and controlled completely by the provider account:
· New objects added to a share become immediately available to all consumers, providing real-time access to shared data.
Access to a share (or any of the objects in a share) can be revoked at any time.



Secure Data Sharing do not let you share which of the following selected objects in a database in your account with other Snowflake accounts?

  1. Sequences
  2. Tables
  3. External tables
  4. Secure UDFs

Answer(s): A

Explanation:

Secure Data Sharing lets you share selected objects in a database in your account with other Snow- flake accounts. You can share the following Snowflake database objects:
Tables
External tables
Secure views
Secure materialized views
Secure UDFs
Snowflake enables the sharing of databases through shares, which are created by data providers and "imported" by data consumers.



Which one is incorrect understanding about Providers of Direct share?

  1. A data provider is any Snowflake account that creates shares and makes them available to other Snowflake accounts to consume.
  2. As a data provider, you share a database with one or more Snowflake accounts.
  3. You can create as many shares as you want, and add as many accounts to a share as you want.
  4. If you want to provide a share to many accounts, you can do the same via Direct Share.

Answer(s): D

Explanation:

If you want to provide a share to many accounts, you might want to use a listing or a data ex-change.






Post your Comments and Discuss Snowflake DSA-C02 exam with other Community members:

DSA-C02 Discussions & Posts