Exact2Pass
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?
What privilege should a user be granted to change permissions for new objects in a managed access schema?
The Snowflake Search Optimization Services supports improved performance of which kind of query?
Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
What COPY INTO SQL command should be used to unload data into multiple files?
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.
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?
Which services does the Snowflake Cloud Services layer manage? (Select TWO).
A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
What SQL command would be used to view all roles that were granted to user.1?
True or False: During data unloading, only JSON and CSV files can be compressed.
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.
True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.
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.
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
True or False: An active warehouse is required to run a COPY INTO statement.
True or False: The COPY command must specify a File Format in order to execute.
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?
What are the three layers that make up Snowflake’s architecture?
Choose 3 answer
True or False: A single database can exist in more than one Snowflake account.
Which of the following roles is recommended to be used to create and manage users and roles?
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)
What are supported file formats for unloading data from Snowflake? (Choose three.)
A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed
When the user returns, how much billable compute time will have been consumed?
When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
Where can a user find and review the failed logins of a specific user for the past 30 days?
Which of the following objects are contained within a schema? (Choose two.)
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?