Snowflake SnowPro Advanced Data Engineer - SnowPro Advanced Data Engineer Exam
Page: 2 / 13
Total 65 questions
Question #6 (Topic: Exam A)
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?
Using a size 2XL virtual warehouse, this query took over an hour to complete.
What will improve the query performance the MOST?
A. Increase the size of the virtual warehouse.
B. Increase the number of clusters in the virtual warehouse.
C. Implement the search optimization service on the table.
D. Add a date column as a cluster key on the table.
Answer: D
Question #7 (Topic: Exam A)
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.)
Which sources are valid? (Choose three.)
A. Internal stage on GCP us-central1 (Iowa)
B. Internal stage on AWS eu-central-1 (Frankfurt)
C. External stage on GCP us-central1 (Iowa)
D. External stage in an Amazon S3 bucket on AWS eu-west-1 (Ireland)
E. External stage in an Amazon S3 bucket on AWS eu-central-1 (Frankfurt)
F. SSD attached to an Amazon EC2 instance on AWS eu-west-1 (Ireland)
Answer: BDE
Question #8 (Topic: Exam A)
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 command will meet these requirements?
A. CREATE DATABASE DEV
CLONE PROD
FAIL_SAFE = FALSE; B. CREATE DATABASE DEV
CLONE PROD; C. CREATE TRANSIENT DATABASE DEV
CLONE PROD; D. CREATE DATABASE DEV
CLONE PROD
DATA_RETENTION_TIME_IN DAYS = 0;
CLONE PROD
FAIL_SAFE = FALSE; B. CREATE DATABASE DEV
CLONE PROD; C. CREATE TRANSIENT DATABASE DEV
CLONE PROD; D. CREATE DATABASE DEV
CLONE PROD
DATA_RETENTION_TIME_IN DAYS = 0;
Answer: C
Question #9 (Topic: Exam A)
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?
A. 
B. 
C. 
D. 
B.
C.
D.
Answer: C
Question #10 (Topic: Exam A)
Which methods can be used to create a DataFrame object in Snowpark? (Choose three.)
A. session.jdbc_connection()
B. session.read.json()
C. session.table()
D. DataFrame.write()
E. session.builder()
F. session.sql()
Answer: BCF
