Practice SnowPro-Advanced-Data-Engineer Exam Online

Question 1

Mark the incorrect statement in case Data engineer using the COPY INTO command to load data from files into Snowflake tables?

A : For Data loading of files with semi-structured file formats (JSON, Avro, etc.), the only supported character set is UTF-16.

B : For loading data from all semi-structured supported file formats (JSON, Avro, etc.), as well as unloading data, UTF-8 is the only supported character set.

C : For Local environment, Files are first copied (“staged”) to an internal (Snowflake) stage, then loaded into a table.

D : UTF-32 & UTF-16 both encoding character sets supported for loading data from de-limited files (CSV, TSV, etc.)

Answer: A

Question 2

Snowflake computes and adds partitions based on the defined partition column expressions when an external table metadata is refreshed. What are the Correct Statements to configure Partition metadata refresh in case of External Tables?

A : By default, the metadata is refreshed automatically when the object is created.

B : The object owner can configure the metadata to refresh automatically when new or updated data files are available in the external stage.

C : Metadata refresh is not required as its Managed implicitly by Snowflake.

D : Partitions of External tables is managed by External Stage Cloud provider.

E : There is nothing like adding partitions on External tables.

Answer: A,B

Question 3

Which system table will you use to get the total credit consumption over a specific time period?

A : WAREHOUSE_METERING_HISTORY

B : WAREHOUSE_CREDIT_USAGE_HISTORY

C : WAREHOUSE_USAGE_HISTORY

Answer: A

Question 4

The smaller the average depth, the better clustered the table is with regards to the specified column?

A : TRUE

B : FALSE

Answer: A

Question 5

While using kafka connector, what charges are applied to your account?

A : Snowpipe processing time

B : Data storage

C : Kafka connector usage

Answer: A,B

Name:	SnowPro Advanced Data Engineer
Exam Code:	SnowPro-Advanced-Data-Engineer
Certification:	SnowPro Certification
Vendor:	Snowflake
Total Questions:	240
Last Updated:	Apr 23, 2024

Snowflake SnowPro-Advanced-Data-Engineer