Crack4sure Logo
3 Months Free Update
3 Months Free Update
3 Months Free Update
Which of the following objects can be directly restored using the UNDROP command? (Choose two.)
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?
What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?
Network policies can be applied to which of the following Snowflake objects? (Choose two.)
True or False: It is possible to load data into Snowflake without creating a named File Format object.
True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
Which feature is only available in the Enterprise or higher editions of Snowflake?
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?
True or False: Snowflake charges a premium for storing semi-structured data.
True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.
Which command is used to unload data from a Snowflake table into a file in a stage?
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)
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.
A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?
User-level network policies can be created by which of the following roles? (Select TWO).
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
What is the default File Format used in the COPY command if one is not specified?
What feature can be used to reorganize a very large table on one or more columns?
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
Where would a Snowflake user find information about query activity from 90 days ago?
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
Which of the following statements are true of Snowflake releases: (Choose two.)
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.
Which of the following terms best describes Snowflake’s database architecture?
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
Which of the following statements would be used to export/unload data from Snowflake?
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.
True or False: An active warehouse is required to run a COPY INTO statement.
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.
For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?
A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)
What privilege should a user be granted to change permissions for new objects in a managed access schema?
When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)
What is the minimum Snowflake edition required to use Dynamic Data Masking?
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),
Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?
TESTED 14 Sep 2025