- All Exams Instant Download
Which action would provide optimal performance for the second SQL query?
A Snowflake user runs a complex SQL query on a dedicated virtual warehouse that reads a large amount of data from micro-partitions. The same user wants to run another query that uses the same data set. Which action would provide optimal performance for the second SQL query?A . Assign additional...
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...
Which queries will allow the user to view the historical data that was in the table before this query was executed?
MY_TABLE is a table that has not been updated or modified for several days. On 01 January 2021 at 07:01, a user executed a query to update this table. The query ID is '8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day. Which queries will allow the user to view...
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...
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 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...
In which scenario will use of an external table simplify a data pipeline?
In which scenario will use of an external table simplify a data pipeline?A . When accessing a Snowflake table from a relational databaseB . When accessing a Snowflake table from an external database within the same regionC . When continuously writing data from a Snowflake table to external storageD ....
For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?
For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?A . The account_level policy will override the user_level policy.B . The user_level policy will override the account_level policy.C . The user_level network policies will not be supported.D . A network policy error will...
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...
