Databricks Exam Databricks-Certified-Professional-Data-Engineer Topic 1 Question 16 Discussion

Actual exam question for Databricks's Databricks-Certified-Professional-Data-Engineer exam

Question #: 16
Topic #: 1

[All Databricks-Certified-Professional-Data-Engineer Questions]

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?

ABoth commands will succeed. Executing show tables will show that countries at and sales at have been registered as views.

BCmd 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.

CCmd 1 will succeed and Cmd 2 will fail, countries at will be a Python variable representing a PySpark DataFrame.

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 strings.

Show Suggested Answer

Suggested Answer: B

When viewing a Databricks Python notebook in a text editor, the first line indicates the format and source type of the notebook. The correct option is % Databricks notebook source, which is a magic command that specifies the start of a Databricks notebook source file.

by Gilma at Jul 13, 2024, 06:05 PM

Limited Time Offer

25%

Off

Get Premium Databricks-Certified-Professional-Data-Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Linwood

22 days ago

This question is like a choose-your-own-adventure book, but the only adventure is a coding nightmare. I'm going to play it safe and go with D. After all, better to be a boring winner than a flashy loser, right?

upvoted 0 times

...

Phuong

29 days ago

Ha! This question is like a game of 'Where's Waldo' but with SQL commands instead of a tiny dude in a striped shirt. I'm feeling lucky, so I'll go with E and hope the exam graders have a sense of humor.

upvoted 0 times

...

Hoa

1 months ago

Alright, let's think this through logically. If the database only has two tables, then the first command should definitely work. But that second one... it's like a riddle wrapped in a mystery inside an enigma. I'll go with B and hope for the best.

upvoted 0 times

Isabelle

8 days ago

User1: I think Cmd 1 will work for sure.

upvoted 0 times

...

2 months ago

I think the correct answer is A.

upvoted 0 times

...