Earning SnowPro Advanced Data Engineer Certification by Passing DEA-C01 Exam with Actual DEA-C01 Exam Questions

Eleanor2024-10-14T15:10:35+00:00

By Eleanor Snowflake, SnowPro Advanced Data Engineer

IT professionals can prove that they have advanced knowledge and skills used to apply comprehensive data engineering principles using Snowflake if they complete the SnowPro Advanced Data Engineer Certification. We will discuss how you can prepare and pass the DEA-C01 exam to earn the SnowPro Advanced Data Engineer Certification. We provide an overview of the ITPrepare DEA-C01 exam dumps questions, which are the most up-to-date, comprehensive set of questions to help prepare you for the DEA-C01 exam.

Before downloading the DEA-C01 exam questions pdf file, you can read the DEA-C01 free demo first:

Page 1 of 4

1. In which of the below use cases does Snowflake applies data egress charge?

Unloading data from Snowflake

Database replication

External functions

Loading data into Snowflake

2. Let's say you have a schema name MY_SCHEMA. This schema contains two permanent tables as shown below

CREATE TABLE MY_TABLE_A (C1 INT)

DATA_RETENTION_TIME_IN_DAYS = 10;

CREATE TABLE MY_TABLE_B (C1 INT);

What will be the impact of running the following command?

ALTER SCHEMA MY_SCHEMA SET DATA_RETENTION_TIME_IN_DAYS = 20;

Data retention time cannot be set at SCHEMA level, hence it will fail

The retention time on MY_TABLE_A does not change; MY_TABLE_B will be set to 20 days

The retention time on both the tables will be set to 20 days

The retention time will not change for both tables

3. Which of the below transformations are supported by Snowflake while loading a table using the COPY statement?

Column reordering

Column renaming

Column omission

Casts

Truncating text strings that exceed the target column length

4. Which system table will you use to get the total credit consumption over a specific time period?

WAREHOUSE_METERING_HISTORY

WAREHOUSE_CREDIT_USAGE_HISTORY

WAREHOUSE_USAGE_HISTORY

5. The snowflake connector for Python uses a temporary directory to store data for loading and unloading(PUT,GET) as well as other types of temporary data.

If the temporary directory is not explicitly set, what does the connector use?

System's default temporary directory(i.e; /tmp, c:TEMP)

System creates a temporary directory

The PUT and GET commands will fail

6. Snowflake charges a per-byte fee when users transfer data from your snowflake account into cloud storages in another region on the same cloud platform or into cloud storage in another cloud platform

TRUE

FALSE

7. Each micro partition contains between 50 mb and 500 MB of uncompressed data

TRUE

FALSE

8. Bytes spilled to remote storage 8.16 GB

Which of the below techniques will you be using to decrease remote spilling?

Review the query for optimization, especially if it is a new query

Reduce the amount of data processed by trying to improve partition pruning

Decrease the number of parallel queries running in the warehouse

Try to split the processing into several steps. For example by replacing CTEs with temporary tables

Use a larger warehouse

Use a multi cluster warehouse

9. Which of the below function can a task use to see whether a stream contains change data for a table?

SYSTEM$STREAM_HAS_DATA

SYSTEM#STREAM_HAS_DATA

SYSTEM_HAS_STREAM_DATA

10. ;

call sp1();

SELECT * FROM EMPLOYEE ORDER BY ID;

1 MOHAN 2 RON

1 MOHAN 2 RON 3 RANJAN

1 MOHAN 3 RANJAN

1 MOHAN

Page 2 of 4

11. 1.Which are the valid options for the validation_mode parameter in the COPY command

RETURN_<n>_ROWS

RETURN_ERROR

RETURN_ERRORS

RETURN_ALL_ERRORS

12. Which of the below statements are true?

ACCOUNT USAGE includes dropped objects but INFORMATION SCHEMA does not

INFORMATION SCHEMA includes dropped objects but ACCOUNT USAGE does not

BOTH includes dropped object

BOTH does not include dropped object

13. Which of the below SQLs will you run to validate any loads of the pipe within the last hour?

select * from table(validate_pipe_load( pipe_name=>'data_engineer_pipe', start_time=>dateadd(hour, -1, current_timestamp())));

select * from table(pipe_load_status( pipe_name=>'data_engineer_pipe', start_time=>dateadd(hour, -1, current_timestamp())));

select * from table(check_pipe_load( pipe_name=>'data_engineer_pipe', start_time=>dateadd(hour, -1, current_timestamp())));

14. Snowpipe supports loading from both internal and external stage

FALSE

TRUE

15. Snowflake does not prune micro-partitions based on a predicate with a subquery

TRUE

FALSE

16. Time travel cannot be disabled for an account, but it can be disabled for individual databases, schemas and tables by specifying DATA_RETENTION_TIME_IN_DAYS with a value of 0 for the object

TRUE

FALSE

17. Which snowflake parameter limits the number of iterations

MAX_RECURSIONS

MAX_ITERATIONS

MAX_LOOP

18. Which one of the below is true about clustering depth?

