EMT Practice Test

1. Question Content...

---

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

Question2: 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.

Question3: True or False: During data unloading, only JSON and CSV files can be compressed.

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

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

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

Question7: True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

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

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

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

Question11: What privileges are required to execute a task?

Question12: True or False: Pipes can be suspended and resumed.

Question13: Which of the following statements is true of data loading?
Select one.

Question14: Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

Question15: True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.

Question16: True or False: Snowpipe via RFST API can only reference External Stages as source.

Question17: True or False: A Virtual Warehouse can be resized while suspended.

Question18: Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

Question19: When can a Virtual Warehouse start running queries?

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

Question21: A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers

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

Question23: True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

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

Question25: True or False: A single database can exist in more than one Snowflake account.

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

Question27: True or False: Data Providers can share data with only the Data Consumer.

Question28: True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

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

Question30: If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

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

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

Question33: Which of the following best describes where Snowflake's metadata is stored?

Question34: Which statement best describes Snowflake tables?

Question35: How would you execute a series of SQL statements using Task?

Question36: Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)?
Choose 2 answers

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

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

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

Question40: True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

Question41: The PUT command: (Choose two.)

Question42: True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

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

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

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

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

Question47: What are the three layers that make up Snowflake's architecture?
Choose 3 answer

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

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

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

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

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

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

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

Question55: Which of the following are common use cases for zero-copy cloning?
Choose 3 answers

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

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