Microsoft AI-102 Exam - Topic 6 Question 49 Discussion

Actual exam question for Microsoft's AI-102 exam

Question #: 49
Topic #: 6

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?

ASQL Server on Azure Virtual Machines

BAzure SOL Database

CAzure HDInsight

DAzure Cosmos DB

Show Suggested Answer

Suggested Answer: D, E, F

by Marguerita at Aug 09, 2023, 02:35 PM

Limited Time Offer

25%

Off

Get Premium AI-102 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jettie

4 months ago

Surprised that people still consider HDInsight for this!

upvoted 0 times

...

Vanesa

4 months ago

Totally agree, Azure SQL Database is the best choice here!

upvoted 0 times

...

Horace

4 months ago

Wait, isn't SQL Server on VMs more work to manage?

upvoted 0 times

...

Moon

5 months ago

I think Azure Cosmos DB could work too, but not as straightforward.

upvoted 0 times

...

Earlean

5 months ago

Definitely go with Azure SQL Database for low maintenance!

upvoted 0 times

...

Annamaria

5 months ago

I’m torn between B and D. I know Azure Cosmos DB is great for NoSQL, but I’m not sure if it fits the relational database requirement here.

upvoted 0 times

...

Barb

5 months ago

I feel like I’ve seen a similar question before, and Azure SQL Database was the recommended option for relational databases in Azure.

upvoted 0 times

...

Justine

5 months ago

I’m not entirely sure, but I remember something about SQL Server on Azure VMs needing more management, so maybe that’s not the best choice.

upvoted 0 times

...

Rozella

6 months ago

I think the answer might be B, Azure SQL Database, because it’s designed for minimal maintenance compared to VMs.

upvoted 0 times

...

Lauran

6 months ago

This question seems pretty straightforward. I think the key is to focus on the characteristics of a pyramid scheme versus a legitimate business.

upvoted 0 times

...

Jani

6 months ago

Hmm, this looks like a tricky one. I'll need to carefully read through the code and think through the expected behavior.

upvoted 0 times

...

Carlee

11 months ago

Hey, at least it's not asking about running a database on an Excel spreadsheet! B) Azure SQL Database is the way to go for a hands-off approach.

upvoted 0 times

...

Laura

11 months ago

A) SQL Server on Azure Virtual Machines gives me more control, but I'll have to handle the maintenance myself. Hmm, tough choice.

upvoted 0 times

Ashton

10 months ago

D) Azure Cosmos DB is also a good option for minimizing maintenance, as it is a globally distributed database service.

upvoted 0 times

...

Ronna

10 months ago

B) Azure SQL Database is a managed service, so it would minimize ongoing maintenance.

upvoted 0 times

...

Naomi

10 months ago

A) SQL Server on Azure Virtual Machines gives me more control, but I'll have to handle the maintenance myself. Hmm, tough choice.

upvoted 0 times

...

Giuseppe

11 months ago

D) Azure Cosmos DB is a good choice for a scalable, globally distributed database solution. Though it may not be the best fit for a relational database requirement.

upvoted 0 times

Denise

9 months ago

C) Azure HDInsight

upvoted 0 times

...

Margarita

10 months ago

B) Azure SOL Database

upvoted 0 times

...

Janessa

10 months ago

A) SQL Server on Azure Virtual Machines

upvoted 0 times

...

Bette

11 months ago

B) Azure SQL Database seems like the best option to minimize ongoing maintenance. Azure takes care of the database management and updates.

upvoted 0 times

Carma

9 months ago

Azure Cosmos DB is a good option for scalability, but Azure SQL Database is better for minimizing maintenance.

upvoted 0 times

...

Albert

9 months ago

SQL Server on Azure Virtual Machines could work too, but it requires more maintenance.

upvoted 0 times

...

Nichelle

10 months ago

I agree, Azure SQL Database handles all the management and updates for you.

upvoted 0 times

...

Shantell

10 months ago

I think Azure SQL Database is the way to go for minimizing maintenance.

upvoted 0 times

...

Eun

10 months ago

Azure Cosmos DB is a good option for global distribution, but not for minimizing maintenance.

upvoted 0 times

...

Jaclyn

10 months ago

SQL Server on Azure Virtual Machines could work too, but it requires more maintenance.

upvoted 0 times

...

Alfred

10 months ago

I agree, Azure SQL Database handles the management and updates for you.

upvoted 0 times

...

Caprice

11 months ago

I think Azure SQL Database is the way to go for minimizing maintenance.

upvoted 0 times

...

Shawnna

11 months ago

I'm not sure, but I think Azure SQL Database could also be a good option for this scenario.

upvoted 0 times

...

Olen

12 months ago

I agree with Kiera, Azure Cosmos DB is a good choice for relational databases in Azure.

upvoted 0 times

...

Kiera

12 months ago

I think we should use Azure Cosmos DB for minimal maintenance.

upvoted 0 times

...