Microsoft Azure Data Fundamentals (DP-900)

B is correct.

Explanation: You can classify data as structured, semi-structured, or unstructured.

A is incorrect: Transactional and analytical describe types of data processing, not data formats.

C is incorrect: Relational and nonrelational describe types of databases, not data formats.

D is incorrect: Read-only and read-write describe how a system is accessed, not data formats.

A is correct.

Explanation: The specific file format used to store data depends on many factors.

B is incorrect: Data can be structured, semi-structured, or unstructured. The file format does not always have to be structured.

C is incorrect: The file format depends on many factors, not solely on the database type.

D is incorrect: Read-only describes a type of system access, not a requirement for all file formats.

A is correct.

Explanation: Relational databases are commonly used to store and query structured data.

B is incorrect: A read-only system for historical data or business metrics is associated with analytical data processing.

C is incorrect: The data in this scenario is structured, not unstructured.

D is incorrect: The data is structured, and a file format is not a data store used to query structured data in this context.

C is correct.

Explanation: The work performed by transactional systems is often referred to as Online Transactional Processing (OLTP).

A is incorrect: Analytical data processing typically uses read-only systems that store historical data or business metrics.

B is incorrect: Semi-structured data classification describes a data format, not the work of transactional systems.

D is incorrect: While relational databases can be used, the specific term for the work performed by transactional systems is OLTP.

B is correct.

Explanation: Analytical data processing typically uses read-only systems that store vast volumes of historical data or business metrics.

A is incorrect: OLTP is the work performed by transactional systems, not read-only systems for historical data.

C is incorrect: Structured data classification describes a data format, not a type of data processing.

D is incorrect: Relational databases are used to store and query structured data, but analytical data processing is the specific term for read-only systems storing vast volumes of historical data.

B is correct.

Explanation: A database administrator manages databases, assigns permissions to users, stores backup copies of data, and restores data after a failure. These are the tasks in the scenario.

A is incorrect: A data analyst explores and analyzes data to create visualizations and charts. This role does not manage permissions or backups.

C is incorrect: A data engineer manages data integration, data cleaning routines, and pipelines that move and transform data. Backup and restore for a database is not the primary task of this role.

D is incorrect: An AI engineer builds and integrates AI-powered features. This role does not own database permissions or recovery.

C is correct.

Explanation: An AI engineer builds and integrates AI-powered features into applications and data workflows. This role works with large language models, machine learning pipelines, and data sources.

A is incorrect: A database administrator manages database availability, security, backup, and recovery. This role does not build AI-powered features.

B is incorrect: A data analyst explores data and builds reports and visualizations. A data analyst can work with an AI engineer to surface AI-generated insights, but does not build the feature.

D is incorrect: A data engineer builds pipelines and data stores. A data engineer collaborates with the AI engineer to access and prepare the underlying data, but the AI engineer builds and integrates the feature.

A is correct.

Explanation: Azure SQL VM is a virtual machine with an installation of SQL Server. It allows maximum configurability and requires full management responsibility from the owner.

B is incorrect: Azure SQL Database is a fully managed platform-as-a-service (PaaS) database. Microsoft manages the underlying infrastructure, so it does not give maximum configurability.

C is incorrect: Azure SQL Managed Instance allows more flexible configuration than Azure SQL Database and has automated maintenance. It does not give the maximum configurability of a virtual machine.

D is incorrect: Azure Database for PostgreSQL is a managed service for the open-source PostgreSQL database system. It does not provide a SQL Server installation.

D is correct.

Explanation: Azure Data Explorer is a fully managed, standalone, big data analytics platform. It offers high-performance querying of log and telemetry data, including data with a timestamp attribute.

A is incorrect: Azure Stream Analytics is a real-time stream processing engine. It applies a query to an input stream and writes the results to an output. It is not described as a platform for querying log and telemetry data.

B is incorrect: Azure Storage tables provide key-value storage for applications that need to read and write data values quickly. They are not an analytics platform for log queries.

C is incorrect: Azure Cosmos DB is a global-scale nonrelational database system for JSON documents, key-value pairs, column-families, and graphs. It is not described as an analytics platform for timestamped log data.

B and C are correct.

Explanation: Azure Data Factory lets you define and schedule data pipelines that transfer and transform data. Data engineers use it to build ETL solutions that populate analytical data stores. Microsoft Fabric includes data ingestion and ETL with Fabric Data Factory.

A is incorrect: Azure Stream Analytics is a real-time stream processing engine. It captures a stream from an input, applies a query, and writes the results to an output. It is not described as a pipeline or ETL service for transactional data.

D is incorrect: Microsoft Purview provides enterprise-wide data governance and discoverability. You use it to map data and track data lineage. It does not build ETL pipelines.