Microsoft AI-102 Practice Test - Questions Answers, Page 15

List of questions
Question 141

What is the primary purpose of a data warehouse?
Question 142

You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict various key performance indicators, and support data exploration by using drill down. What should you use in Microsoft Power Bl?
Question 143

Your company has a repotting solution that has paginated reports. The reports query a dimensional model in a data warehouse. Which type of processing does the reporting solution use?
Question 144

You need to create a visualization of running sales totals per quarter as shown in the following exhibit.
What should you create in Cower Bl Desktop;1
Question 145

Which Azure Storage service implements the key/value model?
Question 146

What is used to define a query in a stream processing jobs in Azure Stream Analytics?
Question 147

Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or tails completely?
Question 148

Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?
Question 149

Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?
Question 150

You manage an application that stores data in a shared folder on a Windows server. You need to move the shared folder to Azure Storage. Which type of Azure Storage should you use?
Question