DEA-C01 Practice Questions

A.  

Data Warehouse

B.  

Data Mart

C.  

Data Lake

D.  

Data Hub

A.  

Standard streams cannot retrieve update data for geospatial data.

B.  

An append-only stream returns the appended rows only and therefore can be much more performant than a standard stream for extract, load, transform (ELT).

C.  

Insert-only Stream supported on external tables only.

D.  

An insert-only stream tracks row inserts & Delete ops only

A.  

Query Optimizer

B.  

Performance Metadata table

C.  

Query Profile

D.  

Query Designer

A.  

Query results contain a small number of rows and/or columns relative to the base table (the table on which the view is defined).

B.  

Query results contain results that require significant processing.

C.  

The query is on an external table (i.e. data sets stored in files in an external stage), which might have slower performance compared to querying native database tables.

D.  

The view’s base table change frequently.

A.  

Snowflake supports using MFA in conjunction with SSO to provide additional levels of security.

B.  

Snowflake supports multiple audience values (i.e. Audience or Audience Restriction Fields) in the SAML 2.0 assertion from the identity provider to Snowflake.

C.  

Snowflake supports SSO with Private Connectivity to the Snowflake Service for Snow-flake accounts on Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform.

D.  

Snowflake supports using SSO with organizations, and you can use the corresponding URL in the SAML2 security integration.

A.  

SISENSE

B.  

SELECT STAR

C.  

ALATION

D.  

PROTEGRITY

A.  

TRUE

B.  

FALSE

A.  

TRUE

B.  

FALSE

A.  

Split larger files into a greater number of smaller files, maximize the processing over-head for each file.

(Correct)

B.  

Enabling the STRIP_OUTER_ARRAY file format option for the COPY INTO command to remove the outer array structure and load the records into separate table rows.

C.  

Amazon Kinesis Firehose can be convenient way to aggregate and batch data files which also allows defining both the desired file size, called the buffer size, and the wait interval after which a new file is sent, called the buffer interval.

D.  

When preparing your delimited text (CSV) files for loading, the number of columns in each row should be consistent.

E.  

if the “null” values in your files indicate missing values and have no other special mean-ing, Snowflake recommend setting the file format option STRIP_NULL_VALUES to TRUE when loading the semi-structured data file.