Data Roles & Azure Data Services Overview

Which data role manages databases, including assigning user permissions, taking backup copies of data, and restoring data after a failure?

• ADatabase administrator✓
• BData analyst
• CAI engineer
• DData engineer

Answer: A database administrator manages databases, assigning permissions to users, storing backup copies of data, and restoring data in the event of a failure, while also being responsible for availability and performance. A data engineer instead manages infrastructure and pipelines for data integration across an organization. A data analyst explores and analyzes data to create visualizations and charts. An AI engineer builds and integrates AI-powered features into applications and workflows.

Which data role manages infrastructure and processes for data integration across an organization, applying data cleaning routines and implementing pipelines to transfer and transform data between systems?

• AData engineer✓
• BData analyst
• CAI engineer
• DDatabase administrator

Answer: A data engineer manages infrastructure and processes for data integration across an organization, applying data cleaning routines, identifying data governance rules, and implementing pipelines to transfer and transform data. A database administrator instead focuses on managing databases, permissions, and backup and recovery. A data analyst explores and analyzes data to create visualizations and charts for decision-making. An AI engineer builds and integrates AI-powered features into applications and data workflows.

Which data role explores and analyzes data to create visualizations and charts that enable an organization to make informed decisions?

• AAI engineer
• BDatabase administrator
• CData analyst✓
• DData engineer

Answer: A data analyst explores and analyzes data to create visualizations and charts, processing raw data into relevant insights based on identified business requirements. A database administrator instead manages the availability, performance, and security of database systems. A data engineer builds and manages data integration pipelines rather than producing reports directly. An AI engineer builds and integrates AI-powered features into applications, not visualizations for business decisions.

A team needs a fully managed platform-as-a-service relational database hosted in Azure, based on the Microsoft SQL Server engine, without managing the underlying virtual machine. Which service should they choose?

• AAzure SQL VM
• BAzure SQL Database✓
• CAzure SQL Managed Instance
• DAzure Database for PostgreSQL

Answer: Azure SQL Database is a fully managed platform-as-a-service (PaaS) database hosted in Azure, part of the Azure SQL family based on the Microsoft SQL Server engine. Azure SQL Managed Instance offers more flexible configuration than Azure SQL Database but comes with more administrative responsibility for the owner. Azure SQL VM is a virtual machine running SQL Server, giving maximum configurability but full management responsibility. Azure Database for PostgreSQL is an open-source relational service, not one based on the SQL Server engine.

Which Azure service is a global-scale nonrelational database that supports multiple APIs, enabling data to be stored and managed as JSON documents, key-value pairs, column-families, or graphs?

• AAzure Database for MySQL
• BAzure Cosmos DB✓
• CAzure SQL Database
• DAzure Data Explorer

Answer: Azure Cosmos DB is a global-scale nonrelational (NoSQL) database system that supports multiple APIs, letting you store and manage data as JSON documents, key-value pairs, column-families, and graphs. Azure SQL Database is a relational, not nonrelational, PaaS database built on the SQL Server engine. Azure Database for MySQL is an open-source relational database service. Azure Data Explorer is a big data analytics platform for querying log and telemetry data, not a multi-API NoSQL store.

Data engineers commonly use which Azure service to host data lakes, using blob storage with a hierarchical namespace that organizes files into folders within a distributed file system?

• AAzure Data Factory
• BAzure Stream Analytics
• CAzure Storage✓
• DAzure Cosmos DB

Answer: Azure Storage lets data engineers host data lakes using blob storage with a hierarchical namespace, which organizes files into folders within a distributed file system. Azure Cosmos DB is a nonrelational database for JSON documents, key-value pairs, column-families, and graphs, not a blob-based data lake host. Azure Data Factory defines and schedules pipelines to transfer and transform data rather than providing the underlying storage. Azure Stream Analytics processes real-time data streams, not hierarchical file storage.

A data analyst needs to query and analyze log files and IoT telemetry data that include a timestamp attribute, using a fully managed, standalone big data analytics platform built for high-performance querying of this kind of data. Which service fits this scenario?

• AAzure Data Explorer✓
• BMicrosoft Purview
• CAzure Data Factory
• DAzure Stream Analytics

Answer: Azure Data Explorer is a fully managed, standalone, big data analytics platform offering high-performance querying of log and telemetry data that includes a timestamp attribute, such as IoT data. Azure Stream Analytics captures and processes a live stream of data in real time rather than querying already-stored timestamped logs. Azure Data Factory defines and schedules pipelines to transfer and transform data, not to query timestamped telemetry directly. Microsoft Purview provides data governance and lineage tracking across data sources, not timestamped log querying.

Which Azure service is a real-time stream processing engine that captures a stream of data from an input, applies a query to extract and manipulate it, and writes the results to an output for further analysis?

• AAzure Data Explorer
• BAzure Databricks
• CAzure Stream Analytics✓
• DAzure Data Factory

Answer: Azure Stream Analytics is a real-time stream processing engine that captures a stream of data from an input, applies a query to extract and manipulate the data, and writes the results to an output. Azure Data Explorer instead queries already-stored log and telemetry data rather than processing a live stream. Azure Data Factory defines and schedules batch pipelines to transfer and transform data, not real-time stream queries. Azure Databricks is a Spark-based analytics platform for large-scale data engineering and science, not specifically a stream processing engine.