Question 10
A shared folder holds equally structured monthly files that must be ingested together. Which starting connector fits?
Explanation
Correct Answer
Use the Folder connector and Combine Files with an example transformation. Folder ingestion applies a common transformation to matching files without manually importing each file.
Incorrect Answers
The Excel connector understands workbook navigation items and table structures. That is a different operating condition from “must be ingested together”: “tables and should be imported into Power Query”.
JSON-oriented ingestion preserves nested objects until they are expanded into tabular columns. It serves “the analyst must expand into fields”, not “must be ingested together”.
Text/CSV import parses delimited records rather than treating each file as an Excel workbook. The present requirement is “must be ingested together”; “text with a header row and encoding requirements” is a distinct situation.