Importing Data Questions
Practice questions for Importing Data topic in Databricks Certified Data Analyst Associate. 10 questions covering this domain.
A data analyst wants to import a CSV file from their local machine into a Databricks SQL table without writing any code. Which method should they use?
A data engineering team uses Auto Loader to ingest JSON files from an S3 bucket into a Delta table. After several days of operation, the team notices ...
A company receives live data updates from a partner organization that uses a different cloud platform. The partner wants to share data without copying...
A data engineering team wants to ingest data from a JSON files landing zone in an Azure Data Lake Storage (ADLS) container into a Delta table. New fil...
A data analyst wants to bring in a CSV file stored in an Amazon S3 bucket into a Databricks SQL table using a SQL command. Which command is designed f...
A retail company receives daily order data feeds from an external ERP system as CSV files dropped into a specific S3 path. A data analyst uses `COPY I...
CSV files already exist in cloud object storage and need to be loaded into a Delta table with a SQL command designed for ingestion. Which command shou...
An Auto Loader pipeline fails halfway through processing a large landing zone and is restarted. Why can it continue without reprocessing the same file...
CSV files already exist in Amazon S3 and need to be loaded into a Delta table using a Databricks SQL ingestion command. Which command should the analy...
An Auto Loader pipeline fails midway through processing a landing zone and is restarted. Why can it resume without reprocessing the same files into De...
Sign in to see all 10 questions
Create a free account to browse all questions — completely free during our launch phase.