Azure SQL

Question 1

vCore Pricing

Answer 1

1. Flexibility, control and transparency
2. Independent scaling of compute, storage and I/O resources

Question 2

What do you use Azure SQL Serverless for?

Answer 2

1. Intermittent, unpredictable usage
2. Automatically scales compute, based on workload demand

Question 3

Name the 3 SQL Service Tiers

Answer 3

1. General/Standard Purpose
2. Business Critical/Premium
3. Hyperscale

Question 4

Solution will ingest a high volume of data in the JSON format by using Azure Event Hubs Data Storage solution must support organizing the data in directory by date and time and allow stored to be queried directly, transformed into summarized tables then stored in a data warehouse (50 TB)

what to use for ingest piece of it

Answer 4

Azure Data Lake

Question 5

Solution will ingest a high volume of data in the JSON format by using Azure Event Hubs Data Storage solution must support organizing the data in directory by date and time and allow stored to be queried directly, transformed into summarized tables then stored in a data warehouse (50 TB)

what to use for the data warehouse piece

Answer 5

Azure SQL Database Hyperscale

Question 6

You have an Azure subscription that contains an Azure SQL database named DB1.
Several queries that query the data in DB1 take a long time to execute.
You need to recommend a solution to identify the queries that take the longest to execute.

What should you include in the recommendation?

Answer 6

Query Performance Insight

Question 7

Which version of Azure SQL support SQL common language runtime (CLR) integration

Answer 7

1. Azure SQL Managed Instance (More cost effective)
2. SQL Server on Azure VM (more expensive)

Question 8

Which one uses active geo-replication

Azure SQL or Azure SQL Managed Instance

Answer 8

Azure SQL

Question 9

Which one uses auto fail-over groups

Azure SQL or Azure SQL Managed Instance

Answer 9

Azure SQL Managed Instance

Question 10

Difference between Azure SQL and Azure SQL Managed Instance in reference to replication

Answer 10

Azure SQL Database supports active geo-replication

Azure SQL Managed instance supports failover groups

Question 11

Which version of Azure SQL supports Common language runtime (CLR)

Answer 11

Azure SQL Managed Instance and SQL Server on Azure VM

Question 12

Azure SQL HA option for same region

Answer 12

Use AlwaysOn availability groups with failover to secondary replicas

Question 13

Azure SQL HA option for secondary region

Answer 13

Use geo-replication and failover groups

Auto failover group–replicates a cross regions

Question 14

What is Azure SQL Geo-Replication feature

Answer 14

Geo-Replication is one feature that allows you to configure asynchronous replication to a secondary region. Failover to the secondary region can be manual or automatic, depending on your configuration. However, note that in asynchronous replication, there may be some data loss in the event of a failover.