A data analyst receives a large dataset from a government agency. The file is a text file where each record is on a separate line and fields are separated by pipes (|). The analyst needs to load this into a SQL database for querying. Which file format is being used, and what is the most direct way to import it?

CSV format; use the database's bulk import tool with a custom delimiter.

JSON format; parse it with a JSON library before loading.

Parquet format; load it with a columnar reader.

XML format; use an XML parser to extract the data.

CompTIAData+

Domain 1Objective 2

Identify Data Sources DA0-001 Practice Questions (Page 7)

Part of the Data concepts and environments domain, which accounts for 20% of the DA0-001 exam. CompTIA does not publish an official question count, but from its 90-minute exam (~35–60 total, ~7–12 in this domain), expect 1–2 from this objective — we provide 31 practice questions to prepare you well beyond it. (estimate)

31questions here

7free pages

6concepts

20%of the exam

Questions 31–31

31application · easy
A data analyst receives a large dataset from a government agency. The file is a text file where each record is on a separate line and fields are separated by pipes (|). The analyst needs to load this into a SQL database for querying. Which file format is being used, and what is the most direct way to import it?
Select an answer first

Finished these 1 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DA0-001

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 CompTIA. “DA0-001” is a trademark of its owner, used for identification only.

Identify Data Sources DA0-001 Practice Questions (Page 7)

Questions 31–31

Keep studying — Data concepts and environments