Câu 21: Databricks Certified Data Engineer Professional

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. Which statement correctly describes the outcome of executing these command cells in order in an interactive notebook?

1. A. Both commands will succeed. Executing show tables will show that countries_af and sales_af have been registered as views.
2. B. 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.
3. C. Cmd 1 will succeed and Cmd 2 will fail. countries_af will be a Python variable representing a PySpark DataFrame.
4. D. Both commands will fail. No new variables, tables, or views will be created.
5. E. Cmd 1 will succeed and Cmd 2 will fail. countries_af will be a Python variable containing a list of strings. — đáp án hiện tại