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...

February 12, 2024 No Comments READ MORE +

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...

February 11, 2024 No Comments READ MORE +

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...

February 11, 2024 No Comments READ MORE +

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...

February 11, 2024 No Comments READ MORE +

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...

February 10, 2024 No Comments READ MORE +

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...

February 9, 2024 No Comments READ MORE +

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...

February 9, 2024 No Comments READ MORE +

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 ....

February 8, 2024 No Comments READ MORE +

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...

February 8, 2024 No Comments READ MORE +

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...

February 8, 2024 No Comments READ MORE +