Answer-first summary for fast verification
Answer: Create a table by uploading the file using the Create page within Databricks SQL.
Option A is the correct answer because it provides the quickest and most direct method to upload a small CSV file (50 rows) and create a table in Databricks SQL. The Create page in Databricks SQL offers a straightforward UI-based upload feature specifically designed for this purpose, requiring minimal steps. Option B (Partner Connect) is unsuitable as it's for connecting to external partner services, not for uploading local files. Option C (upload to cloud storage first) adds unnecessary complexity and steps for such a small file. Option D (manual copy-paste to cloud storage) is inefficient and error-prone, especially for structured CSV data. The community discussion shows 100% consensus on A, with users noting the other options are 'clearly non-starters' for this quick upload scenario.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A stakeholder has provided a data analyst with a 50-row CSV lookup file. The data analyst needs to upload this dataset into a table for use in Databricks SQL.
Which method should the data analyst use to quickly upload the file and create a table?
A
Create a table by uploading the file using the Create page within Databricks SQL.
B
Create a table via a connection between Databricks and the desktop facilitated by Partner Connect.
C
Create a table by uploading the file to cloud storage and then importing the data to Databricks.
D
Create a table by manually copying and pasting the data values into cloud storage and then importing the data to Databricks.
No comments yet.