- All Exams Instant Download
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...
If the user loads this column data into another column that does not have a masking policy, what will occur?
A user has the appropriate privilege to see unmasked data in a column. If the user loads this column data into another column that does not have a masking policy, what will occur?A . Unmasked data will be loaded in the new column. B. Masked data will be loaded into...
Assuming the syntax is correct, what is the cause of this error?
Consider the following COPY command which is loading data with CSV format into a Snowflake table from an internal stage through a data transformation query. This command results in the following error: SQL compilation error: invalid parameter 'validation_mode' Assuming the syntax is correct, what is the cause of this error?A...
The kafka connector creates one pipe for each partition in a Kafka topic.
The kafka connector creates one pipe for each partition in a Kafka topic.A . TRUE B. FALSEView AnswerAnswer: A Explanation: The connector creates one pipe for each partition in a Kafka topic. The format of the pipe name is: SNOWFLAKE_KAFKA_CONNECTOR_<connector_name>_<PIPE_table_name>_<partition_number> https://docs.snowflake.com/en/user-guide/kafka-connector-manage.html#dropping-pipes
