Snowflake SnowPro Advanced: Architect Recertification - ARA-R01 Exam Practice Test

Question 1

An Architect is designing a file ingestion recovery solution. The project will use an internal named stage for file storage. Currently, in the case of an ingestion failure, the Operations team must manually download the failed file and check for errors.
Which downloading method should the Architect recommend that requires the LEAST amount of operational overhead?

A. Use the get command in Snowsight to retrieve the file. B. Use the get command in SnowSQL to retrieve the file. C. Use the Snowflake API endpoint and download the file. D. Use the Snowflake Connector for Python, connect to remote storage and download the file.

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 2

Following objects can be cloned in snowflake

A. External tables B. Temporary table C. Transient table D. Permanent table E. Internal stages

Correct Answer: A,C,D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 3

Company A has recently acquired company B. The Snowflake deployment for company B is located in the Azure West Europe region.
As part of the integration process, an Architect has been asked to consolidate company B's sales data into company A's Snowflake account which is located in the AWS us-east-1 region.
How can this requirement be met?

A. Replicate the sales data from company B's Snowflake account into company A's Snowflake account using cross-region data replication within Snowflake. Configure a direct share from company B's account to company A's account. B. Export the sales data from company B's Snowflake account as CSV files, and transfer the files to company A's Snowflake account. Import the data using Snowflake's data loading capabilities. C. Migrate company B's Snowflake deployment to the same region as company A's Snowflake deployment, ensuring data locality. Then perform a direct database-to-database merge of the sales data. D. Build a custom data pipeline using Azure Data Factory or a similar tool to extract the sales data from company B's Snowflake account. Transform the data, then load it into company A's Snowflake account.

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 4

The Data Engineering team at a large manufacturing company needs to engineer data coming from many sources to support a wide variety of use cases and data consumer requirements which include:
1) Finance and Vendor Management team members who require reporting and visualization
2) Data Science team members who require access to raw data for ML model development
3) Sales team members who require engineered and protected data for data monetization What Snowflake data modeling approaches will meet these requirements? (Choose two.)

A. Consolidate data in the company's data lake and use EXTERNAL TABLES. B. Create a raw database for landing and persisting raw data entering the data pipelines. C. Create a set of profile-specific databases that aligns data with usage patterns. D. Create a single star schema in a single database to support all consumers' requirements. E. Create a Data Vault as the sole data pipeline endpoint and have all consumers directly access the Vault.

Correct Answer: B,C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 5

What does a Snowflake Architect need to consider when implementing a Snowflake Connector for Kafka?

A. Every Kafka message is in JSON or Avro format. B. The Kafka connector will create one table and one pipe to ingest data for each topic. If the connector cannot create the table or the pipe it will result in an exception. C. The Kafka connector supports key pair authentication, OAUTH. and basic authentication (for example, username and password). D. The default retention time for Kafka topics is 14 days.

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 6

Which technique will efficiently ingest and consume semi-structured data for Snowflake data lake workloads?

A. IDEF1X B. Schema-on-read C. Schema-on-write D. Information schema

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 7

Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)

A. SYSTEM$CLUSTERING_DEPTH B. SYSTEM$CLUSTERING_KEYS C. SYSTEM$CLUSTERING_USAGE D. SYSTEM$CLUSTERING_PERCENT E. SYSTEM$CLUSTERING_INFORMATION

Correct Answer: A,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 8

How can the Snowpipe REST API be used to keep a log of data load history?

A. Call insertReport every 20 minutes, fetching the last 10,000 entries. B. Call insertReport every 8 minutes for a 10-minute time range. C. Call loadHistoryScan every minute for the maximum time range. D. Call loadHistoryScan every 10 minutes for a 15-minutes range.

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 9

A company needs to share its product catalog data with one of its partners. The product catalog data is stored in two database tables: product_category, and product_details. Both tables can be joined by the product_id column. Data access should be governed, and only the partner should have access to the records.
The partner is not a Snowflake customer. The partner uses Amazon S3 for cloud storage.
Which design will be the MOST cost-effective and secure, while using the required Snowflake features?

A. Create a reader account for the partner and share the data sets as secure views. B. Use Secure Data Sharing with an S3 bucket as a destination. C. Publish product_category and product_details data sets on the Snowflake Marketplace. D. Create a database user for the partner and give them access to the required data sets.

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 10

A media company needs a data pipeline that will ingest customer review data into a Snowflake table, and apply some transformations. The company also needs to use Amazon Comprehend to do sentiment analysis and make the de-identified final data set available publicly for advertising companies who use different cloud providers in different regions.
The data pipeline needs to run continuously ang efficiently as new records arrive in the object storage leveraging event notifications. Also, the operational complexity, maintenance of the infrastructure, including platform upgrades and security, and the development effort should be minimal.
Which design will meet these requirements?

A. Ingest the data using Snowpipe and use streams and tasks to orchestrate transformations. Export the data into Amazon S3 to do model inference with Amazon Comprehend and ingest the data back into a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies. B. Ingest the data into Snowflake using Amazon EMR and PySpark using the Snowflake Spark connector.
Apply transformations using another Spark job. Develop a python program to do model inference by leveraging the Amazon Comprehend text analysis API. Then write the results to a Snowflake table and create a listing in the Snowflake Marketplace to make the data available to other companies. C. Ingest the data using Snowpipe and use streams and tasks to orchestrate transformations. Create an external function to do model inference with Amazon Comprehend and write the final records to a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies. D. Ingest the data using COPY INTO and use streams and tasks to orchestrate transformations. Export the data into Amazon S3 to do model inference with Amazon Comprehend and ingest the data back into a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 11

Is it possible for a data provider account with a Snowflake Business Critical edition to share data with an Enterprise edition data consumer account?

A. If a user in the provider account with a share owning role which also has override share restrictions privilege share_restrictions set to False when adding an Enterprise consumer account, it can import the share. B. If a user in the provider account with role authority to create or alter share adds an Enterprise account as a consumer, it can import the share. C. A Business Critical account cannot be a data sharing provider to an Enterprise consumer. Any consumer accounts must also be Business Critical. D. If a user in the provider account with a share owning role sets share_restrictions to False when adding an Enterprise consumer account, it can import the share.

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 12

Which columns can be included in an external table schema? (Select THREE).

A. METADATASROW_ID B. METADAT A$ FILENAME C. METADATASEXTERNAL TABLE PARTITION D. METADATAS FILE_ROW_NUMBER E. VALUE F. METADATASISUPDATE

Correct Answer: B,D,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).