Dumpsbuddy logo
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
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 of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
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?
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
Which feature is only available in the Enterprise or higher editions of Snowflake?
What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)
True or False: Snowpipe via REST API can only reference External Stages as source.
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
Which file formats are supported for unloading data from Snowflake? (Choose two.)
Where can a user find and review the failed logins of a specific user for the past 30 days?
Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?
What impacts the credit consumption of maintaining a materialized view? (Choose two.)
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.
Which Snowflake feature will support this?
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.
What are the three things customers want most from their enterprise data warehouse solution?
Choose 3 answers
True or False: The COPY command must specify a File Format in order to execute.
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage?
(Choose all that apply.)
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: 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.
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?
What are the three layers that make up Snowflake’s architecture?
Choose 3 answer
TESTED 12 May 2024
