Which type of data is characterized by a predefined schema with rows and columns?
Dp900 Core Data Concepts
Question · Easy
Azure DP-900 Exam Guide 2026: FREE Data Fundamentals Study Plan
Complete 2026 Microsoft DP-900 Azure Data Fundamentals guide. 45 minutes, $99 USD, 700/1000 passing score, 4 skills measured. FREE practice questions, 3-6 week study plan, Microsoft Learn paths, and career value data.
Blog
Structured data
Core Data Concepts
Flashcard
Which of the following is an example of unstructured data?
Text format used to exchange data in web and mobile apps and to store data in log files and NoSQL databases.
Core data concepts
Guess the Term
Chapter 1: Introduction & Exam Overview
1.1 Current Exam Facts
Study guide
Cheat sheet
JSON and XML are examples of which data type?
Read the clue and guess the term in 6 tries.
Game
Semi-structured data
Which data type requires a schema to be defined before data can be stored?
Text format for semi-structured data that a relational database can keep in a native column and search with XQuery.
Images, audio files, and text documents are all examples of which data type?
Unstructured data
Which storage option is best suited for storing files such as documents and images?
Plain-text tabular file whose rows are split into fields by the , character.
1.2 How to Use This Guide
What is the primary difference between file storage and blob storage?
Swap tiles to line up three of the same term.
Term Match
Transactional (OLTP) workloads
Which type of database enforces referential integrity between tables?
Workload that records many small business events as they occur and supports fast reads of current operational data.
Non-relational databases are also commonly referred to as what?
Analytical (OLAP) workloads
Which storage option is best for applications that require complex queries with JOIN operations?
Processing approach for workloads that do not need immediate insight and whose results can arrive minutes or hours later.
Analytics workloads
Chapter 2: Core Data Concepts
2.1 Data Roles and Workloads
Which type of analytics answers the question "What happened?"
Flip two cards at a time to find matching terms.
Term Pairs
ACID properties
What is the primary characteristic of batch processing?
Standard syntax, made an ANSI standard in 1986, that database systems use to access data.
Relational data
Which type of analytics uses historical data to forecast future outcomes?
Batch processing
Streaming data processing is also known as what?
Set of four guarantees that keep database changes safe when several operations run at once.
2.2 Relational vs Non-Relational Data
Which type of analytics would recommend specific actions to achieve a desired outcome?
Find five hidden terms in a grid of letters.
Term Search
Stream processing
A company stores customer information where each customer can have varying numbers of phone numbers and addresses. Which data type is most appropriate?
Question · Medium
Database object that stores an ordered reference to table rows so lookups can be faster.
Which characteristic best distinguishes semi-structured data from unstructured data?
Descriptive vs diagnostic vs predictive vs prescriptive analytics
Log files that contain timestamps, severity levels, and message text in a consistent but flexible format are an example of which data type?
Loading more…