Which command is used to unload data from a Snowflake table into a file in a stage?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
What happens when a cloned table is replicated to a secondary database? (Select TWO)
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?
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
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 account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
Which of the following are best practices for loading data into Snowflake? (Choose three.)
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
What is the MINIMUM permission needed to access a file URL from an external stage?
What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?
When unloading data, which file format preserves the data values for floating-point number columns?
When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?
Which function should be used to insert JSON format string data inot a VARIANT field?
Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?
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?
Which command should be used to unload all the rows from a table into one or more files in a named stage?
Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?
The effects of query pruning can be observed by evaluating which statistics? (Select TWO).
Which command can be used to list all the file formats for which a user has access privileges?
What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?
Which file function generates a SnowFlake-hosted URL that must be authenticated when used?
Which role has the ability to create a share from a shared database by default?
What is the only supported character set for loading and unloading data from all supported file formats?
How can a user get the MOST detailed information about individual table storage details in Snowflake?
Why would a Snowflake user decide to use a materialized view instead of a regular view?
A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?
Which SQL command can be used to verify the privileges that are granted to a role?
A Snowflake user wants to temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY.
What should they do?
Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).
What will happen if a Snowflake user increases the size of a suspended virtual warehouse?
By default, how long is the standard retention period for Time Travel across all Snowflake accounts?
What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?
A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?
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?
Which data types can be used in Snowflake to store semi-structured data? (Select TWO)
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?
What tasks can an account administrator perform in the Data Exchange? (Select TWO).
Which Snowflake database object can be used to track data changes made to table data?
Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).
What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?
Which Snowflake role can manage any object grant globally, including modifying and revoking grants?
Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).
How should clustering be used to optimize the performance of queries that run on a very large table?
How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?
When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
A user with which privileges can create or manage other users in a Snowflake account? (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 ;?
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 Snowflake feature allows administrators to identify unused data that may be archived or deleted?
A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.
Which CREATE object statement will automatically assign the TABLE_A tag to a target object?
A user wants to access files stored in a stage without authenticating into Snowflake. Which type of URL should be used?
What will prevent unauthorized access to a Snowflake account from an unknown source?
What privilege should a user be granted to change permissions for new objects in a managed access schema?
What are key characteristics of virtual warehouses in Snowflake? (Select TWO).
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 does Snowflake recommend regarding database object ownership? (Select TWO).
Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)
A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?
A Snowflake user has been granted the create data EXCHANGE listing privilege with their role.
Which tasks can this user now perform on the Data Exchange? (Select TWO).
Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?
Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?
How does Snowflake handle the bulk unloading of data into single or multiple files?
What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).
A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables. Which set operator should be used?
How can a data provider ensure that a data consumer is going to have access to the required objects?
Which type of join will list a I rows in the specified table, even if those rows have no match in the other table?
How often are the Account and Table master keys automatically rotated by Snowflake?
For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?
Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)
A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?
Which command is used to unload files from an internal or external stage to a local file system?
What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
Which user object property requires contacting Snowflake Support in order to set a value for it?
Which of the following SQL statements will list the version of the drivers currently being used?
Which actions can be performed using a resource monitor in Snowflake? (Select TWO).
A Snowflake table that is loaded using a Kafka connector has a schema consisting of which two variant columns? (Select TWO).
Which Snowflake table type persists until it is explicitly dropped. is available for all users with relevant privileges (across sessions). and has no Fail-safe period?
A JSON document is stored in the source_colum of type VARIANT. The document has an array called elements. The array contains the name key that has a string value How can a Snowflake user extract the name from the first element?
Which activities are managed by Slowflake's Cloud Services layer? (Select TWO).
A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does not change frequently.
What should the user do?
Which roles can make grant decisions to objects within a managed access schema? (Select TWO)
How many credits does a size 3X-Large virtual warehouse consume if it runs continuously for 2 hours?
Given the statement template below, which database objects can be added to a share?(Select TWO).
GRANT
Use of which file function allows a user to share unstructured data from an internal stage with an external reporting tool that does not have access to Snowflake">
In Snowflake's data security framework, how does column-level security contribute to the protection of sensitive information? (Select TWO).
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
Who can activate a network policy for users in a Snowflake account? (Select TWO)
Which semi-structured file format is a compressed, efficient, columnar data representation?
What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?
How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''
Which table function should be used to view details on a Directed Acyclic Graphic (DAG) run that is presently scheduled or is executing?
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 is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?
What is the purpose of the use of the VALIDATE command?
To view any queries that encountered an error
To verify that a SELECT query will run without error
To prevent a put statement from running if an error occurs
To see all errors from a previously run COPY INTO
