Free Access to Snowflake.ARA-C01.v2026-04-11.q236 with Valid Practice Test (Page 21)

Question 96

A company has a Snowflake environment running in AWS us-west-2 (Oregon). The company needs to share data privately with a customer who is running their Snowflake environment in Azure East US 2 (Virginia).
What is the recommended sequence of operations that must be followed to meet this requirement?

A.1. Create a share and add the database privileges to the share2. Create a new listing on the Snowflake Marketplace3. Alter the listing and add the share4. Instruct the customer to subscribe to the listing on the Snowflake Marketplace
B.1. Ask the customer to create a new Snowflake account in Azure EAST US 2 (Virginia)2. Create a share and add the database privileges to the share3. Alter the share and add the customer's Snowflake account to the share
C.1. Create a new Snowflake account in Azure East US 2 (Virginia)2. Set up replication between AWS us- west-2 (Oregon) and Azure East US 2 (Virginia) for the database objects to be shared3. Create a share and add the database privileges to the share4. Alter the share and add the customer's Snowflake account to the share
D.1. Create a reader account in Azure East US 2 (Virginia)2. Create a share and add the database privileges to the share3. Add the reader account to the share4. Share the reader account's URL and credentials with the customer

Correct Answer: C

Option C is the correct answer because it allows the company to share data privately with the customer across different cloud platforms and regions. The company can create a new Snowflake account in Azure East US 2 (Virginia) and set up replication between AWS us-west-2 (Oregon) and Azure East US 2 (Virginia) for the database objects to be shared. This way, the company can ensure that the data is always up to date and consistent in both accounts. The company can then create a share and add the database privileges to the share, and alter the share and add the customer's Snowflake account to the share. The customer can then access the shared data from their own Snowflake account in Azure East US 2 (Virginia).
Option A is incorrect because the Snowflake Marketplace is not a private way of sharing data. The Snowflake Marketplace is a public data exchange platform that allows anyone to browse and subscribe to data sets from various providers. The company would not be able to control who can access their data if they use the Snowflake Marketplace.
Option B is incorrect because it requires the customer to create a new Snowflake account in Azure East US 2 (Virginia), which may not be feasible or desirable for the customer. The customer may already have an existing Snowflake account in a different cloud platform or region, and may not want to incur additional costs or complexity by creating a new account.
Option D is incorrect because it involves creating a reader account in Azure East US 2 (Virginia), which is a limited and temporary way of sharing data. A reader account is a special type of Snowflake account that can only access data from a single share, and has a fixed duration of 30 days. The company would have to manage the reader account's URL and credentials, and renew the account every 30 days. The customer would not be able to use their own Snowflake account to access the shared data, and would have to rely on the company's reader account.
References:
Snowflake Replication
Secure Data Sharing Overview
Snowflake Marketplace Overview
Reader Account Overview

Question 97

You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Everyday new data comes in and the old data is no longer required.
What type of table you will use in this case to optimize cost

A.TRANSIENT
B.TEMPORARY
C.PERMANENT

Question 98

What Snowflake features should be leveraged when modeling using Data Vault?

A.Snowflake's support of multi-table inserts into the data model's Data Vault tables
B.Data needs to be pre-partitioned to obtain a superior data access performance
C.Scaling up the virtual warehouses will support parallel processing of new source loads
D.Snowflake's ability to hash keys so that hash key joins can run faster than integer joins

Question 99

By default, the maximum file size that can be unloaded to a single file in snowflake is

A.5 GB for Azure, AWS and GCP
B.10 MB
C.16 MB

Question 100

You have created a reader account for sharing data. who will pay for the compute usage of the account

A.Provider
B.Consumer

Question 96

Question 97

Question 98

Question 99

Question 100

Download PDF File