問題文
A retailer receives one order file per market from thirty markets, each with the same layout and a market column. The internal team is small. Which design does the consultant recommend?
選択肢
- Thirty scheduled automations, one for each market's run time, loading each arrival into the same table, so the team maintains a separate definition while the market column keeps the rows apart from one another.
- One scheduled automation whose run time covers every market's file name, loading each arrival into the same table, so the team maintains a single definition while the market column keeps the rows apart from one another.
- One file drop automation whose pattern matches every market's file name, loading each arrival into the same table, so the team maintains one definition while the market column keeps the rows apart.
- Thirty file drop automations, one for each market's file name, loading each arrival into its own table, so the team maintains a separate definition while the table name keeps the rows apart from one another.