Snowflake SnowPro Advanced Data Engineer - SnowPro Advanced Data Engineer Exam
Page: 3 / 33
Total 162 questions
Question #11 (Topic: Exam A)
A new CUSTOMER table is created by a data pipeline in a Snowflake schema where MANAGED ACCESS is enabled.
Which roles can grant access to the CUSTOMER table? (Choose three.)
Which roles can grant access to the CUSTOMER table? (Choose three.)
A. The role that owns the schema
B. The role that owns the database
C. The role that owns the CUSTOMER table
D. The SYSADMIN role
E. The SECURITYADMIN role
F. The USERADMIN role with the MANAGE GRANTS privilege
Answer: AEF
Question #12 (Topic: Exam A)
What is the purpose of the BUILD_STAGE_FILE_URL function in Snowflake?
A. It generates an encrypted URL for accessing a file in a stage.
B. It generates a staged URL for accessing a file in a stage.
C. It generates a permanent URL for accessing files in a stage.
D. It generates a temporary URL for accessing a file in a stage.
Answer: C
Question #13 (Topic: Exam A)
The JSON below is stored in a VARIANT column named V in a table named jCustRaw:
Which query will return one row per team member (stored in the teamMembers array) along with all of the attributes of each team member?
Which query will return one row per team member (stored in the teamMembers array) along with all of the attributes of each team member?
A. 
B. 
C. 
D. 
B.
C.
D.
Answer: B
Question #14 (Topic: Exam A)
A company has an extensive script in Scala that transforms data by leveraging DataFrames. A Data Engineer needs to move these transformations to Snowpark.
What characteristics of data transformations in Snowpark should be considered to meet this requirement? (Choose two.)
What characteristics of data transformations in Snowpark should be considered to meet this requirement? (Choose two.)
A. It is possible to join multiple tables using DataFrames.
B. Snowpark operations are executed lazily on the server.
C. User-Defined Functions (UDFs) are not pushed down to Snowflake.
D. Snowpark requires a separate cluster outside of Snowflake for computations.
E. Columns in different DataFrames with the same name should be referred to with squared brackets.
Answer: AB
Question #15 (Topic: Exam A)
The following is returned from SYSTEM$CLUSTERING_INFORMATION() for a table named ORDERS with a DATE column named O_ORDERDATE:
What does the total_constant_partition_count value indicate about this table?
What does the total_constant_partition_count value indicate about this table?
A. The table is clustered very well on O_ORDERDATE, as there are 493 micro-partitions that could not be significantly improved by reclustering.
B. The table is not clustered well on O_ORDERDATE, as there are 493 micro-partitions where the range of values in that column overlap with every other micro-partition in the table.
C. The data in O_ORDERDATE does not change very often, as there are 493 micro-partitions containing rows where that column has not been modified since the row was created.
D. The data in O_ORDERDATE has a very low cardinality, as there are 493 micro-partitions where there is only a single distinct value in that column for all rows in the micro-partition.
Answer: A
