Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft AI-102 Exam - Topic 6 Question 49 Discussion

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?
D) Azure Cosmos DB
A) SQL Server on Azure Virtual Machines
B) Azure SOL Database
C) Azure HDInsight

Microsoft AI-102 Exam - Topic 6 Question 49 Discussion

Actual exam question for Microsoft's AI-102 exam
Question #: 49
Topic #: 6
[All AI-102 Questions]

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

Show Suggested Answer Hide Answer
Suggested Answer: D, E, F

Contribute your Thoughts:

0/2000 characters
Jettie
6 months ago
Surprised that people still consider HDInsight for this!
upvoted 0 times
...
Vanesa
7 months ago
Totally agree, Azure SQL Database is the best choice here!
upvoted 0 times
...
Horace
7 months ago
Wait, isn't SQL Server on VMs more work to manage?
upvoted 0 times
...
Moon
7 months ago
I think Azure Cosmos DB could work too, but not as straightforward.
upvoted 0 times
...
Earlean
7 months ago
Definitely go with Azure SQL Database for low maintenance!
upvoted 0 times
...
Annamaria
8 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
8 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
8 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
8 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
8 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
8 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
1 year 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
1 year 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
1 year 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
1 year ago
B) Azure SQL Database is a managed service, so it would minimize ongoing maintenance.
upvoted 0 times
...
Naomi
1 year 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
1 year 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
12 months ago
C) Azure HDInsight
upvoted 0 times
...
Margarita
1 year ago
B) Azure SOL Database
upvoted 0 times
...
Janessa
1 year ago
A) SQL Server on Azure Virtual Machines
upvoted 0 times
...
...
Bette
1 year 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
12 months ago
Azure Cosmos DB is a good option for scalability, but Azure SQL Database is better for minimizing maintenance.
upvoted 0 times
...
Albert
12 months ago
SQL Server on Azure Virtual Machines could work too, but it requires more maintenance.
upvoted 0 times
...
Nichelle
1 year ago
I agree, Azure SQL Database handles all the management and updates for you.
upvoted 0 times
...
Shantell
1 year ago
I think Azure SQL Database is the way to go for minimizing maintenance.
upvoted 0 times
...
Eun
1 year ago
Azure Cosmos DB is a good option for global distribution, but not for minimizing maintenance.
upvoted 0 times
...
Jaclyn
1 year ago
SQL Server on Azure Virtual Machines could work too, but it requires more maintenance.
upvoted 0 times
...
Alfred
1 year ago
I agree, Azure SQL Database handles the management and updates for you.
upvoted 0 times
...
Caprice
1 year ago
I think Azure SQL Database is the way to go for minimizing maintenance.
upvoted 0 times
...
...
Shawnna
1 year ago
I'm not sure, but I think Azure SQL Database could also be a good option for this scenario.
upvoted 0 times
...
Olen
1 year ago
I agree with Kiera, Azure Cosmos DB is a good choice for relational databases in Azure.
upvoted 0 times
...
Kiera
1 year ago
I think we should use Azure Cosmos DB for minimal maintenance.
upvoted 0 times
...

Save Cancel