Snowflake ARA-C01 Quiz 1 Topic 3 Questions 1-5

Question: 1

When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)

ACSV

BXML

CAvro

DJSON

EParquet

Show Answer

Question: 2

A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines.

Which actions can the company take with the inbound share? (Choose two.)

AClone a table from a share.

BGrant modify permissions on the share.

CCreate a table from the shared database.

DCreate additional views inside the shared database.

ECreate a table stream on the shared table.

Show Answer

Question: 3

At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?

AGlobal

BDatabase

CSchema

DTable

Show Answer

Question: 4

Which security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)

AExtended Time Travel (up to 90 days)

BCustomer-managed encryption keys through Tri-Secret Secure

CPeriodic rekeying of encrypted data

DAWS, Azure, or Google Cloud private connectivity to Snowflake

EFederated authentication and SSO

Show Answer

Question: 5

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?

AUtilize a higher Buffer.flush.time in the connector configuration.

BUtilize a higher Buffer.size.bytes in the connector configuration.

CUtilize a lower Buffer.size.bytes in the connector configuration.

DUtilize a lower Buffer.count.records in the connector configuration.

Show Answer

Snowflake ARA-C01 Quiz:1 Topic:3 Questions:1-5