Free Snowflake SnowPro-Advanced-Data-Engineer Exam Questions

Become Snowflake Certified with updated SnowPro-Advanced-Data-Engineer exam questions and correct answers

Page: 1 / 48

Total 240 Questions | Updated On: Sep 11, 2021

Add To Cart

Question 1

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

A : TRUE

B : FALSE

Answer: A

Question 2

Snowpipe API provides a REST endpoint for defining the list of files to ingest that Informs Snow-flake about the files to be ingested into a table. A successful response from this endpoint means that Snowflake has recorded the list of files to add to the table. It does not necessarily mean the files have been ingested. What is name of this Endpoint?

A : REST endpoints --> insertReport

B : REST endpoints --> loadHistoryScan

C : REST endpoints --> ingestfiles

D : REST endpoints--> insertfiles

Answer: D

Question 3

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

Question 4

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

A : Data Warehouse

B : Data Mart

C : Data Lake

D : Data Hub

Answer: C

Question 5

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?