Question 1

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

Question 2

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

Options :

A : WAREHOUSE_METERING_HISTORY

B : WAREHOUSE_CREDIT_USAGE_HISTORY

C : WAREHOUSE_USAGE_HISTORY

Answer: A

Question 3

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

Question 4

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?

Options :

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 5

David, a Lead Data engineer with XYZ company looking out to improve query performance & oth-er benefitswhile working with Tables, Regular Views, MVs and Cached Results.Which one of the following does not shows key similarities and differences between tables, regular views,cached query results, and materialized views while choosing any of them by David?

Options :

A : Regular views do not cache data, and therefore cannot improve performance by cach-ing.

B : As with non-materialized views, a materialized view automatically inherits the privileges of its base table.

C : Cached Query Results: Used only if data has not changed and if query only uses de-terministic functions (e.g. not CURRENT_DATE).

D : Materialized views are faster than tables because of their “cache” (i.e. the query results for the view); in addition, if data has changed, they can use their “cache” for data that hasn’t changed and use the base table for any data that has changed.

E : Both materialized views and regular views enhance data security by allowing data to be exposed or hidden at the row level or column level.

Answer: B

Free SnowPro-Advanced-Data-Engineer Mock Exam – Practice Online Confidently

Buying Options: