Question 1

Suppose you have two databases D1 and D2. Theses databases contain data required by business analysts in your organization. Based on their functional responsibilities, entry level analysts should have read only access to D1, but access to D2 should be given to advanced analysts only. Which option will you choose to setup the access?

Options :

A :

2020-09-06-20-26-48-21b07202e527a5b67bbba720952a3ecf

B :

C :

Answer: C

Question 2

When does a stream become stale?

Options :

A : When it’s dropped

B : When its offset is outside of the data retention period for its source table

C : When it’s consumed

D : When it-s created

Answer: B

Question 3

Data sharing is supported only between provider and consumer accounts in same region

Options :

A : TRUE

B : FALSE

Answer: B

Question 4

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

Question 5

Which ALTER commands will impact a column's availability in Time Travel?

Options :

A : ALTER TABLE … DROP COLUMN …

B : ALTER TABLE … SET NOT NULL …

C : ALTER TABLE … SET DATA TYPE …

D : ALTER TABLE … RENAME COLUMN …

Answer: C

Free ARA-C01 Mock Exam – Practice Online Confidently

Buying Options: