Data Concepts

Question 1

Azure Storage Accounts

Answer 1

umbrella service for various storage types (table, files, blob, etc.)

Question 2

Azure Blob Storage

Answer 2

data is stored as objects instead of files. for unstructured data

Question 3

Azure Tables

Answer 3

key/value NoSQL datastore. for simpler projects

Question 4

Azure Files

Answer 4

managed file-shared NFS (network file system) or SMB (server message block)

Question 5

Azure Storage Explorer

Answer 5

application to explore data in. Azure storage accounts

Question 6

Azure Synapse Analytics

Answer 6

data warehouse & unified analytics platform

Question 7

CosmoDB

Answer 7

fully-managed NoSQL database service
can host various NoSQL engines (tables, doc, key, graph)

Question 8

Azure Data Lake Store (Gen2)

Answer 8

centralized data repository for big data
blob storage designed for vasts amount of data

Question 9

Azure Data Analytics

Answer 9

Big Data as a Service (BDaaS)

Question 10

Azure Data Box

Answer 10

import/export data via hard drive

Question 11

SQL Server on Azure Virtual Machines

Answer 11

migrating via lift-and-shift, use OS access and control of VM

Question 12

SQL Managed Instances

Answer 12

a managed MS SQL server with broad adaptability

Question 13

Azure SQL

Answer 13

fully managed MS SQL databases

Question 14

Azure Databases for

Answer 14

MySQL, PSQL, MariaDB
managed relational databases on Azure

Question 15

Azure Cache for REDIS

Answer 15

in-memory data-store for returning data
vast but volatile

Question 16

Azure Databricks

Answer 16

specializes in Apache Spark
fast ELT jobs, ML & Streaming

Question 17

Power BI

Answer 17

create dashboards and interactive reports

Question 18

HDInsights

Answer 18

Hadoop System
streaming, ETL/ELT

Question 19

Azure Data Studio

Answer 19

IDE (integrated development environment) for data related tasks

Question 20

Azure Data Factory

Answer 20

ETL/ELT pipeline builder