MENU
A data engineer needs to create a table in Databricks using data from a CSV file at location /path/to/csv.
They run the following command:
Which of the following lines of code fills in the above blank to successfully complete the task?
Suggested Answer: B
Get Premium Databricks Certified Data Engineer Associate Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
27 comments · newest first
WI
Willodean
10 months ago
C sounds wrong, it should be USING or FROM, not just FROM.
DO
Donte
11 months ago
Wait, can you really use DELTA for CSV? That seems off.
CH
Chauncey
11 months ago
I’m leaning towards E, but not sure if the path needs quotes.
LI
Lisandra
11 months ago
Definitely not A, you need something to specify the format.
JU
Justine
11 months ago
I think B is the right choice, USING CSV makes sense.
GE
Gearldine
12 months ago
I don't think "None of these lines of code are needed" is correct, but I can't remember the exact syntax for loading CSV data.
NI
Nickolas
12 months ago
I vaguely recall that "USING DELTA" is more for Delta Lake tables, not for reading CSV files.
KI
Kip
12 months ago
I'm not entirely sure, but I feel like "FROM CSV" might be a common syntax I've seen in practice questions.
CA
Candida
1 year ago
I think I remember something about needing to specify the format when reading a CSV in Databricks, so maybe "USING CSV" is the right choice?
DO
Dorsey
1 year ago
Hmm, I'm a bit stumped on this one. The question is asking about the specific syntax to fill in the blank, and I'm not 100% sure which option is correct. I'll have to carefully read through the choices and try to apply my Databricks knowledge to figure this out.
DE
Denae
1 year ago
Alright, I got this! The key here is that we're creating a table from a CSV file, so the correct option is going to be something related to that. I'm pretty sure it's either "FROM CSV" or "USING CSV" - those seem like the most logical choices to me.
DA
Dacia
1 year ago
Ugh, I'm not too familiar with Databricks syntax, so this one is throwing me off a bit. I'll have to really focus and try to remember the key commands for working with CSV files in Databricks. Hopefully, I can at least eliminate a few of the options.
DO
Douglass
1 year ago
Okay, let me think this through step-by-step. We need to create a table in Databricks using data from a CSV file, and the question is asking which line of code fills in the blank. I'm a bit unsure about the exact syntax, but I'll carefully read through the options and try to reason it out.
SH
Shenika
1 year ago
Hmm, this looks like a pretty straightforward Databricks question. I think I've seen something similar before, so I'm feeling pretty confident about this one.
ST
Stanford
1 year ago
Okay, I'm pretty sure I know the answer here. Tasks are the commands sent from the driver to the executors, so I think A is the correct choice.
EL
Elden
1 year ago
Hmm, I'm a bit confused on the different trigger types in Flow Designer. I'll have to review those before answering this.
JO
Johnna
1 year ago
Hmm, I'm not entirely sure about the difference between the options here. I'll need to think this through carefully.
EL
Eliz
1 year ago
Hmm, I'm a bit unsure about this one. I know Azure policies are used for consistency, but I'm not sure if the statement is completely accurate. I'll need to think it through carefully.
RE
Reita
2 years ago
I'm not sure, but I think A) None of these lines of code are needed to successfully complete the task could also be a possibility.
WA
Wayne
2 years ago
I would go with E) FROM "path/to/csv" because it specifies the correct file path.
GI
Gilma
2 years ago
I think the answer is C) FROM CSV.
TO
Tomas
2 years ago
I disagree, I believe the answer is D) USING DELTA.
PA
Paris
2 years ago
I think the answer is B) USING CSV.
LI
Lindy
2 years ago
I think D) USING DELTA could also be a valid option for creating a table.
CA
Candra
2 years ago
I'm not sure, but I think it might be B) USING CSV.
BO
Bo
2 years ago
I agree with Noble, using the correct file path is important.
NO
Noble
2 years ago
I think the correct answer is E) FROM 'path/to/csv'.