This is a dedicated watch page for a single video.
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. Cmd 1: % python countries_af = [ x [ 0 ] for x in spark . table ( "geo_lookup" ) . filter ( "continent='AF'" ) . select ( "country" ) . collect () ] Cmd 2: % sql CREATE VIEW sales_af AS SELECT * FROM sales WHERE city IN ( SELECT country FROM geo_lookup WHERE continent = 'AF' ) AND continent = 'AF' ; Which statement correctly describes the outcome of executing these command cells in order in an interactive notebook?