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