Databricks Certified Data Engineer Professional exam

table("uncleanedSales")View AnswerAnswer: B Explanation: The answer is

You are working on IOT data where each device has 5 reading in an array collected in Celsius, you were asked to covert each individual reading from Celsius to Fahrenheit, fill in the blank with an appropriate function that can be used in this scenario. Schema: deviceId INT, deviceTemp ARRAY<double>...

What is the purpose of a silver layer in Multi hop architecture?A . Replaces a traditional data lake B. Efficient storage and querying of full and unprocessed history of data C. A schema is enforced, with data quality checks. D. Refined views with aggregated data E. Optimized query performance for...

Which of the following describes how Databricks Repos can help facilitate CI/CD workflows on the Databricks Lakehouse Platform?A . Databricks Repos can facilitate the pull request, review, and approval process before merging branches B. Databricks Repos can merge changes from a secondary Git branch into a main Git branch C....

When defining external tables using formats CSV, JSON, TEXT, BINARY any query on the exter-nal tables caches the data and location for performance reasons, so within a given spark session any new files that may have arrived will not be available after the initial query. How can we address this...

What is the main difference between the silver layer and the gold layer in medallion architecture?A . Silver may contain aggregated data B. Gold may contain aggregated data C. Data quality checks are applied in gold D. Silver is a copy of bronze data E. God is a copy of...

Kevin is the owner of the schema sales, Steve wanted to create new table in sales schema called regional_sales so Kevin grants the create table permissions to Steve. Steve creates the new table called regional_sales in sales schema, who is the owner of the table regional_salesA . Kevin is the...

You are currently asked to work on building a data pipeline, you have noticed that you are currently working on a very large scale ETL many data dependencies, which of the following tools can be used to address this problem?A . AUTO LOADER B. JOBS and TASKS C. SQL Endpoints...

SELECT * FROM ____________________A . SELECT * FROM f{schema_name.table_name} B. SELECT * FROM {schem_name.table_name} C. SELECT * FROM ${schema_name}.${table_name} D. SELECT * FROM schema_name.table_nameView AnswerAnswer: C Explanation: The answer is, SELECT * FROM ${schema_name}.${table_name} %python table_name = "sales" schema_name = "bronze" %sql SELECT * FROM ${schema_name}.${table_name} ${python variable} -> Python...

Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?A . MERGE INTO table_name B. COPY INTO table_name C. UPDATE table_name D. INSERT INTO OVERWRITE table_name E. INSERT IF EXISTS table_nameView AnswerAnswer: A Explanation:...