Module 1 - Data roles and services

Question 1

Data Administrators (Data Roles)

Answer 1

• Database systems’ design, deployment and maintenance.
• Responsible for the availability, security, performance of databases.
• Backup and recovery.

Question 2

Data Engineers (Data Roles)

Answer 2

• Data workloads, data ingestion pipelines, data cleaning and transforming, and storage solutions.
• They work with a wide range of technologies
• Manage and monitor data pipelines

Question 3

Data Analysts (Data Roles)

Answer 3

• Explore data, for patterns relationships, creating analytical models, reports and visualizations.

Question 4

Microsoft Azure

Answer 4

• Cloud platform that supports application and IT infrastructure for organizations. For both transactional and analytical data workloads.

Question 5

Azure SQL (Data Services)

Answer 5

Collection of relational database solutions based on the Microsoft SQL Server database engine.
- Azure SQL Database
- fully managed platform-as-a-service (PaaS) database
- Azure SQL Managed Instance
- a hosted instance of SQL Server, more configuration, but more responsibility
- Azure SQL VM
- a virtual machine with an installation of SQL Server, maximum configuration, and full management responsibility

Question 6

Open-source databases in Azure (Data Services)

Answer 6

• Azure database for MySQL
• Azure database for MariaDB
• Azure database for PostgreSQL

Question 7

Azure Cosmos DB (Data Services)

Answer 7

Global-scale NoSQL database system, that supports multiple APIs.

Question 8

Azure Storage (Data Services)

Answer 8

Allows you to store data in:
- Blob containers
- for binary files
- File shares
- network file shares
- Tables
- key-value storage

Question 9

Azure Data Factory (Data Services)

Answer 9

Allows you to define and schedule data pipelines to transfer and transform data.

Question 10

Microsoft Fabric (Data Services)

Answer 10

Unified software-as-a-service (SaaS) analytics platform.
- Includes:
- data ingestion pipelines, data warehouses, real-time analytics, bi, and ai

Question 11

Azure Databricks (Data Services)

Answer 11

Apacg Spark data processing platform with SQL database semantics and an integrated management interface to enable large-scale data analytics.

Question 12

Azure Stream Analytics (Data Services)

Answer 12

Captures a stream of data from an input, aplies a query to extract and manipulate data from the input stream, and writes the results to an output for analysis or further processing.

Question 13

Azure Data Explorer (Data Services)

Answer 13

A fully managed, standalone, big data analytics platform.

Question 14

Microsoft Purview (Data Services)

Answer 14

Unified data governance solution that helps organizations discover, manage, and protect data across on-premises, multi-cloud, and SaaS environments.