EMT Practice Test

1. Question Content...

---

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

Question2: Select the three types of tables that exist within Snowflake.
Choose 3 answers

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

Question4: Which item in the Data Warehouse migration process does not apply in Snowflake>

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

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

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

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

Question9: Which of the following statements is true of Snowflake?

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

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

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

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

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

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

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

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

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

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

Question20: A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

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

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

Question23: True or False: Users are able to see the result sets of queries executed by other users that share their same role.

Question24: When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

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

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

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

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

Question29: True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

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

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

Question32: For a multi-cluster Warehouse, the number of credits billed is calculated on:
Select one.

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

Question34: How a Snowpipe charges calculated?

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

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

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

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

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

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

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

Question42: Which are true of Snowflake roles?

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

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

Question45: True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

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

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

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

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

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

Question51: What command is used to load files into an Internal Stage within Snowflake? Select one.

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

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