nerdexam
Microsoft

AI-100 · Question #21

You plan to implement a new data warehouse for a planned AI solution. You have the following information regarding the data warehouse: - The data files will be available in one week. - Most queries…

Sign in or unlock AI-100 to reveal the answer and full explanation for question #21. The question stem and answer options stay visible for context.

Analyze solution requirements

Question

You plan to implement a new data warehouse for a planned AI solution. You have the following information regarding the data warehouse:

  • The data files will be available in one week.
  • Most queries that will be executed against the data warehouse will be

ad-hoc queries.

  • The schemas of data files that will be loaded to the data warehouse

will change often.

  • One month after the planned implementation, the data warehouse will

contain 15 TB of data. You need to recommend a database solution to support the planned implementation. What two solutions should you include in the recommendation? Each correct answer is a complete solution. NOTE: Each correct selection is worth one point.

Options

  • AApache Hadoop
  • BApache Spark
  • Ca Microsoft Azure SQL database
  • Dan Azure virtual machine that runs Microsoft SQL Server

Unlock AI-100 to see the answer

You've previewed enough free AI-100 questions. Unlock AI-100 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#data warehouse#Apache Hadoop#Apache Spark#ad-hoc queries
Full AI-100 Practice