Question 1

An Architect creates a view to fetch data which is aggregated on SALES_DATE and LOCATION, using the following command:

The view results are slow to process as millions of records are retrieved.

How could the Architect use cluster keys to address this latency?

Options :

A : Use the command ALTER VIEW VW_FETCHAGGREGATEDDATA RECLUSTER;

B : Use the command ALTER VIEW VW_FETCHAGGREGATEDDATA CLUSTER BY (SALES_DATE, LOCATION);

C : Recreate this view to be a materialized view then execute the command ALTER MATERIALIZED VIEW VW_FETCHAGGREGATEDDATA CLUSTER BY (SALES_DATE, LOCATION);

D : Cluster the columns from this view that are most actively used in selective filters.

Answer: C

Question 2

While using joins, non-equality join predicates might result in significantly slower processing speeds and should be avoided if possible.

Options :

A : TRUE

B : FALSE

Answer: A

Question 3

What is the data size limit for loading into a variant column?

Options :

A : 16 MB(Compressed)

B : 1 GB(Compressed)

C : 32 GB

D : 10 MB - 100 MB compressed

Answer: A

Question 4

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 5

Files stored in snowflake stage are automatically encrypted using either AES 128 or 256 strong encryption.

Options :

A : TRUE

B : FALSE

Answer: A

Confidently Practice Online with Free ARA-C01 Exam Cram

Buying Options: