dumpspedia logo
Which of the following significantly improves the performance of selective point lookup queries on a table?
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
Which of the following statements apply to Snowflake in terms of security? (Choose two.)
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?
Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?
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?
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?
What is the default file size when unloading data from Snowflake using the COPY command?
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
Which Snowflake role can manage any object grant globally, including modifying and revoking grants?
What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?
The following JSON is stored in a VARIANT column called src of the CAR_SALES table:
A user needs to extract the dealership information from the JSON.
How can this be accomplished?
Which Snowflake layer is always leveraged when accessing a query from the result cache?
The Snowflake Search Optimization Services supports improved performance of which kind of query?
Which commands are restricted in owner's rights stored procedures? (Select TWO).
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?
What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?
What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?
When using the ALLOW_CLI£NT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
What will happen if a Snowflake user increases the size of a suspended virtual warehouse?
Which function should be used to insert JSON format string data inot a VARIANT field?
When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
Where would a Snowflake user find information about query activity from 90 days ago?
What happens when a cloned table is replicated to a secondary database? (Select TWO)
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (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)
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?
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)
When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
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 user wants to access files stored in a stage without authenticating into Snowflake. Which type of URL should be used?
Which data types can be used in Snowflake to store semi-structured data? (Select TWO)
Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?
Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).
What tasks can an account administrator perform in the Data Exchange? (Select TWO).
Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).
What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?
Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
CREATE STAGE
COPY INTO
