CERTIFIED-DATA-ANALYST-ASSOCIATE Question #55: Real Exam Question with Answer & Explanation

Question

A stakeholder has provided a data analyst with a lookup dataset in the form of a 50-row CSV file. The data analyst needs to upload this dataset for use as a table in Databricks SQL. Which approach should the data analyst use to quickly upload the file into a table for use in Databricks SOL?

Options

• ACreate a table by uploading the file using the Create page within Databricks SQL
• BCreate a table via a connection between Databricks and the desktop facilitated by Partner
• CCreate a table by uploading the file to cloud storage and then importing the data to Databricks.
• DCreate a table by manually copying and pasting the data values into cloud storage and then

Explanation

Databricks SQL includes a built-in Create page that allows users to directly upload small CSV files and instantly create a queryable table - making option A the fastest and most appropriate approach for a small 50-row lookup file. Option B (Partner Connect) is designed for connecting external BI tools and data partners to Databricks, not for uploading local files. Option C is unnecessarily complex - uploading to cloud storage first (e.g., S3 or ADLS) adds extra steps that are only justified for large or automated data pipelines, not a one-off 50-row file. Option D is never a practical approach, as manually copying data into cloud storage is error-prone and bypasses all the built-in tooling available.

Memory tip: Think "small file = self-service UI." When the dataset is small and the need is quick, Databricks SQL's Create page is your shortcut - no pipelines, no cloud detours, just upload and query.

No community discussion yet for this question.