SnowPro Advanced Data Engineer Practice Test

Question 6

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?

1. Increase the size of the virtual warehouse.
2. Increase the number of clusters in the virtual warehouse.
3. Implement the search optimization service on the table.
4. Add a date column as a cluster key on the table.

Question 7

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

1. Internal stage on GCP us-central1 (Iowa)
2. Internal stage on AWS eu-central-1 (Frankfurt)
3. External stage on GCP us-central1 (Iowa)
4. External stage in an Amazon S3 bucket on AWS eu-west-1 (Ireland)
5. External stage in an Amazon S3 bucket on AWS eu-central-1 (Frankfurt)
6. SSD attached to an Amazon EC2 instance on AWS eu-west-1 (Ireland)

Question 8

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?

1. CREATE DATABASE DEV - CLONE PROD - FAIL_SAFE = FALSE;
2. CREATE DATABASE DEV - CLONE PROD;
3. CREATE TRANSIENT DATABASE DEV - CLONE PROD;
4. CREATE DATABASE DEV - CLONE PROD - DATA_RETENTION_TIME_IN DAYS = 0;

Question 9

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?

Question 10

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

1. session.jdbc_connection()
2. session.read.json()
3. session.table()
4. DataFrame.write()
5. session.builder()
6. session.sql()