- All Exams Instant Download
According to best practices, how should these requirements be met?
A Snowflake Administrator needs to set up Time Travel for a presentation area that includes facts and dimensions tables, and receives a lot of meaningless and erroneous loT data. Time Travel is being used as a component of the company's data quality process in which the ingestion pipeline should revert...
What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?
What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?A . Any role with GRANT USAGE on SECURITY INTEGRATIONB . ACCOUNTADMIN and SYSADMINC . ACCOUNTADMIN and SECURITYADMIND . ACCOUNTADMIN onlyView AnswerAnswer: D Explanation: According to the Using OAuth 2.0 with Snowflake -...
How can the Administrator protect the sensitive information, while maintaining the usability of the data?
An Administrator has been asked to support the company's application team need to build a loyalty program for its customers. The customer table contains Personal Identifiable Information (PII), and the application team's role is DEVELOPER. CREATE TABLE customer_data ( customer_first_name string, customer_last_name string, customer_address string, customer_email string, ... some other...
What are characteristics of Dynamic Data Masking? (Select TWO).
What are characteristics of Dynamic Data Masking? (Select TWO).A . A masking policy that is currently set on a table can be dropped.B . A single masking policy can be applied to columns in different tables.C . A masking policy can be applied to the VALUE column of an external...
According to best practices, how should these requirements be met?
A Snowflake Administrator needs to set up Time Travel for a presentation area that includes facts and dimensions tables, and receives a lot of meaningless and erroneous loT data. Time Travel is being used as a component of the company's data quality process in which the ingestion pipeline should revert...
What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Select TWO).
What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Select TWO). A. SYSADMIN B. SECURITYADMIN C. ACCOUNTADMIN D. IMPORT SHARE and CREATE DATABASE E. IMPORT PRIVILEGES and SHARED DATABASEView AnswerAnswer: CD Explanation: According to the Accessing a Data Exchange documentation,...
INSERT INTO VWH META SELECT CURRENT TIMESTAMP (), * FROM TABLE (RESULT_SCAN (SELECT LAST QUERY ID(-1)));
INSERT INTO VWH META SELECT CURRENT TIMESTAMP (), * FROM TABLE (RESULT_SCAN (SELECT LAST QUERY ID(-1)));View AnswerAnswer: C Explanation: According to the Using Persisted Query Results documentation, the RESULT_SCAN function allows you to query the result set of a previous command as if it were a table. The LAST_QUERY_ID function...
What can the Snowflake Administrator do to optimize the use of persisted query results whenever possible?
An organization's sales team leverages this Snowflake query a few times a day: SELECT CUSTOMER ID, CUSTOMER_NAME, ADDRESS, PHONE NO FROM CUSTOMERS WHERE LAST UPDATED BETWEEN TO_DATE (CURRENT_TIMESTAMP) AND (TO_DATE (CURRENT_TIMESTAMP) -7); What can the Snowflake Administrator do to optimize the use of persisted query results whenever possible?A . Wrap...
How can the Administrator reduce the costs, while minimizing the overall load times, for migrating data warehouse history?
A Snowflake customer is experiencing higher costs than anticipated while migrating their data warehouse workloads from on-premises to Snowflake. The migration workloads have been deployed on a single warehouse and are characterized by a large number of small INSERTs rather than bulk loading of large extracts. That single warehouse has...
Why is this occurring?
A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) that has been clustered by the STORE_ID column (varchar (50)). The vast majority of analyses on this table are grouped by STORE_ID to look at store performance. There are 1000 stores operated by the retailer but most sales come from...
