Data Flashcards

1
Q

What is Azure Cosmos DB?

A

A multi-model database service that supports schema-less data. It stores data in atom-record-sequence (ARS) format. The data is projected as an API of your choice, including DocumentDB SQL, MongoDB, Cassandra, Azure Table Storage, and Gremlin.

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

What is atom-record-sequence?

A

A data storage format where an atoms consist of a small set of primitive types, such as string, bool, and number, records are structs, and sequences are arrays consisting of atoms, records, or sequences.

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

What service would you use to migrate your existing on-premise SQL Server databases to Azure SQL DB?

A

Azure Database Migration Service

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

How can you query across databases in Azure SQL Database in T-SQL?

A

Use “Elastic queries.” This involves setting up external data sources and external tables on the database that you will run your queries on.

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

What needs to be done to use elastic query to perform reporting tasks over horizontally partitioned (sharded) data?

A

Setup an elastic database shard map to represent the databases of the data tier

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

What is the difference between Azure SQL DB and Azure Managed Instance?

A

Azure Managed Instance is a hybrid of PaaS and IaaS which provides a richer set of features, such as support for OPENQUERY, OPENDATASOURCE, and additional collations.

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

Besides Azure Cosmos DB and Azure SQL DB, what other database services are provided by Azure?

A

Azure Database for MySQL, Azure Database for PostgreSQL, Azure Database for MariaDB, Azure Managed Instance for Apache Cassandra

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

What Azure services are available for analyzing big data?

A

Azure Synapse Analytics, Azure HDInsight, Azure Databricks, Azure Data Lake Analytics

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