ExamGecko
Home Home / Microsoft / AI-102

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

Question list
Search
Search

List of questions

Search

Related questions











What is the primary purpose of a data warehouse?

A.
to provide storage for transactional line-of-business (LOB) applications
A.
to provide storage for transactional line-of-business (LOB) applications
Answers
B.
to provide transformation services between source and target data stores
B.
to provide transformation services between source and target data stores
Answers
C.
to provide read only storage of relational and non relational historical data
C.
to provide read only storage of relational and non relational historical data
Answers
D.
to provide answers to complex queries that rely on data from multiple sources
D.
to provide answers to complex queries that rely on data from multiple sources
Answers
Suggested answer: C

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.
a report
A.
a report
Answers
B.
Microsoft Power Apps
B.
Microsoft Power Apps
Answers
C.
a view
C.
a view
Answers
D.
a dataflow
D.
a dataflow
Answers
Suggested answer: C

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?

A.
Online Transaction Processing (OLTP)
A.
Online Transaction Processing (OLTP)
Answers
B.
Online Analytical Processing (OLAP)
B.
Online Analytical Processing (OLAP)
Answers
C.
batch processing
C.
batch processing
Answers
D.
stream processing
D.
stream processing
Answers
Suggested answer: B

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

What should you create in Cower Bl Desktop;1

A.
a waterfall chart
A.
a waterfall chart
Answers
B.
a ribbon chart
B.
a ribbon chart
Answers
C.
a bar chart
C.
a bar chart
Answers
D.
a decomposition tree
D.
a decomposition tree
Answers
Suggested answer: C

Which Azure Storage service implements the key/value model?

A.
Azure Files
A.
Azure Files
Answers
B.
Azure Blob
B.
Azure Blob
Answers
C.
Azure Table
C.
Azure Table
Answers
D.
Azure Queue
D.
Azure Queue
Answers
Suggested answer: C

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

A.
SQL
A.
SQL
Answers
B.
XML
B.
XML
Answers
C.
YAML
C.
YAML
Answers
D.
KOL
D.
KOL
Answers
Suggested answer: A

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

A.
isolation
A.
isolation
Answers
B.
atomicity
B.
atomicity
Answers
C.
consistency
C.
consistency
Answers
D.
durability
D.
durability
Answers
Suggested answer: B

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

A.
durability
A.
durability
Answers
B.
atomicity
B.
atomicity
Answers
C.
consistency
C.
consistency
Answers
D.
isolation
D.
isolation
Answers
Suggested answer: A

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

A.
consistency
A.
consistency
Answers
B.
isolation
B.
isolation
Answers
C.
atomicity
C.
atomicity
Answers
D.
durability
D.
durability
Answers
Suggested answer: A

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?

A.
table
A.
table
Answers
B.
queue
B.
queue
Answers
C.
file
C.
file
Answers
D.
blob
D.
blob
Answers
Suggested answer: C
Total 309 questions
Go to page: of 31