Free Snowflake DEA-C01 Exam Questions
Try our Free Demo Practice Tests for Comprehensive DEA-C01 Exam Preparation
-
Snowflake DEA-C01 Exam Questions
-
Provided By: Snowflake
- Exam: SnowPro Advanced Data Engineer Certification
- Certification: SnowPro Certification
-
Total Questions: 240
-
Updated On: Nov 19, 2024
-
Rated: 4.9 |
-
Online Users: 480
-
Question 1
-
When using the CURRENT_ROLE and CURRENT_USER functions with secure views that will be shared to
other Snowflake accounts, Snowflake returns a NULL value for these functions?
Answer: B
-
When using the CURRENT_ROLE and CURRENT_USER functions with secure views that will be shared to
other Snowflake accounts, Snowflake returns a NULL value for these functions?
-
Question 2
-
You are asked to find out the average number of queries run on an hourly basis to better understand query activity. Which of teh system tables will you use to create your query to get this information?
Answer: A
-
You are asked to find out the average number of queries run on an hourly basis to better understand query activity. Which of teh system tables will you use to create your query to get this information?
-
Question 3
-
Which of the below techniques leverages performance efficiencies by enabling large and complex Spark logical plans (in their entirety or in parts) to be processed in Snowflake, thus using Snowflake to do most of the actual work.
Answer: A
-
Which of the below techniques leverages performance efficiencies by enabling large and complex Spark logical plans (in their entirety or in parts) to be processed in Snowflake, thus using Snowflake to do most of the actual work.
-
Question 4
-
Which of the below transformations are supported by Snowflake while loading a table using the COPY statement?
Answer: A,C,D
-
Which of the below transformations are supported by Snowflake while loading a table using the COPY statement?
-
Question 5
-
To troubleshoot data load failure in one of your Copy Statement, Data Engineer have Executed a COPY
statement with the VALIDATION_MODE copy option set to RETURN_ALL_ERRORS with reference to the
set of files he had attempted to load. Which below function can facilitate analysis of the problematic records
on top of the Results produced? [Select 2]
Answer: A,B
-
To troubleshoot data load failure in one of your Copy Statement, Data Engineer have Executed a COPY
statement with the VALIDATION_MODE copy option set to RETURN_ALL_ERRORS with reference to the
set of files he had attempted to load. Which below function can facilitate analysis of the problematic records
on top of the Results produced? [Select 2]