ExamGecko
Home / Microsoft / AI-102 / List of questions
Ask Question

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

Add to Whishlist

List of questions

Question 151

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 152

Report Export Collapse

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.

Become a Premium Member for full access
  Unlock Premium Member

Question 153

Report Export Collapse

You have data saved in the following format.

Microsoft AI-102 image Question 31 84057 09262024174204000000

Which format was used?

Become a Premium Member for full access
  Unlock Premium Member

Question 154

Report Export Collapse

What is a primary characteristic of a relational database?

Become a Premium Member for full access
  Unlock Premium Member

Question 155

Report Export Collapse

What ate two uses of data visualization? Each correct answer presents a complete solution. NOTE:

Each correct selection is worth one point.

Become a Premium Member for full access
  Unlock Premium Member

Question 156

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 157

Report Export Collapse

Which scenario is an example of a streaming workload?

Become a Premium Member for full access
  Unlock Premium Member

Question 158

Report Export Collapse

What is the primary purpose of a data warehouse?

Become a Premium Member for full access
  Unlock Premium Member

Question 159

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 160

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member
Total 339 questions
Go to page: of 34

Related questions