DatabricksCertified Data Engineer Professional
Domain 2Objective 1
Design and Implement Data Ingestion Pipelines to Efficiently Ingest a Variety of Data Formats Including Delta Lake, Parquet, ORC, AVRO, JSON, CSV, XML, Text and Binary from Diverse Sources Such as Message Buses and Cloud Storage. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 4)
Part of the Data Ingestion & Acquisition domain, which accounts for 7% of the DATA-ENGINEER-PROFESSIONAL exam. Databricks does not publish an official question count, but from its 120-minute exam (~50–80 total, ~4–6 in this domain), expect 2–3 from this objective — we provide 34 practice questions to prepare you well beyond it. (estimate)
34questions here
7free pages
15concepts
7%of the exam
Questions 16–20
- 16
Which CSV reader option specifies the character used to enclose fields that contain the delimiter?
Select an answer first - 17
When reading a plain text file with Spark, what is the default column name for the line content?
Select an answer first - 18
Which CSV reader option, when set to true, uses the first line of the file as column names?
Select an answer first - 19
Which technique is commonly used to improve query performance and manageability of large ingestion targets by organizing data into logical groups based on a column value?
Select an answer first - 20
Which statement about reading ORC files with Spark DataFrames is true?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “DATA-ENGINEER-PROFESSIONAL” is a trademark of its owner, used for identification only.