Free SnowPro Advanced: Data Engineer Certification Exam Practice Questions

Question # 31

Which of the following System keeps the following characteristics?

a. It will keep in it all the raw data.

b. Generally, the users of it is data scientists and data developers.

c. Flat architecture

d. Highly agile

Options:

Data Warehouse

Data Mart

Data Lake

Data Hub

Discussion 0

Question # 32

Mark the Incorrect Statements with respect to types of streams supported by Snowflake?

Options:

Standard streams cannot retrieve update data for geospatial data.

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

Insert-only Stream supported on external tables only.

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

Discussion 0

Question # 33

Data Engineer looking out for quick tool for understanding the mechanics of queries & need to know more about the performance or behaviour of a particular query.

He should go to which feature of snowflake which can help him to spot typical mistakes in SQL query expressions to identify potential performance bottlenecks and improvement opportunities?

Options:

Query Optimizer

Performance Metadata table

Query Profile

Query Designer

Discussion 0

Question # 34

Which Scenario Data engineer decide Materialized views are not useful. Select All that apply.

Options:

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

Query results contain results that require significant processing.

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.

The view’s base table change frequently.

Discussion 0

Question # 35

Select the Correct statements with regard to using Federated authentication/SSO?

Options:

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

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

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.

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

Discussion 0

Question # 36

If you need to connect to Snowflake using a BI tool or technology, which of the following BI tools and technologies are known to provide native connectivity to Snowflake?

Options:

SISENSE

SELECT STAR

ALATION

PROTEGRITY

Discussion 0

Question # 37

Can Masking policies be applied to virtual columns?

Options:

TRUE

FALSE

Discussion 0

Question # 38

Clones can be cloned, with no limitations on the number or iterations of clones that can be created (e.g. you can create a clone of a clone of a clone, and so on), which results in a n-level hierarchy of cloned objects, each with their own portion of shared and independent data storage?

Options:

TRUE

FALSE

Discussion 0

Question # 39

For the most efficient and cost-effective Data load experience, Data Engineer needs to inconsider-ate which of the following considerations?

Options:

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

(Correct)

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.

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.

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

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.

Discussion 0