Free Access to Snowflake.ARA-R01.v2024-10-29.q82 with Valid Practice Test (Page 11)

Question 46

An Architect is designing a pipeline to stream event data into Snowflake using the Snowflake Kafka connector. The Architect's highest priority is to configure the connector to stream data in the MOST cost-effective manner.
Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?

A.Utilize a higher Buffer.flush.time in the connector configuration.
B.Utilize a higher Buffer.size.bytes in the connector configuration.
C.Utilize a lower Buffer.size.bytes in the connector configuration.
D.Utilize a lower Buffer.count.records in the connector configuration.

Question 47

A company is designing high availability and disaster recovery plans and needs to maximize redundancy and minimize recovery time objectives for their critical application processes. Cost is not a concern as long as the solution is the best available. The plan so far consists of the following steps:
1. Deployment of Snowflake accounts on two different cloud providers.
2. Selection of cloud provider regions that are geographically far apart.
3. The Snowflake deployment will replicate the databases and account data between both cloud provider accounts.
4. Implementation of Snowflake client redirect.
What is the MOST cost-effective way to provide the HIGHEST uptime and LEAST application disruption if there is a service event?

A.Connect the applications using the <organization_name>-<connection_name> URL. Use the Business Critical Snowflake edition.
B.Connect the applications using the <organization_name>-<connection_name> URL. Use the Virtual Private Snowflake (VPS) edition.
C.Connect the applications using the <organization_name>-<accountLocator> URL. Use the Enterprise Snowflake edition.
D.Connect the applications using the <organization_name>-<accountLocator> URL. Use the Business Critical Snowflake edition.

Question 48

A company's daily Snowflake workload consists of a huge number of concurrent queries triggered between
9pm and 11pm. At the individual level, these queries are smaller statements that get completed within a short time period.
What configuration can the company's Architect implement to enhance the performance of this workload?
(Choose two.)

A.Enable a multi-clustered virtual warehouse in maximized mode during the workload duration.
B.Set the MAX_CONCURRENCY_LEVEL to a higher value than its default value of 8 at the virtual warehouse level.
C.Increase the size of the virtual warehouse to size X-Large.
D.Reduce the amount of data that is being processed through this workload.
E.Set the connection timeout to a higher value than its default.

Question 49

Company A would like to share data in Snowflake with Company B. Company B is not on the same cloud platform as Company A.
What is required to allow data sharing between these two companies?

A.Create a pipeline to write shared data to a cloud storage location in the target cloud provider.
B.Ensure that all views are persisted, as views cannot be shared across cloud platforms.
C.Setup data replication to the region and cloud platform where the consumer resides.
D.Company A and Company B must agree to use a single cloud platform: Data sharing is only possible if the companies share the same cloud provider.

Correct Answer: C

According to the SnowPro Advanced: Architect documents and learning resources, the requirement to allow data sharing between two companies that are not on the same cloud platform is to set up data replication to the region and cloud platform where the consumer resides. Data replication is a feature of Snowflake that enables copying databases across accounts in different regions and cloud platforms. Data replication allows data providers to securely share data with data consumers across different regions and cloud platforms by creating a replica database in the consumer's account. The replica database is read-only and automatically synchronized with the primary database in the provider's account. Data replication is useful for scenarios where data sharing is not possible or desirable due to latency, compliance, or security reasons1. The other options are incorrect because they are not required or feasible to allow data sharing between two companies that are not on the same cloud platform. Option A is incorrect because creating a pipeline to write shared data to a cloud storage location in the target cloud provider is not a secure or efficient way of sharing data. It would require additional steps to load the data from the cloud storage to the consumer's account, and it would not leverage the benefits of Snowflake's data sharing features. Option B is incorrect because ensuring that all views are persisted is not relevant for data sharing across cloud platforms. Views can be shared across cloud platforms as long as they reference objects in the same database. Persisting views is an option to improve the performance of querying views, but it is not required for data sharing2. Option D is incorrect because Company A and Company B do not need to agree to use a single cloud platform. Data sharing is possible across different cloud platforms using data replication or other methods, such as listings or auto-fulfillment3. References: Replicating Databases Across Multiple Accounts | Snowflake Documentation, Persisting Views | Snowflake Documentation, Sharing Data Across Regions and Cloud Platforms | Snowflake Documentation

Question 50

A global company needs to securely share its sales and Inventory data with a vendor using a Snowflake account.
The company has its Snowflake account In the AWS eu-west 2 Europe (London) region. The vendor's Snowflake account Is on the Azure platform in the West Europe region. How should the company's Architect configure the data share?

A.1. Create a share.
2. Add objects to the share.
3. Add a consumer account to the share for the vendor to access.
B.1. Create a share.
2. Create a reader account for the vendor to use.
3. Add the reader account to the share.
C.1. Create a new role called db_share.
2. Grant the db_share role privileges to read data from the company database and schema.
3. Create a user for the vendor.
4. Grant the ds_share role to the vendor's users.
D.1. Promote an existing database in the company's local account to primary.
2. Replicate the database to Snowflake on Azure in the West-Europe region.
3. Create a share and add objects to the share.
4. Add a consumer account to the share for the vendor to access.

Question 46

Question 47

Question 48

Question 49

Question 50

Download PDF File