Question 1

Stuart, a Lead Data Engineer in MACRO Data Company created streams on set of External tables. He has been asked to extend the data retention period of the stream for 90 days, which parameter he can utilize to enable this extension?

Options :

A : MAX_DATA_EXTENSION_TIME_IN_DAYS

B : DATA_RETENTION_TIME_IN_DAYS

C : DATA_EXTENSION_TIME_IN_DAYS

D : None of the above

Answer: D

Question 2

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

Options :

A : TRUE

B : FALSE

Answer: A

Question 3

Each micro partition contains between 50 mb and 500 MB of uncompressed data

Options :

A : TRUE

B : FALSE

Answer: B

Question 4

For a particular business group, number of concurrent users are large but do not fluctuate. These users run queries on snowflake and expects extremely low latency response. The queries are all standard and same and need to be served from the result cache to meet the low latency requirement. Which of the below option will you choose?

Options :

A : Provision a multi-cluster warehouse and run it in maximized mode

B : Provision a multi-cluster warehouse and run it in economy mode

C : Provision a small warehouse and monitor the query overload metrics

Answer: A

Question 5

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

Options :

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