EMT Practice Test

1. Question Content...

---

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

Question2: The PUT command: (Choose two.)

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

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

Question5: Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
Select one:

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

Question7: When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers

Question8: Which of the following statements are true of Snowflake releases: (Choose two.)

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

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

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

Question12: What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

Question13: True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).

Question14: Snowflake provides a mechanism for its customers to override its clustering algorithms. This method is:

Question15: Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)

Question16: When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers

Question17: What is the minimum Snowflake edition that provides data sharing?

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

Question19: Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

Question20: True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

Question21: True or False: You can define multiple columns within a clustering key on a table.

Question22: True or False: It is possible to load data into Snowflake without creating a named File Format object.

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

Question24: Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

Question25: Which of the following terms best describes Snowflake's database architecture?

Question26: Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Question27: True or False: The COPY command must specify a File Format in order to execute.

Question28: How many shares can be consumed by single Data Consumer?

Question29: When loading data into Snowflake, the COPY command supports:
Choose 2 answers

Question30: Fail-safe is unavailable on which table types?

Question31: Which of the following DML commands isn't supported by Snowflake?

Question32: Which object allows you to limit the number of credits consumed within a Snowflake account?
Select one.

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

Question34: True or False: You can resize a Virtual Warehouse while queries are running.

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

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

Question37: Which are true of Snowflake roles?

Question38: which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.

Question39: True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

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

Question41: Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy?
Select one.

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

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

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

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

Question46: True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.