EMT Practice Test

1. Question Content...

---

Question1: Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

Question2: Which of the following statements are true of Snowflake data loading?
Choose 3 answers

Question3: Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?
Select one.

Question4: What is the minimum duration charged when starting a virtual warehouse?

Question5: Data storage for individual tables can be monitored using which commands and/or object(s)?
Choose 2 answers

Question6: What is the lowest Snowflake edition that offers Time Travel up to 90 days.

Question7: Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answers

Question8: What is the maximum compressed row size in Snowflake?

Question9: Which type of table corresponds to a single Snowflake session?

Question10: Which of the following statements is true of Snowflake micro-partitioning?

Question11: When a pipe is recreated using the CREATE on REPLAC PIPE command:
Select one.

Question12: Which of the following statements would be used to export/unload data from Snowflake?

Question13: True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

Question14: On which of the following cloud platform can a Snowflake account be hosted?
Choose 2 answers

Question15: What happens when a Data Provider revokes privileges to a Share on an object in their source database?

Question16: True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

Question17: True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

Question18: True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

Question19: True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

Question20: What are the three things customers want most from their enterprise data warehouse solution?
Choose 3 answers

Question21: Which of the following statement is true of Snowflake?
Select one.

Question22: Account-level storage usage can be monitored via:

Question23: When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:
Select one.

Question24: Which of the following statements about data sharing are true?
choose 2 answers

Question25: True or False: Once created, a micro-partition will never be changed.

Question26: Which statement best describes Snowflake tables?

Question27: True or False the longer the data retention period, the higher the resulting storage costs.

Question28: What is the most granular object that the Time Travel retention can be defined on?
Select one.

Question29: Which of the following statements is true of zero-copy cloning?

Question30: True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

Question31: What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?
Select one.

Question32: Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:

Question33: Which of the following statement is true of Snowflake?
Select one.

Question34: Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles?
Choose 3 answers

Question35: Which are true of Snowflake roles?