Database & Analytics Services Flashcards

1
Q

Which service would you use to build AI solutions, support data science frameworks and ApacheSpark

A

Azure Databricks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which service would you use for machine learning, IoT, ETL, data warehousing and open source analytics services

A

Azure HD Insight

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which service would you use for enterprise data warehousing, big data analytics and can query data using serverless or provisioned resources at scale

A

Azure Synapse Analytics

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which service would you use for on demand analytics jobs and where you can write queries to transform data and extract insights

A

Data Lake Analytics

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which service offers PaaS relational database allowing you to build data driven apps and websites in a language of your choice

A

Azure SQL Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which service provides an open source relational database in the cloud

A

MySQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which service provides a PaaS database engine

A

SQL Managed Instance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Which service can you use to migrate on prem to cloud

A

Azure DB Migration Service

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which service offers globally distributed multi-model database service and supports schema-less data

A

Azure Cosmos DB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Which service is a no SQL managed database

A

Cosmos DB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which service supports multi-region writing

A

Cosmos DB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

You plan to store 20TB data in Azure. The data will be accessed infrequently and visualised using Power BI. Which two solutions should you recommend.

A

Azure Data Lake

Azure Synapse Analytics (Azure SQL data warehouse)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Which service is managed Hadoop service that allows you to process batches by using R, Python, SQL, Scala and Java

A

HD Insight

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Which service is an Apache Spark based analytics platform designed to provide a collaborative analytics workflow

A

Azure Databricks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly