Question 1

To which entity do we grant privileges?

Options :

A : Users

B : Groups

C : Roles

D : Account

Answer: C

Question 2

What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?

Options :

A : The Connector only works in Snowflake regions that use AWS infrastructure.

B : The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.

C : The Connector creates and manages its own stage, file format, and pipe objects.

D : Loads using the Connector will have lower latency than Snowpipe and will ingest data in real time.

Answer: C

Question 3

Which are the two VARIANT columns each schema has in every Snowflake table loaded by the Kafka connector? (Choose two.)

Options :

A : RECORD_ISCORRECT

B : RECORD_SUMMARY

C : RECORD_PRIVILEGES

D : RECORD_METADATA

E : RECORD_CONTENT

Answer: D,E

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

Which alter command below may affect the availability of column with respect to time travel?

Options :

A : ALTER TABLE...DROP COLUMN

B : ALTER TABLE...SET DATA TYPE

C : ALTER TABLE...SET DEFAULT

Answer: B

Confidently Practice Online with Free ARA-C01 Exam Cram

Buying Options: