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…

The correct answer is A. Apache Hadoop B. Apache Spark. https://docs.microsoft.com/en-us/azure/sql-database/saas-multitenantdb-adhoc-reporting

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

How the community answered

(22 responses)
  • A
    77% (17)
  • C
    9% (2)
  • D
    14% (3)

Explanation

https://docs.microsoft.com/en-us/azure/sql-database/saas-multitenantdb-adhoc-reporting

Topics

#data warehouse#Apache Hadoop#Apache Spark#ad-hoc queries

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full AI-100 Practice