- All Exams Instant Download
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...
Which design will meet these requirements?
A media company needs a data pipeline that will ingest customer review data into a Snowflake table, and apply some transformations. The company also needs to use Amazon Comprehend to do sentiment analysis and make the de-identified final data set available publicly for advertising companies who use different cloud providers...
To meet this requirement, the user’s role must have which privileges?
An Architect needs to allow a user to create a database from an inbound share. To meet this requirement, the user’s role must have which privileges? (Choose two.)A . IMPORT SHARE;B . IMPORT PRIVILEGES;C . CREATE DATABASE;D . CREATE SHARE;E . IMPORT DATABASE;View AnswerAnswer: C, E Explanation: According to the...
Which of the following are characteristics of how row access policies can be applied to external tables? (Choose three.)
Which of the following are characteristics of how row access policies can be applied to external tables? (Choose three.)A . An external table can be created with a row access policy, and the policy can be applied to the VALUE column.B . A row access policy can be applied to...
Assuming MY_WH is set to auto_suspend C 60 and used exclusively for this task, which statement is true?
The following DDL command was used to create a task based on a stream: Assuming MY_WH is set to auto_suspend C 60 and used exclusively for this task, which statement is true?A . The warehouse MY_WH will be made active every five minutes to check the stream.B . The warehouse...
Which actions can the company take with the inbound share?
A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines. Which actions can the company take with the inbound share? (Choose two.)A . Clone a table from a share.B . Grant modify...
When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP() what will occur?
When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP() what will occur?A . All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.B . Any rows...
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...
Which Snowflake feature can the Architect use to accomplish this?
An Architect would like to save quarter-end financial results for the previous six years. Which Snowflake feature can the Architect use to accomplish this?A . Search optimization serviceB . Materialized viewC . Time TravelD . Zero-copy cloningE . Secure viewsView AnswerAnswer: D Explanation: Zero-copy cloning is a Snowflake feature that...
A user can change object parameters using which of the following roles?
A user can change object parameters using which of the following roles?A . ACCOUNTADMIN, SECURITYADMINB . SYSADMIN, SECURITYADMINC . ACCOUNTADMIN, USER with PRIVILEGED . SECURITYADMIN, USER with PRIVILEGEView AnswerAnswer: C Explanation: According to the Snowflake documentation, object parameters are parameters that can be set on individual objects such as databases,...
