SnowPro Advanced: Architect Practice Questions

SnowPro Advanced: Architect (ARA-C01) exam preparation

SnowPro Advanced: Architect practice questions in English: 171 questions with explanations. The mock exam has 65 questions and 115 minutes.

SnowPro Advanced: Architect free question 5 / 10 · Domain 2: Snowflake Architecture

An account in the AWS Tokyo region shares a secure view V_SALES from database SALES_DB. V_SALES also references tables in another database, REF_DB. The data must be delivered to three partner Snowflake accounts in the Azure West Europe region. Listings are not used; instead, following the documented procedure for sharing across regions and clouds, one account of the same organization is created in West Europe. Which configuration is the most appropriate?

  1. Enable replication on the target account and leave the source account unchanged, replicate SALES_DB and REF_DB in the same replication group, and create the share there
  2. Enable replication on both the source and target accounts, replicate SALES_DB and REF_DB together in the same replication group, and then create the share in the target account
  3. Enable replication on both accounts, replicate the database created from the Tokyo share and REF_DB in separate replication groups, and create the share in the target account
  4. Enable replication on both the source and target accounts, replicate SALES_DB and REF_DB in separate replication groups, and then create the share in the target account
Show the answer and explanation

Answer: B

Why this is correct
Direct sharing works only between accounts in the same region, so sharing across regions relies on data replication. In the documented procedure, an organization administrator first enables replication on both the source account that holds the data and the target account in the region you want to share to. The databases are then replicated to the target account, where a share is created and delivered to the consumers. The documentation states that when you share a view that references objects in multiple databases, every referenced database must be included in the same replication group. V_SALES references REF_DB, so SALES_DB and REF_DB are replicated together in one replication group.

Why the other options are wrong
"Enable replication on both the source and target accounts, replicate SALES_DB and REF_DB in separate replication groups, and then create the share in the target account" … The documentation says that any database referenced by the view must be included in the same replication group that carries the view. Placing the referenced database in a separate group is not part of the procedure.
"Enable replication on both accounts, replicate the database created from the Tokyo share and REF_DB in separate replication groups, and create the share in the target account" … The replication documentation states that a database created from a share cannot be replicated; what you replicate is the source database that holds the data. In addition, REF_DB, which the view references, has to be in the same replication group.
"Enable replication on the target account and leave the source account unchanged, replicate SALES_DB and REF_DB in the same replication group, and create the share there" … The first step of the documented procedure is for an organization administrator to enable replication on both the source account that holds the data and the target account. Skipping the source account is not an option.

Key point
The provider needs one copy per region, not one per consumer, so the three partners can be served from shares created in that single target account. Because cross-region sharing rides on replication, review the replication considerations at the design stage.

Go to the SnowPro Advanced: Architect practice app (10 free questions; purchase unlocks all questions)

See the full practice set