EMT Practice Test

1. Question Content...

---

Question1: Snowflake is designed for which type of workloads? (Choose two.)

Question2: True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

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

Question4: Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

Question5: True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

Question6: A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

Question7: Select the different types of Internal Stages: (Choose three.)

Question8: Which of the following statements is true of data loading?

Question9: True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

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

Question11: True or False: Fail-safe can be disabled within a Snowflake account.

Question12: True or false: it is best practice to define a clustering key on every table.

Question13: How a Snowpipe charges calculated?

Question14: True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.

Question15: Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are: Choose 2 answers

Question16: Which of the following objects is not covered by Time Travel?

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

Question18: Which interfaces can be used to create and/or manage Virtual Warehouses?

Question19: True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

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

Question21: The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

Question22: When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:

Question23: Which of the following items does the Cloud services Layer manage? Choose 4 answers

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

Question25: Which of the following are options when creating a Virtual Warehouse?

Question26: When creating a user it is advisable sable to: Choose 2 answers

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

Question28: Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy?

Question29: True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

Question30: Which formats are supported for unloading data from Snowflake? Choose 2 answers

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

Question32: True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

Question33: Which statements are true of micro-partitions? Choose 2 answers

Question34: The Query History in the Snowflake Web Interface (UI) is kept for approximately:

Question35: As a best practice, clustering keys should only be defined on tables of which minimum size?

Question36: The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers

Question37: Which of the following commands sets the Virtual Warehouse for a session?

Question38: Which of the following statements are true about Schemas in Snowflake? (Choose two.)

Question39: Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?

Question40: True or False: All Snowflake table types include fail-safe storage.

Question41: Which statement best describes '' clustering''?

Question42: If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

Question43: Which of the following commands are not blocking operations?
Choose 2 answers

Question44: True or False: When you create a custom role, it is a practice to immediately grant that role to ACCOUNTADMIN.

Question45: True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

Question46: The FLATEEN function is used to query which type of data in Snowflake?

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

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

Question49: What is the default File Format used in the COPY command if one is not specified?

Question50: True or False: Snowflake charges additional fees to Data providers for each share they create.

Question51: What is the recommended method for loading data into Snowflake?

Question52: True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.