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

List of questions
Question 151

You have a SQL query that combines customer data and order dat a. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SOL query. What should you create?
Question 152

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection Is worth one point.
Question 153

You have data saved in the following format.
Which format was used?
Question 154

What is a primary characteristic of a relational database?
Question 155

What ate two uses of data visualization? Each correct answer presents a complete solution. NOTE:
Each correct selection is worth one point.
Question 156

What should you use to build a Microsoft Power Bi paginated report?
Question 157

Which scenario is an example of a streaming workload?
Question 158

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

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 160

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