Microsoft Exam AI-102 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

Carlee

3 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

3 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

2 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

2 months ago

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

upvoted 0 times

...

Naomi

3 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

3 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

2 months ago

C) Azure HDInsight

upvoted 0 times

...

Margarita

2 months ago

B) Azure SOL Database

upvoted 0 times

...

Janessa

2 months ago

A) SQL Server on Azure Virtual Machines

upvoted 0 times

...

Bette

3 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

1 months ago

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

upvoted 0 times

...

Albert

1 months ago

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

upvoted 0 times

...

Nichelle

2 months ago

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

upvoted 0 times

...

Shantell

2 months ago

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

upvoted 0 times

...

Eun

2 months ago

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

upvoted 0 times

...

Jaclyn

3 months ago

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

upvoted 0 times

...

Alfred

3 months ago

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

upvoted 0 times

...

Caprice

3 months ago

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

upvoted 0 times

...

Shawnna

4 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

4 months ago

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

upvoted 0 times

...

Kiera

4 months ago

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

upvoted 0 times

...