exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 151 discussion

Actual exam question from Microsoft's DP-900
Question #: 151
Topic #: 1
[All DP-900 Questions]

You have a quality assurance application that reads data from a data warehouse.
Which type of processing does the application use?

  • A. Online Transaction Processing (OLTP)
  • B. batch processing
  • C. Online Analytical Processing (OLAP)
  • D. stream processing
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Eshant
Highly Voted 4 years, 1 month ago
shouldn't this be OLAP?
upvoted 140 times
rajat7878
2 years, 8 months ago
Quality assurance application focuses on improving the software development process and making it efficient and effective as per quality standards. OLAP applies complex queries to large amounts of historical data, aggregated from OLTP databases and other sources, for data mining, analytics, and business intelligence projects. Moreover, the purpose of OLAP ----> Plan, solve problems, support decisions, discover hidden insights. According to the question, the application is reading data from the data warehouse for quality assurance which is clearly - discovering insights from the data. Thus, the answer is OLAP.
upvoted 14 times
...
Lhouss
3 years, 7 months ago
Agree. Quality assurance need to test a Datawarehouse by using OLAP processing.
upvoted 13 times
...
...
abrwus_aao
Highly Voted 4 years ago
OLAP make more sense
upvoted 36 times
...
AGTraining
Most Recent 8 months ago
option C
upvoted 1 times
...
rmeng
1 year, 1 month ago
Selected Answer: C
The quality assurance application that reads data from a data warehouse typically uses Online Analytical Processing (OLAP) because it involves querying and analyzing historical data for reporting and analysis purposes. OLAP is optimized for complex queries and aggregations on large volumes of data, making it suitable for tasks like data analysis and business intelligence, which align with quality assurance activities. So, the correct answer is: C. Online Analytical Processing (OLAP)
upvoted 2 times
...
fgarcia1986
1 year, 2 months ago
c is correct
upvoted 1 times
...
fiksarion
1 year, 3 months ago
OLAP processing is specifically designed for analytical operations on large volumes of data. It involves performing complex queries, aggregations, and calculations on the data to gain insights and make informed decisions. In the context of a quality assurance application, OLAP processing allows for the analysis of data from the data warehouse to identify patterns, trends, and anomalies, and to generate reports and visualizations for quality assessment and improvement purposes.
upvoted 1 times
...
XtraWest
1 year, 7 months ago
Selected Answer: C
Online Analytical Processing (OLAP) - as per Chat GPT
upvoted 3 times
...
XtraWest
1 year, 7 months ago
C. Online Analytical Processing (OLAP) -- As per Chat GPT
upvoted 2 times
...
Azurre
1 year, 7 months ago
C is correct
upvoted 1 times
...
Alex4190
1 year, 7 months ago
Data Warehouse OLAP
upvoted 1 times
...
Stuurwiel1
1 year, 9 months ago
Selected Answer: C
The quality assurance application that reads data from a data warehouse likely uses online analytical processing (OLAP). Online analytical processing (OLAP) is a category of software tools that enables users to analyze data from multiple dimensions and levels of detail. This type of processing is typically used for business intelligence, data mining, and reporting applications. The data is typically stored in a data warehouse or a multidimensional database, and the OLAP system allows users to perform complex queries and calculations on the data to generate insights and reports.
upvoted 1 times
...
Stuurwiel1
1 year, 9 months ago
https://sqlwizardblog.wordpress.com/2020/03/15/sql-server-oltp-vs-olap/
upvoted 1 times
...
TomGray1989
1 year, 11 months ago
Selected Answer: C
OLAP - It implies an analysis rather than a transaction. It doesn't make sense for a transaction to be coming from a Data warehouse in this context.
upvoted 3 times
...
pallmall
2 years, 1 month ago
Selected Answer: C
C OLAP
upvoted 2 times
...
GregVil
2 years, 2 months ago
Wouldn't it be OLAP since it needs to do analysis which is part of OLAP? Even shown in the diagram. https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-analytical-processing
upvoted 2 times
...
Mern
2 years, 4 months ago
Selected Answer: C
OLAP daw mga lodi
upvoted 4 times
Nitrorj
2 years, 2 months ago
I also thought it's OLAP. kairita mga sagot haha
upvoted 2 times
...
...
cmohl2013
2 years, 5 months ago
Selected Answer: C
Reading from Data Warehouse: Definitely C OLAP always involves write access
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago