- All Exams Instant Download
Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?
Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?A . External table B. Materialized view C. Search optimization D. Result cacheView AnswerAnswer: B
Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)
Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)A . They can include ORDER BY clauses. B. They cannot include nested subqueries. C. They can include context functions, such as CURRENT_TIME(). D. They can support MIN and MAX aggregates. E. They can support inner joins,...
What is required to allow data sharing between these two companies?
Company A would like to share data in Snowflake with Company B. Company B is not on the same cloud platform as Company A. What is required to allow data sharing between these two companies? A. Create a pipeline to write shared data to a cloud storage location in the...
At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?
At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?A . Global B. Database C. Schema D. TableView AnswerAnswer: D
To convert JSON null value to SQL null value, you will use
To convert JSON null value to SQL null value, you will useA . STRIP_NULL_VALUE B. IS_NULL_VALUE C. NULL_IFView AnswerAnswer: A Explanation: STRIP_NULL_VALUE Converts a JSON “null” value to a SQL NULL value. All other variant values are passed unchanged. Please remember this is semi structured data function and is different...
How do you validate the data that is unloaded using COPY INTO command
How do you validate the data that is unloaded using COPY INTO commandA . After unloading, load the data into a relational table and validate the rows B. Load the data into a CSV file to validate the rows C. Use validation_mode='RETURN_ROWS'; with COPY commandView AnswerAnswer: C Explanation: Validating Data...
Which of the following commands does the Architect need to run for USER1 to find the tables using the Principle of Least Privilege?
An Architect entered the following commands in sequence: USER1 cannot find the table. Which of the following commands does the Architect need to run for USER1 to find the tables using the Principle of Least Privilege? (Choose two.)A . GRANT ROLE PUBLIC TO ROLE INTERN; B. GRANT USAGE ON DATABASE...
Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)
Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)A . Changing the name of the organization B. Creating an account C. Viewing a list of organization accounts D. Changing the name of an account E. Deleting an account F. Enabling the replication of a databaseView AnswerAnswer: B,D,E
Which best practice recommendations will meet data protection and compliance requirements?
A healthcare company is deploying a Snowflake account that may include Personal Health Information (PHI). The company must ensure compliance with all relevant privacy standards. Which best practice recommendations will meet data protection and compliance requirements? (Choose three.)A . Use, at minimum, the Business Critical edition of Snowflake. B. Create...
Which is the LEAST complex approach to use to populate the QA account with the Production account’s data and database objects on a nightly basis?
An Architect has chosen to separate their Snowflake Production and QA environments using two separate Snowflake accounts. The QA account is intended to run and test changes on data and database objects before pushing those changes to the Production account. It is a requirement that all database objects and data...
