A Data Engineer is investigating a query that is taking a long time to return. The Query Profile shows the following: What step should the Engineer take to increase the query performance?

How can the following relational data be transformed into semi-structured data using the LEAST amount of operational overhead?

A Data Engineer executes a complex query and wants to make use of Snowflake’s query results caching capabilities to reuse the results. Which conditions must be met? (Choose three.)

A Data Engineer needs to load JSON output from some software into Snowflake using Snowpipe. Which recommendations apply to this scenario? (Choose three.)

Given the table SALES which has a clustering key of column CLOSED_DATE, which table function will return the average clustering depth for the SALES_REPRESENTATIVE column for the North American region?

A large table with 200 columns contains two years of historical data. When queried, the table is filtered on a single day. Below is the Query Profile: Using a size 2XL virtual warehouse, this query took over an hour to complete. What will improve the query performance the MOST?

A Data Engineer is working on a Snowflake deployment in AWS eu-west-1 (Ireland). The Engineer is planning to load data from staged files into target tables using the COPY INTO command. Which sources are valid? (Choose three.)

A Data Engineer wants to create a new development database (DEV) as a clone of the permanent production database (PROD). There is a requirement to disable Fail-safe for all tables. Which command will meet these requirements?

Which query will show a list of the 20 most recent executions of a specified task, MYTASK, that have been scheduled within the last hour that have ended or are still running?

Which methods can be used to create a DataFrame object in Snowpark? (Choose three.)