Pass the SnowPro Advanced Data Engineer Certification Exam with DumpsBase DEA-C01 Dumps

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

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

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

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

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

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

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

8. A stream contains table data

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

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

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

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

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

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

What will be the clustering depth of the table?

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

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

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

18. 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;

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

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

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

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

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

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

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

26. Which snowflake parameter limits the number of iterations

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

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

29. Which of the below statements are true?

30. Bytes spilled to remote storage 8.16 GB

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

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

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

33. ;

call sp1();

SELECT * FROM EMPLOYEE ORDER BY ID;

34. from employee where role = current_role();

35. select

36. Snowpipe supports loading from both internal and external stage

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

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

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