DP-900: Microsoft Azure Data FundamentalsDemo

By Microsoft · Question Mode

QuestionQ280

Describe core data concepts

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Yes or No
StatementsYesNo
Online transaction processing (OLTP) relies on a database system where data storage is optimized for both read and write operations.
Online analytical processing (OLAP) relies on a database system where data storage is optimized for both read and write operations.
Data warehouses are optimized for read operations.
Explanation

OLTP databases are designed for high-volume transactional reads and writes. OLAP workloads and data warehouses are designed chiefly for analytical querying and reporting, which emphasizes read performance rather than transactional write performance.

Community Discussion

No comments yet. Be the first to start the discussion!