Question 1

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

Question 2

Which of the following statements is/are incorrect regarding Fail-safe data recovery?

Options :

A : Data stored in temporary tables is not recoverable after the table is dropped as they do not have fail-safe.

B : Historical data in transient tables can be recovered by Snowflake due to Operation fail-ure after the Time Travel retention period ends using Fail-safe.

C : Long-lived tables, such as fact tables, should always be defined as permanent to ensure they are fully protected by Fail-safe.

D : Short-lived tables (i.e. <1 day), such as ETL work tables, can be defined as transient to eliminate Fail-safe costs.

E : If downtime and the time required to reload lost data are factors, permanent tables, even with their added Fail-safe costs, may offer a better overall solution than transient tables.

Answer: B

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

In order to improve query perfromance, you can bypass data conversions from the Snowflake internal data type to the native Python data type. Which class in the snowflake.connector.converter_null module do you use for this feature?

Options :

A : SnowflakeNoConverterToPython

B : PythonNoConverterToSnowflake

C : ByPassDataConversion

Answer: A

Question 5

If a user is granted ROLE-A, what roles he can switch from the Snowflake UI?

Options :

A : SYSADMIN, ROLE-A, ROLE-B,ROLE-C,ROLE-D,ROLE-E

B : ROLE-A,ROLE-B,ROLE-C

C : ROLE-A, ROLE-B,ROLE-C,ROLE-D,ROLE-E

D : ROLE-A

Answer: C

Confidently Practice Online with Free DEA-C02 Exam Cram

Buying Options: