EMT Practice Test

1. Question Content...

---

Question1: Which command can be used to stage local files from which Snowflake interface?

Question2: Which stage type can be altered and dropped?

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

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

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

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

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

Question8: What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

Question9: In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

Question10: The PUT command: (Choose two.)

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

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

Question13: What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

Question14: Which services does the Snowflake Cloud Services layer manage? (Select TWO).

Question15: Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

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

Question17: True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

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

Question19: What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

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

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

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

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

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

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

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

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

Question28: What is the default character set used when loading CSV files into Snowflake?

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

Question30: In which layer of its architecture does Snowflake store its metadata statistics?
Select one.

Question31: A user unloaded a Snowflake table called mytable to an internal stage called mystage.
Which command can be used to view the list of files that has been uploaded to the staged?

Question32: What are ways to create and manage data shares in Snowflake? (Select TWO)

Question33: Which of the following are options when creating a virtual Warehouse?
Choose 2 answers

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

Question35: What privileges are required to create a task?

Question36: Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

Question37: What data is stored in the Snowflake storage layer? (Select TWO).

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

Question39: What is the recommended file sizing for data loading using Snowpipe?

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

Question41: When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

Question42: What tasks can be completed using the copy command? (Select TWO)

Question43: Which command can be used to load data into an internal stage?

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

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

Question46: A user has 10 files in a stage containing new customer dat
a. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?

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

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

Question49: A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?

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

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

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

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

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

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

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

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

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

Question59: How long is Snowpipe data load history retained?

Question60: What privileges are required to execute a task?

Question61: What is the purpose of multi-cluster virtual warehouses?

Question62: Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

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

Question64: Which data type can be used to store geospatial data in Snowflake?

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

Question66: Which of the following describes how clustering keys work in Snowflake?

Question67: Which of the following can be executed/called with Snowpipe?

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

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

Question70: Which command is used to unload data from a Snowflake table into a file in a stage?

Question71: How a Snowpipe charges calculated?

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

Question73: When is the result set cache no longer available? (Select TWO)

Question74: If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

Question75: Which statement best describes Snowflake tables?

Question76: Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

Question77: Which of the following roles is recommended to be used to create and manage users and roles?

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

Question79: When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

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

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

Question82: Which statement about billing applies to Snowflake credits?

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