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

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

List of questions

Question 141

Report
Export
Collapse

What is the primary purpose of a data warehouse?

to provide storage for transactional line-of-business (LOB) applications
to provide storage for transactional line-of-business (LOB) applications
to provide transformation services between source and target data stores
to provide transformation services between source and target data stores
to provide read only storage of relational and non relational historical data
to provide read only storage of relational and non relational historical data
to provide answers to complex queries that rely on data from multiple sources
to provide answers to complex queries that rely on data from multiple sources
Suggested answer: C
asked 26/09/2024
jonathan Smallwood
33 questions

Question 142

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?

a report
a report
Microsoft Power Apps
Microsoft Power Apps
a view
a view
a dataflow
a dataflow
Suggested answer: C
asked 26/09/2024
J.L.M. van Loo
48 questions

Question 143

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?

Online Transaction Processing (OLTP)
Online Transaction Processing (OLTP)
Online Analytical Processing (OLAP)
Online Analytical Processing (OLAP)
batch processing
batch processing
stream processing
stream processing
Suggested answer: B
asked 26/09/2024
Salvatore Andrisani
40 questions

Question 144

Report
Export
Collapse

You need to create a visualization of running sales totals per quarter as shown in the following exhibit.

Microsoft AI-102 image Question 39 84065 09262024174204000000

What should you create in Cower Bl Desktop;1

a waterfall chart
a waterfall chart
a ribbon chart
a ribbon chart
a bar chart
a bar chart
a decomposition tree
a decomposition tree
Suggested answer: C
asked 26/09/2024
Sunila Chugh
40 questions

Question 145

Report
Export
Collapse

Which Azure Storage service implements the key/value model?

Azure Files
Azure Files
Azure Blob
Azure Blob
Azure Table
Azure Table
Azure Queue
Azure Queue
Suggested answer: C
asked 26/09/2024
bert toger
40 questions

Question 146

Report
Export
Collapse

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

SQL
SQL
XML
XML
YAML
YAML
KOL
KOL
Suggested answer: A
asked 26/09/2024
Haitham Hanash
27 questions

Question 147

Report
Export
Collapse

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

isolation
isolation
atomicity
atomicity
consistency
consistency
durability
durability
Suggested answer: B
asked 26/09/2024
Niels de Lange
38 questions

Question 148

Report
Export
Collapse

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

durability
durability
atomicity
atomicity
consistency
consistency
isolation
isolation
Suggested answer: A
asked 26/09/2024
Ragul Ponniah
41 questions

Question 149

Report
Export
Collapse

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

consistency
consistency
isolation
isolation
atomicity
atomicity
durability
durability
Suggested answer: A
asked 26/09/2024
Praveen Achankunju
44 questions

Question 150

Report
Export
Collapse

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?

table
table
queue
queue
file
file
blob
blob
Suggested answer: C
asked 26/09/2024
Rowan Cele
46 questions
Total 323 questions
Go to page: of 33
Search

Related questions