Certified Data Engineer Professional Exam

Exam Certified Data Engineer Professional All QuestionsBrowse all questions from this exam

Question 124

A junior member of the data engineering team is exploring the language interoperability of Databricks notebooks. The intended outcome of the below code is to register a view of all sales that occurred in countries on the continent of Africa that appear in the geo_lookup table.

Before executing the code, running SHOW TABLES on the current database indicates the database contains only two tables: geo_lookup and sales.

What will be the outcome of executing these command cells m order m an interactive notebook?

Both commands will succeed. Executing SHOW TABLES will show that countries_af and sales_af have been registered as views.

Cmd 1 will succeed. Cmd 2 will search all accessible databases for a table or view named countries_af: if this entity exists, Cmd 2 will succeed.

Cmd 1 will succeed and Cmd 2 will fail. countries_af will be a Python variable representing a PySpark DataFrame.

Cmd 1 will succeed and Cmd 2 will fail. countries_af will be a Python variable containing a list of strings.

Correct Answer: D

Cmd 1 uses Python to create a list of countries in the continent 'AF' from the 'geo_lookup' table. The resulting variable 'countries_af' is a Python list of strings. Cmd 2 uses SQL to create a view 'sales_af' that filters the 'sales' table based on entries in 'countries_af'. However, since 'countries_af' is a Python list and not accessible directly in the SQL context, Cmd 2 will fail.

Discussion

vexor3Option: D

D is correct

hpkrOption: D

D is correct