Crack4sure Logo
3 Months Free Update
3 Months Free Update
3 Months Free Update
When using the ALLOW_CLI£NT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).
For Directory tables, what stage allows for automatic refreshing of metadata?
How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?
What kind of value does a User-Defined Function (UDF) return? (Select TWO).
Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?
A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?
Which privilege is required to use the search optimization service in Snowflake?
User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history.
What will happen if User2 tries to access the query history?
While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).
When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?
Which function is used to convert rows in a relational table to a single VARIANT column?
What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?
Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?
What is the MINIMUM permission needed to access a file URL from an external stage?
What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?
Which command can be used to list all the file formats for which a user has access privileges?
What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).
Which role has the ability to create a share from a shared database by default?
By default, how long is the standard retention period for Time Travel across all Snowflake accounts?
Which common query problems are identified by the Query Profile? (Select TWO.)
How can a user MINIMIZE Continuous Data Protection costs when using large, high-churn, dimension tables?
A Snowflake table that is loaded using a Kafka connector has a schema consisting of which two variant columns? (Select TWO).
Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?
Which command should be used to assign a key to a Snowflake user who needs to connect using key pair authentication?
Which virtual warehouse consideration can help lower compute resource credit consumption?
How does the search optimization service help Snowflake users improve query performance?
When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).
What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
STION NO: 17
How can a data provider validate that a secure view is configured to display only the data the provider wishes to expose?
Which privilege is required on a virtual warehouse to abort any existing executing queries?
What is the MINIMUM size requirement when creating a Snowpark-optimized virtual warehouse?
Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?
What happens when a table or schema with a standard retention period is dropped?
Which statistics on a Query Profile reflect the efficiency of the query pruning? (Select TWO).
Which semi-structured file format is a compressed, efficient, columnar data representation?
Which table function should be used to view details on a Directed Acyclic Graphic (DAG) run that is presently scheduled or is executing?
Which key access control concept does Snowflake descibe as a defined level of access to an object?
Which command can be used to unload data into an external named stage in Snowflake?
How can staged files be removed during data loading once the files have loaded successfully?
While unloading data into a stage, how can the user ensure that the output will be a single file?
Which Snowflake table type is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end of the session?
What are the main differences between the account usage views and the information schema views? (Select TWO).
When working with table MY_TABLE that contains 10 rows, which sampling query will always return exactly 5 rows?
What virtual warehouse configuration should be used when processing a large number of complex queries?
What object does Snowflake recommend using when planning to unload similarly-formatted data on a regular basis?
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).
For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?
What is used to diagnose and troubleshoot network connections to Snowflake?
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?
If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?
The VALIDATE table function has which parameter as an input argument for a Snowflake user?
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
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 describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
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?
What is the minimum Snowflake edition required to create a materialized view?
What happens when an external or an internal stage is dropped? (Select TWO).
What Snowflake role must be granted for a user to create and manage accounts?
Which command is used to start configuring Snowflake for Single Sign-On (SSO)?
Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?
Which Snowflake role can manage any object grant globally, including modifying and revoking grants?
What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?
What feature can be used to reorganize a very large table on one or more columns?
Which command is used to unload data from a Snowflake table into a file in a stage?
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
How would you determine the size of the virtual warehouse used for a task?
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
What happens when a Snowflake user changes the data retention period at the schema level?
Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?
A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.
How can this be achieved?
What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?
What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?
Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?
Which of the following can be used when unloading data from Snowflake? (Choose two.)
Which task privilege does a Snowflake role need in order to suspend or resume a task?
If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?
What column type does a Kafka connector store formatted information in a single column?
What file formats does Snowflake support for loading semi-structured data? (Choose three.)
What is the difference between a stored procedure and a User-Defined Function (UDF)?
For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
What does Snowflake recommend regarding database object ownership? (Select TWO).
If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
Which feature allows a user the ability to control the organization of data in a micro-partition?
Which pages are included in the Activity area of Snowsight? (Select TWO).
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?
Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?
What can a Snowflake user do with the information included in the details section of a Query Profile?
What will prevent unauthorized access to a Snowflake account from an unknown source?
What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?
What transformations are supported when loading data into a table using the COPY INTO <table> command? (Select TWO).
How can performance be optimized for a query that returns a small amount of data from a very large base table?
What metadata does Snowflake store for rows in micro-partitions? (Select TWO).
Which Snowflake database object can be used to track data changes made to table data?
Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
What are the least privileges needed to view and modify resource monitors? (Select TWO).
Which kind of Snowflake table stores file-level metadata for each file in a stage?
What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?
Which of the following objects can be shared through secure data sharing?
Which metadata table will store the storage utilization information even for dropped tables?
Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?
Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).
A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1 ;?
A Snowflake account has activated federated authentication.
What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?
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?
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?
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
Which of the following statements describe features of Snowflake data caching? (Choose two.)
What actions will prevent leveraging of the ResultSet cache? (Choose two.)
Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
True or False: Snowpipe via REST API can only reference External Stages as source.
Which Snowflake layer is always leveraged when accessing a query from the result cache?
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?
Which of the following are best practices for loading data into Snowflake? (Choose three.)
What is the minimum Snowflake edition required to use Dynamic Data Masking?
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?
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
Which data types are supported by Snowflake when using semi-structured data? (Choose two.)
What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (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 features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)
A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
Which services does the Snowflake Cloud Services layer manage? (Choose two.)
What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?
Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?
Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
TESTED 12 Sep 2025