ARA-C01 Practice Exam Questions and Answers

A.  

Permanent table

B.  

Transient table

C.  

Temporary table

D.  

External tables

E.  

Internal stages

A.  

The warehouse MY_WH will be made active every five minutes to check the stream.

B.  

The warehouse MY_WH will only be active when there are results in the stream.

C.  

The warehouse MY_WH will never suspend.

D.  

The warehouse MY_WH will automatically resize to accommodate the size of the stream.

A.  

External table

B.  

Materialized view

C.  

Search optimization

D.  

Result cache

A.  

COPY INTO tablea FROM @%tablea RETURN_FAILED_ONLY = TRUE;

B.  

COPY INTO tablea FROM @%tablea;

C.  

COPY INTO tablea FROM @%tablea FILES = ('file5.csv');

D.  

COPY INTO tablea FROM @%tablea FORCE = TRUE;

E.  

COPY INTO tablea FROM @%tablea NEW_FILES_ONLY = TRUE;

F.  

COPY INTO tablea FROM @%tablea MERGE = TRUE;

A.  

There needs to be fewer objects per tenant.

B.  

Security and Role-Based Access Control (RBAC) policies must be simple to configure.

C.  

Compute costs must be optimized.

D.  

Tenant data shape may be unique per tenant.

E.  

Storage costs must be optimized.

A.  

CSV

B.  

XML

C.  

Avro

D.  

JSON

E.  

Parquet

A.  

TRANSIENT

B.  

TEMPORARY

C.  

PERMANENT

A.  

Global

B.  

Database

C.  

Schema

D.  

Table

A.  

Create a new account (called AZABC123) in Azure East US 2 region. From account ACCOUNTA create a share of database MARKET_DB, create a new database out of this share locally in AWS us-east-1 region, and replicate this new database to AZABC123 account. Then set up data sharing to the PARTNERB account.

B.  

From account ACCOUNTA create a share of database MARKET_DB, and create a new database out of this share locally in AWS us-east-1 region. Then make this database the provider and share it with the PARTNERB account.

C.  

Create a new account (called AZABC123) in Azure East US 2 region. From account ACCOUNTA replicate the database MARKET_DB to AZABC123 and from this account set up the data sharing to the PARTNERB account.

D.  

Create a share of database MARKET_DB, and create a new database out of this share locally in AWS us-east-1 region. Then replicate this database to the partner’s account PARTNER

B.