Accurate Hot Selling DEA-C01 Exam Dumps 2023 Newly Released [Q14-Q30]

Rate this post

Accurate Hot Selling DEA-C01 Exam Dumps 2023 Newly Released

Get 100% Authentic Snowflake DEA-C01 Dumps with Correct Answers

Q14. Assuming that the session parameter USE_CACHED_RESULT is set to false, what are characteristics of Snowflake virtual warehouses in terms of the use of Snowpark?

Creating a DataFrame from a table will start a virtual warehouse

Creating a DataFrame from a staged file with the read () method will start a virtual warehouse

Transforming a DataFrame with methods like replace () will start a virtual warehouse –

Calling a Snowpark stored procedure to query the database with session, call () will start a virtual warehouse

Q15. Data Engineer decided to call the public REST endpoints to load data and retrieve load history re-ports. Which of the following REST endpoints and a Snowflake Information Schema table function for viewing your load history can be used by her? [Select All that apply]

REST endpoints: loadinsertReport or HistoryScan

Information Schema table function: COPY_HISTORY

Account Usage view:COPY_HISTORY

REST endpoints: insertReport or loadHistoryScan

Information Schema table function: LOAD_HISTORY

Q16. A Data Engineer enables a result cache at the session level with the following command:
ALTER SESSION SET USE CACHED RESULT = TRUE;
The Engineer then runs the following select query twice without delay:

The underlying table does not change between executions
What are the results of both runs?

The first and second run returned the same results because sample is deterministic

The first and second run returned the same results, because the specific SEEDvalue was provided.

The first and second run returned different results because the query is evaluated each time it is run.

The first and second run returned differentresults because the query uses *instead of an explicit column list

Q17. Which output is provided by both theSYSTEM$CLUSTERING_DEPTHfunction and theSYSTEM$CLUSTERING_INFORMATIONfunction?

average_depth

notes

average_overlaps

total_partition_count

Q18. Which connector creates the RECORD_CONTENT and RECORD_METADATA columns in the existing Snowflake table while connecting to Snowflake?

Python Connector

Spark Connector

Node.js connector

Kafka Connector

Q19. Which use case would be BEST suited for the search optimization service?

Analysts who need to perform aggregates over high cardinality columns

Business users who need fast response times using highly selective filters

Data Scientists who seek specific JOIN statements with large volumes of data

Data Engineers who create clustered tables with frequent reads against clustering keys

Q20. How Data Engineer can do Monitoring of Files which are Staged Internally during Continuous data pipelines loading process? [Select all that apply]

She Can Monitor the files using Metadata maintained by Snowflake i.e. file-name,last_modified date etc.

Snowflake retains historical data for COPY INTO commands executed within the pre-vious 14 days.

She can Monitor the status of each COPY INTO <table> command on the History tab page of the classic web interface.

She can use the DATA_LOAD_HISTORY Information Schema view to retrieve the history of data loaded into tables using the COPY INTO command.

She can use the DATA_VALIDATE function to validate the data files She have loaded and can retrieve any errors encountered during the load.

Q21. A secure function returns data coming through an inbound share
What will happen if a Data Engineer tries to assign usage privileges on this function to an outbound share?

An error will be returned because the Engineer cannot share data that has already been shared

An error will be returned because only views and secure stored procedures can be shared

An error will be returned because only secure functions can be shared with inbound shares

The Engineer will be able to share the secure function with other accounts

Q22. Which are the Cloud Platforms that Support Calling an External Function?

GCP

AWS & AZURE

AWS only

AWS,GCP,AZURE

Q23. Which callback function is required within a JavaScript User-Defined Function (UDF) for it to execute successfully?

initialize ()

processRow ()

handler

finalize ()

Q24. Assuming a Data Engineer has all appropriate privileges and context which statements would be used to assess whether the User-Defined Function (UDF), MTBATA3ASZ. SALES .REVENUE_BY_REGION, exists and is secure? (Select TWO)

SHOW DS2R FUNCTIONS LIKE ‘REVEX’^BYJIESION’ IN SCHEMA SALES;

SELECT IS_SECURE FROM SNOWFLAKE. INFCRXATION_SCKZMA. FUNCTIONS WHERE FUNCTI0N_3CHEMA = ‘SALES’ AND FUNCTI CN_NAXE = *ftEVEXUE_BY_RKXQH4;

SELECT IS_SEC”JRE FROM INFOR>LVTICN_SCHEMA. FUNCTIONS WHERE
FUNCTION_SCHEMA = ‘SALES1 AND FUNGTZON_NAME = ‘ REVENUE_BY_REGION’;

SHOW EXTERNAL FUNCTIONS LIKE ‘REVENUE_BY_REGION’IB SCHEMA SALES;

SHOW SECURE FUNCTIONS LIKE ‘REVENUE 3Y REGION’ IN SCHEMA SALES;

Q25. What kind of Snowflake integration is required when defining an external function in Snowflake?

API integration

HTTP integration

Notification integration

Security integration

Q26. For SQL UDFs, The invoker of the function need not have access to the objects referenced in the function definition, but only needs the privilege to use the function?

TRUE

FALSE

Q27. 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 look over an hour to complete What will improve the query performance the MOST?

increase the size of the virtual warehouse.

Increase the number of clusters in the virtual warehouse

Implement the search optimization service on the table

Add a date column as a cluster key on the table

Q28. Data Engineer, ran the below clustering depth analysis function:
select system$clustering_depth(‘TPCH_CUSTOMERS’, ‘(C1, C6)’, ‘C9 = 30’); on TPCH_CUSTOMERS table, will return which of the following?

An error: this function does not accept lists of columns as a third parameter.

An error: this function does not accept predicates (‘C9 = 30’) as parameter.

Calculate the clustering depth for a table using mentioned columns in the table.

Calculate the clustering depth for a table using the clustering key defined for the table.

Q29. Which are false statements about Star Schema?

Star schemas are denormalized.

The star schema separates business process data into facts, which hold the measurable, quantitative data about a business, and dimensions which are descriptive attributes re-lated to fact data.

Star schema is more flexible in terms of analytical needs compared to Data Vault Mod-elling.

The star schema is an important special case of the snowflake schema and is more effec-tive for handling simpler queries.

Q30. You can execute zero, one, or more transactions inside a stored procedure?

TRUE

FALSE