Data Flashcards
What is Azure Cosmos DB?
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.
What is atom-record-sequence?
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.
What service would you use to migrate your existing on-premise SQL Server databases to Azure SQL DB?
Azure Database Migration Service
How can you query across databases in Azure SQL Database in T-SQL?
Use “Elastic queries.” This involves setting up external data sources and external tables on the database that you will run your queries on.
What needs to be done to use elastic query to perform reporting tasks over horizontally partitioned (sharded) data?
Setup an elastic database shard map to represent the databases of the data tier
What is the difference between Azure SQL DB and Azure Managed Instance?
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.
Besides Azure Cosmos DB and Azure SQL DB, what other database services are provided by Azure?
Azure Database for MySQL, Azure Database for PostgreSQL, Azure Database for MariaDB, Azure Managed Instance for Apache Cassandra
What Azure services are available for analyzing big data?
Azure Synapse Analytics, Azure HDInsight, Azure Databricks, Azure Data Lake Analytics