Question 1

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 architectured. Highly agile

Options :

A : Data Warehouse

B : Data Mart

C : Data Lake

D : Data Hub

Answer: C

Question 2

Mark the Correct Statements:Statement 1. Enable failover for a primary database to one or more accounts in your organization using anALTER DATABASE … ENABLE FAILOVER TO ACCOUNTS statement.Statement 2. Enabling failover for a primary database can be done by Data Engineer either before or after areplica of the primary database has been created in a specified account.

Options :

A : Statement 1

B : Statement 2

C : Both are False.

D : Both are Correct.

Answer: D

Question 3

Snowflake charges a per-byte fee when users transfer data from your snowflake account into cloud storages in another region on the same cloud platform or into cloud storage in another cloud platform

Options :

A : TRUE

B : FALSE

Answer: A

Question 4

Which is the non-supportable JavaScript UDF data types?

Options :

A : Integers

B : Integers

C : Binary

D : Double

Answer: A

Question 5

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?

Options :

A : REST endpoints --> insertReport

B : REST endpoints --> loadHistoryScan

C : REST endpoints --> ingestfiles

D : REST endpoints--> insertfiles

Answer: D

Free DEA-C02 Mock Exam – Practice Online Confidently

Buying Options: