MC_AzureSqlDatabaseFundamentals_Session2_2

What are the different data formats in Azure Data?

• Structured: Table, rows and columns

• Semi-structured: Key-Value, Document (Json), binary files

• Unstructured: video, audio, images, text files

What are the different types of data stores in Azure Data?

• Relational databases – OLTP (Online transaction Processing)

• Unstructured data

• NoSQL

• Relational databases – OLAP (Online analytics Processing)

What is the difference between OLTP and OLAP?

• OLTP uses row storage and is efficient for processing small transactions.
  OLAP uses columnar storage and is better to run complex queries that can be run in several nodes at the same time.

• OLAP uses row storage and is efficient for processing small transactions.
  OLTP uses columnar storage and is better to run complex queries that can be run in several nodes at the same time.

What are the different types of semi-structured data in Azure Data?

• Documents (JSON)

• Key-value

• Azure files

• All

What is the primary purpose of Azure Cosmos DB?

• Analyzing big data in real-time

• Storing structured data in tabular format

• Hosting virtual machines in the cloud

• Building globally distributed, scalable applications with low-latency access to data

What are the features of Azure SQL Database?

• Authentication and access control

• Azure Blob Storage for storing backups and data files

• Scalability options for adjusting compute and storage resources

How can Azure SQL Database provide scalability and elasticity?

• Working with minimal downtime

• PaaS enables the change of resources easily

• Global data centers, geo-replication and automatic failover

Which of the following is a security measure in Azure SQL Database?

• Enabling verbose logging

• Disabling firewall rules

• Implementing Transparent Data Encryption (TDE).

• Restricted access from IP address

What are the components of Azure SQL?

• Automated backups and point-in-time restore

• Databases

• Compressing data for storage efficiency

What are the benefits of using Azure SQL Database?

• Scalability, High Availability, and Security

• Relational Database Management System

• Structured Query Language