ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-500 All Questions

View all questions & answers for the AZ-500 exam
Go to Exam

Exam AZ-500 topic 5 question 53 discussion

Actual exam question from Microsoft's AZ-500
Question #: 53
Topic #: 5
[All AZ-500 Questions]

You have an on-premises network and an Azure subscription.
You have the Microsoft SQL Server instances shown in the following table.

You plan to implement Microsoft Defender for SQL.
Which SQL Server instances will be protected by Microsoft Defender for SQL?

  • A. sql1 and sql2 only
  • B. sql1, sql2, and sql3 only
  • C. sql1, sql2, and sql4 only
  • D. sql1, sql2, sql3, and sql4
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by Prince27 at Sept. 18, 2022, 7:57 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
zellck
Highly Voted 2 years, 1 month ago
Selected Answer: D
D is the answer. https://learn.microsoft.com/en-us/azure/defender-for-cloud/defender-for-sql-introduction#availability Protected SQL versions: Read-write replicas of: - Azure SQL single databases and elastic pools - Azure SQL Managed Instance - Azure Synapse Analytics (formerly SQL DW) dedicated SQL pool https://learn.microsoft.com/en-us/azure/defender-for-cloud/defender-for-sql-usage#availability Protected SQL versions: SQL Server version: 2012, 2014, 2016, 2017, 2019, 2022 - SQL on Azure virtual machines - SQL Server on Azure Arc-enabled servers - On-premises SQL servers on Windows machines without Azure Arc
upvoted 12 times
...
erikb77
Highly Voted 2 years, 4 months ago
For server 4 you do need sql azure arc enabled this is not stated in the question. I will go for Awnser C. If Arc is there it would be D
upvoted 10 times
pentium75
10 months, 4 weeks ago
It is also not stated that Arc is NOT enabled. So the correct answer for sql4 would be "it depends" but as this isn't a choice I'd assume ARC is enabled or can be enabled. (There are lots of other questions where 'enable ARC' is part of the solution.)
upvoted 1 times
...
ITFranz
1 year, 6 months ago
Hello. You right. Erikb77. Azure ARC is not explicitly stated in the question, it is just "assumed". The answer to server 4 is on this link. https://learn.microsoft.com/en-us/sql/sql-server/azure-arc/overview?view=sql-server-ver16 SQL Server enabled by Azure Arc extends Azure services to SQL Server instances hosted outside of Azure: in your data center, in edge site locations like retail stores, or any public cloud or hosting provider.
upvoted 2 times
epomatti
1 year, 5 months ago
Not really. The question says "WILL BE PROTECTED", and not "CAN BE PROTECTED". The question really is garbage, but what can we do.
upvoted 3 times
...
...
...
859b41f
Most Recent 3 months, 3 weeks ago
Selected Answer: D
Defender for Servers provides a number of security benefits. Protect multicloud and on-premises machines: Defender for Servers protects Windows and Linux machines in multicloud environments (Azure, AWS, GCP), and on-premises.
upvoted 1 times
...
ITFranz
6 months, 2 weeks ago
Selected Answer: C
To support answer should be C. Microsoft Defender for SQL can protect the following SQL Server instances: Azure SQL Database servers SQL Server on Azure Virtual Machines On-premises SQL servers Azure Arc-enabled SQL servers SQL Server running on Windows machines without Azure Arc SQL Server versions 2012, 2014, 2016, 2017, 2019, and 2022 It's important to note that Microsoft Defender for SQL is only supported for SQL Server instances on Windows machines and does not work for SQL Server on Linux machines Note Microsoft Defender for Cloud is only supported for SQL Server instances on Windows machines. This will not work for SQL Server on Linux machines.
upvoted 1 times
...
Pamban
1 year, 1 month ago
Selected Answer: D
answer is D link https://learn.microsoft.com/en-us/azure/defender-for-cloud/defender-for-sql-usage
upvoted 1 times
...
ACSC
1 year, 2 months ago
Selected Answer: B
SQL Server version: 2012, 2014, 2016, 2017, 2019, 2022 - SQL on Azure virtual machines - SQL Server on Azure Arc-enabled servers
upvoted 1 times
...
ACSC
1 year, 2 months ago
Selected Answer: C
https://learn.microsoft.com/en-us/azure/defender-for-cloud/defender-for-sql-usage#availability. Protected SQL versions: SQL Server version: 2012, 2014, 2016, 2017, 2019, 2022 - SQL on Azure virtual machines - SQL Server on Azure Arc-enabled servers
upvoted 1 times
ACSC
1 year, 2 months ago
Sorry, explanation is for sql1, sql2, sql3, so B
upvoted 1 times
...
...
BigShot0
1 year, 9 months ago
Selected Answer: B
Server 4 cannot be managed with Arc which is missing from the description of the machine. Therefore Server 4 should not be included.
upvoted 3 times
...
ESAJRR
1 year, 9 months ago
Selected Answer: D
D. sql1, sql2, sql3, and sql4
upvoted 2 times
...
majstor86
2 years, 3 months ago
Selected Answer: D
D. sql1, sql2, sql3, and sql4
upvoted 2 times
...
Ajdlfasudfo0
2 years, 5 months ago
https://learn.microsoft.com/en-us/azure/defender-for-cloud/defender-for-sql-usage
upvoted 1 times
...
wyindualizer
2 years, 8 months ago
https://www.microsoft.com/security/blog/2020/12/02/protect-your-sql-server-on-premises-in-azure-and-in-multi-cloud/#:~:text=2%20min%20read-,Protect%20your%20SQL%20Server%20on%2Dpremises,in%20Azure%2C%20and%20in%20multicloud&text=Azure%20Defender%20for%20SQL%20is,in%20virtual%20machines%20on%20Azure.
upvoted 1 times
...
Amit3
2 years, 8 months ago
# In Exam 01-Oct-2022, correct answer.
upvoted 3 times
...
Prince27
2 years, 9 months ago
Pretty straightforward
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel