Question 1

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.)

Options :

A : Clone a table from a share.

B : Grant modify permissions on the share.

C : Create a table from the shared database.

D : Create additional views inside the shared database.

E : Create a table stream on the shared table.

Answer: A,D

Question 2

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

Options :

A : The MERGE command

B : The UPSERT command

C : The CHANGES clause

D : A STREAM object

E : The CHANGE_DATA_CAPTURE command

Answer: C,D

Question 3

Which data models can be used when modeling tables in a Snowflake environment? (Select THREE).

Options :

A : Graph model

B : Dimensional/Kimball

C : Data lake

D : lnmon/3NF

E : Bayesian hierarchical model

F : Data vault

Answer: B,D,F

Question 4

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

Options :

A : Call insertReport every 20 minutes, fetching the last 10,000 entries.

B : Call loadHistoryScan every minute for the maximum time range.

C : Call insertReport every 8 minutes for a 10-minute time range.

D : Call loadHistoryScan every 10 minutes for a 15-minutes range.

Answer: D

Question 5

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.)

Options :

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.

Answer: B,C

Higher Test Marks with Free Online ARA-R01 Exam Practice

Buying Options: