CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #9
CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #9: Real Exam Question with Answer & Explanation
Sign in or unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to reveal the answer and full explanation for question #9. The question stem and answer options stay visible for context.
Question
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?
Options
- ABoth commands will succeed. Executing show tables will show that countries at and sales at have
- BCmd 1 will succeed. Cmd 2 will search all accessible databases for a table or view named
- CCmd 1 will succeed and Cmd 2 will fail, countries at will be a Python variable representing a
- DBoth commands will fail. No new variables, tables, or views will be created.
- ECmd 1 will succeed and Cmd 2 will fail, countries at will be a Python variable containing a list of
Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to see the answer
You've previewed enough free CERTIFIED-DATA-ENGINEER-PROFESSIONAL questions. Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.