- All Exams Instant Download
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...
Following objects can be cloned in snowflake
Following objects can be cloned in snowflakeA . Permanent table B. Transient table C. Temporary table D. External tables E. Internal stagesView AnswerAnswer: A,B,C Explanation: For tables, Snowflake supports cloning permanent and transient tables; temporary tables can be cloned only to a temporary table or a transient table. For databases...
What are purposes for creating a storage integration? (Choose three.)
What are purposes for creating a storage integration? (Choose three.)A . Control access to Snowflake data using a master encryption key that is maintained in the cloud provider’s key management service. B. Store a generated identity and access management (IAM) entity for an external cloud provider regardless of the cloud...
Which Snowflake data modeling approach is designed for BI queries?
Which Snowflake data modeling approach is designed for BI queries?A . 3 NF B. Star schema C. Data Vault D. Snowflake schemaView AnswerAnswer: D
What is the most optimal solution that you will suggest to the business team?
You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the...
