Free Databricks Certified Data Analyst Associate Actual Exam Questions - Question 9 Discussion
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?
Maybe A makes the most sense here since it’s a small file, and the Create page is designed to handle straightforward uploads quickly without extra steps like cloud storage.
C imo makes sense too since uploading to cloud storage then importing is pretty standard and reliable. Even though it’s a bit more steps than A, it avoids any limitations the Create page might have with certain CSV formats or bigger files. Plus, once in cloud storage, you can reuse the data elsewhere easily.
It’s A because Partner Connect (B) is more for integrating external tools, and manually copying data (D) is just too slow and error-prone. Direct upload via the Create page is quickest for a small CSV.
It’s A, since the file is small and direct upload is way faster than messing with cloud storage.
This one feels like a solid case for A as well since the file is small and you want quick access in Databricks SQL without extra steps. Uploading directly via the Create page is definitely the fastest route for just 50 rows. C would work but adds unnecessary overhead by involving cloud storage first, which isn’t needed here. So yeah, A makes the most sense to get that lookup table ready right away.
A makes sense here since it's the simplest way to get a small file into a Databricks SQL table quickly.
C, because uploading to cloud storage first handles complex CSVs better than direct upload.
A, it’s the simplest and fastest for small files without extra steps.
D imo, copying and pasting data manually is tedious and error-prone, especially when you have a CSV ready. Uploading directly using the Create page (A) is way faster and less hassle for small files.
I think A makes the most sense here. Uploading directly through the Create page in Databricks SQL is the fastest way for a small file like 50 rows, no need to mess with cloud storage or extra connections. Anyone else agree?