The smaller the average depth, the better clustered the table is with respect to the specified columns

The larger the average depth, the better clustered the table is with respect to the specified columns

The smaller the maximum depth, the better clustered the table is with respect to the specified columns

19. An existing clustering key is copied in which of the below scenarios

CREATE TABL

..CLONE

CREATE TABL

..LIKE

CREATE TABL

..AS SELECT

20. Which of the below functions are recommended to be used to understand the clustering ratio of a table?

SYSTEM$CLUSTERING_RATIO

SYSTEM$CLUSTERING_DEPTH

SYSTEM$CLUSTERING_INFORMATION

Page 3 of 4

21. FORMAT_NAME and TYPE are mutually exclusive in the COPY command.

TRUE

FALSE

22. A stream contains table data

True

False

23. For how many days does the COPY_HISTORY retain data loading history

24. You have an employee table and you want to view the explain results in a tabular form for the below query

SELECT * FROM EMPLOYEE;

Which of the options below can you use to do the same?

SELECT * FROM TABLE( EXPLAIN_JSON( SYSTEM$EXPLAIN_PLAN_JSON( 'SELECT * FROM EMPLOYEES') ) );

EXPLAIN USING TABULAR SELECT * FROM EMPLOYEES;

EXPLAIN AND CONVERT TO TABULAR SELECT * FROM EMPLOYEES;

25. from employee where role = current_role();

Only users with the desired role will be able to retrieve results from the view

Only users with the correct role assigned and SYSADMIN will be able to retrieve the results from the view

The operation will error out since the function used is a non-deterministic one.

26. Which of the below statements are true for API integration object?

Only Snowflake users who have the ACCOUNTADMIN role or who have a role with the global CREATE INTEGRATION privilege can execute CREATE API INTEGRATIO

Only Snowflake roles with OWNERSHIP or USAGE privileges on the API integration can use the API integration directly (e.g. by creating an external function that specifies that API integration).

An API integration object is tied to a specific cloud platform account and role within that account, but not to a specific HTTPS proxy UR

You can create more than one instance of an HTTPS proxy service in a cloud provider account, and you can use the same API integration to authenticate to multiple proxy services in that account.

Your Snowflake account can have multiple API integration objects, for example, for different cloud platform accounts.

Multiple external functions can use the same API integration object, and thus the same HTTPS proxy service.

ALL OF THE ABOVE

27. 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?

QUERY_HISTORY

QUERY_LOG

QUERY_MONITOR

28. select

The operation will be successful and the materialized view will be created

Materialized view always needs to be a secure view, hence this will fail

Aggregate functions used in complex expressions can only be used in the outer-most level of a query, not in a subquery or an in-line view, hence this operation will fail.

29. It is a best practice to avoid binding data using Python's formatting function due to the risk of SQL injection.

TRUE

FALSE

30. Which of the below mentioned compression techniques are applicable for CSV file format?

GZIP

BZ2

BROTLI

ZSTD

DEFLATE

RAW_DEFLATE

LZIP

Page 4 of 4

31. Which of the below joins are supported by Snowflake?

INNER JOIN

OUTER JOIN

CROSS JOIN

NATURAL JOIN

SIDE JOIN

32. Putting a higher cardinality column before a lower cardinality column will generally reduce the effectiveness of clustering on the later column

TRUE

FALSE

33. You have just created a table in snowflake. There are now rows in the table.

What will be the clustering depth of the table?

34. If an external function is secure, the URL, the HTTP headers, and the context headers are hidden from all users who are not owners of the function.

TRUE

FALSE

35. Which of the below are benefits of micro partitioning?

Micro partitions are derived automatically

Micro partitions need to be maintained by users

Micro partitions enables extremely efficient DML and fine-grained pruning for faster queries

Columns are stored independently within micro-partitions

Columns are compressed individually within micro-partitions

36. In order to improve query perfromance, you can bypass data conversions from the Snowflake internal data type to the native Python data type.

Which class in the snowflake.connector.converter_null module do you use for this feature?

SnowflakeNoConverterToPython

PythonNoConverterToSnowflake

ByPassDataConversion

37. Which of the below steps are required to create streams on shared tables?

Enable change tracking

Extend the data retention period for the table

Enable search virtualization on the table

38. Which of the below standard API objects are supported by the Snowflake connector for Python

Connection

Cursor

SnowflakeConnection

SnowflakeCursor

39. CREATE OR REPLACE TABLE TIME_TRAVEL_SCHEMA.TIME_TRAVEL_TABLE (ID NUMBER) DATA_RETENTION_TIME_IN_DAYS =20;

Later you dropped the schema. In this scenario what data retention value will be honored for the table, if we need to retrieve the table data

Earning SnowPro Advanced Data Engineer Certification by Passing DEA-C01 Exam with Actual DEA-C01 Exam Questions

Earning SnowPro Advanced Data Engineer Certification by Passing DEA-C01 Exam with Actual DEA-C01 Exam Questions

Before downloading the DEA-C01 exam questions pdf file, you can read the DEA-C01 free demo first:

Share this post

Author

Related Posts