Microsoft AI-102 Practice Test - Questions Answers, Page 14
List of questions
Question 131
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
HOTSPOT
Select the answer that correctly completes the sentence.
Question 132
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Which statement is an example of Data Manipulation Language (DML)?
Question 133
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?
Question 134
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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 135
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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 136
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You have data saved in the following format.
Which format was used?
Question 137
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
What is a primary characteristic of a relational database?
Question 138
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
What ate two uses of data visualization? Each correct answer presents a complete solution. NOTE:
Each correct selection is worth one point.
Question 139
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
What should you use to build a Microsoft Power Bi paginated report?
Question 140
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Which scenario is an example of a streaming workload?
Question