Question 1

Multi-cluster warehouses are best utilized for

Options :

A : Scaling resources to improve concurrency for users/queries

B : Improving the performance of slow-running queries

C : Improving the performance of data loading

Answer: A

Question 2

An Architect needs to meet a company requirement to ingest files from the company's AWS storage accounts into the company's Snowflake Google Cloud Platform (GCP) account. How can the ingestion of these files into the company's Snowflake account be initiated? (Select TWO).

Options :

A :

Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.

B :

Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 Glacier storage.

C :

Create an AWS Lambda function to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.

D :

Configure AWS Simple Notification Service (SNS) to notify Snowpipe when new files have arrived in Amazon S3 storage.

E :

Configure the client application to issue a COPY INTO command to Snowflake when new files have arrived in Amazon S3 Glacier storage.

Answer: A,C

Question 3

Which Snowflake architecture recommendation needs multiple Snowflake accounts for implementation?

Options :

A : Enable a disaster recovery strategy across multiple cloud providers.

B :

Create external stages pointing to cloud providers and regions other than the region hosting the Snowflake account.

C : Enable zero-copy cloning among the development, test, and production environments.

D : Enable separation of the development, test, and production environments.

Answer: D

Question 4

Choose the different ways that you have to optimize query performance

Options :

A : Clustering a table

B : Creating one or more materialized views

C : Search Optimization

D : Vacuuming

Answer: A,B,C

Question 5

While loading CSV data using the COPY INTO statement, a Data Engineer encounters the following error.

Number of columns in file (15) does not match that of the corresponding table (14)

Which approach should the Data Engineer take to solve this problem and load all the fields in the file into the table? (Choose two.)

Options :

A : Make necessary changes in the table DDL to support all the columns in the file.

B : Set the copy option FORCE to true.

C : Modify the file data to use a different file format. Change the file format type in the file format options during the loading process.

D : Modity the file data to enclose fields with a delimiter. Leverage the FIELD_OPTIONALLY_ENCLOSED_BY option in the file format during the load process.

E : Do not modify the file data. Change the ERROR_ON_COLUMN_COUNT_MISMATCH option in the file format to false during the loading process.

Answer: A,E

Confidently Practice Online with Free SnowPro-Advanced-Architect Exam Cram

Buying Options: