Data

Question 1

What is Azure Cosmos DB?

Answer 1

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.

Question 2

What is atom-record-sequence?

Answer 2

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.

Question 3

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

Answer 3

Azure Database Migration Service

Question 4

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

Answer 4

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

Question 5

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

Answer 5

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

Question 6

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

Answer 6

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.

Question 7

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

Answer 7

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

Question 8

What Azure services are available for analyzing big data?

Answer 8

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