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

Exam AZ-304 All Questions

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

Exam AZ-304 topic 3 question 23 discussion

Actual exam question from Microsoft's AZ-304
Question #: 23
Topic #: 3
[All AZ-304 Questions]

You have 100 servers that run Windows Server 2012 R2 and host Microsoft SQL Server 2014 instances. The instances host databases that have the following characteristics:
✑ The largest database is currently 3 TB. None of the databases will ever exceed 4 TB.
✑ Stored procedures are implemented by using CLR.
You plan to move all the data from SQL Server to Azure.
You need to recommend an Azure service to host the databases. The solution must meet the following requirements:
✑ Whenever possible, minimize management overhead for the migrated databases.
✑ Minimize the number of database changes required to facilitate the migration.
✑ Ensure that users can authenticate by using their Active Directory credentials.
What should you include in the recommendation?

  • A. Azure SQL Database elastic pools
  • B. Azure SQL Database Managed Instance
  • C. Azure SQL Database single databases
  • D. SQL Server 2016 on Azure virtual machines
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Tombarc at Aug. 29, 2020, 2:02 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
Tombarc
Highly Voted 4 years, 9 months ago
B is the correct answer. Azure SQL DB does not support CLR stored procedure: ref: https://docs.microsoft.com/en-gb/azure/azure-sql/database/transact-sql-tsql-differences-sql-server#transact-sql-syntax-not-supported-in-azure-sql-database ref: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/transact-sql-tsql-differences-sql-server#clr
upvoted 39 times
17Master
3 years, 3 months ago
D. SQL Server 2016 in VM Azure vs B.Azure SQL Managed Instance CLR Integration - Enabling for both. https://docs.microsoft.com/en-us/sql/relational-databases/clr-integration/clr-integration-enabling?view=sql-server-ver15 So the issue here is: who supports Active Directory authentication? - Directly it would be "D". - Through Azure AD Connect it would be "B". (doesn't mention Azure AD) Correct answer is D
upvoted 1 times
...
walkwolf3
3 years, 6 months ago
Correct SQL Managed Instance enables you to move your on-premises applications to Azure with minimal application or database changes. https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-managed-instance-overview#overview
upvoted 4 times
...
...
pentum7
Highly Voted 4 years, 7 months ago
Correct: SQL Managed Instance allows existing SQL Server customers to lift and shift their on-premises applications to the cloud with minimal application and database changes. At the same time, SQL Managed Instance preserves all PaaS capabilities (automatic patching and version updates, automated backups, high availability) that drastically reduce management overhead and TCO.
upvoted 21 times
prashantjoge
4 years, 2 months ago
why not D?
upvoted 4 times
CKL
4 years ago
Logically, even we don't know about the answer or explanation, but we know that Microsoft will promote their native product, D is not, B is. Fundamental of guessing :)
upvoted 9 times
...
Krsto
4 years, 2 months ago
Because of "Whenever possible, minimize management overhead for the migrated databases". Managed instance does not require for you to do VM and SQL updates, this is done by Microsoft.
upvoted 5 times
demonite
4 years, 1 month ago
same applies for Azure SQL so what's your point here
upvoted 2 times
GetulioJr
4 years ago
Azure SQL is PaaS, all service is mantained by Microsoft. VM with SQL is IaaS, so you need to maintain updates, OS, patches etc. So this is the reason D is not an option here.
upvoted 2 times
BoxGhost
3 years, 10 months ago
No, it explicitly states they need to login using Active Directory credentials. Azure SQL and MI are both out since they only support Azure AD. It's carefully worded as "Wherever possible" rather than an explicit requirement. Therefore D is the only option that works.
upvoted 1 times
...
Load full discussion...
...
...
...
...
17Master
3 years, 3 months ago
D. SQL Server 2016 in VM Azure vs B.Azure SQL Managed Instance CLR Integration - Enabling for both. https://docs.microsoft.com/en-us/sql/relational-databases/clr-integration/clr-integration-enabling?view=sql-server-ver15 So the issue here is: who supports Active Directory authentication? - Directly it would be "D". - Through Azure AD Connect it would be "B". (doesn't mention Azure AD) Correct answer is D
upvoted 1 times
...
...
kenshiroo
Most Recent 1 year, 11 months ago
With the Common Language Runtime (CLR) hosted in Microsoft SQL Server (called CLR integration), you can author stored procedures, triggers, user-defined functions, user-defined types, and user-defined aggregates in managed code. CLR is also available in Azure SQL Database Managed Instance. https://learn.microsoft.com/en-us/shows/data-exposed/its-just-sql-clr-in-azure-sql-database-managed-instance
upvoted 1 times
...
omerco61
2 years, 4 months ago
Answer is correct; Let me explain; 1 "Azure SQL Managed Instance is ideal for customers interested in instance-scoped features, such as SQL Server Agent, Common language runtime (CLR), Database Mail, Distributed transactions, and Machine Learning Services." 2 You can use SQL Managed Instance to do lift-and-shift migrations to Azure without having to redesign your applications. Link https://learn.microsoft.com/en-us/training/modules/design-data-storage-solution-for-relational-data/3-design-for-azure-sql-managed-instance#:~:text=You%20can%20use,Machine%20Learning%20Services.
upvoted 1 times
...
sapien45
3 years ago
Though the clr enabled configuration option is enabled in Azure SQL Database, developing CLR user functions are not supported in Azure SQL Database. B
upvoted 1 times
...
[Removed]
3 years, 3 months ago
Selected Answer: B
Correct answer
upvoted 1 times
...
plmmsg
3 years, 3 months ago
Selected Answer: B
Azure SQL Database Managed Instance
upvoted 1 times
...
c_groleau
3 years, 4 months ago
Selected Answer: B
A. Azure SQL Database elastic pools - Doesn't support CLR B. Azure SQL Database Managed Instance - Correct answer C. Azure SQL Database single databases - Doesn't support CLR D. SQL Server 2016 on Azure virtual machines - Doesn't minimize cost.
upvoted 6 times
...
chiranjibdas
3 years, 6 months ago
Can anyone suggest me How we are ruling out the option. A - with Elastic pool. Manage Instance and Elastic pool - both will serve the purpose , i believe , But Elastic pool is cheaper . In Microsoft ESI portal Mock Test , Similar Question is answered with Elastic Pool . So i am little confused here with Option B - Managed Instance which is bit more expensive than the elastic Pool.
upvoted 2 times
...
PapaLion
3 years, 7 months ago
The Correct Answer is the D we are not talking about hybrid environment so to use AD for authentication the correct answer is the D
upvoted 1 times
FinMessner
3 years, 4 months ago
How do you plan to use AD for authentication on an Azure VM if you don't have a hybrid domain?
upvoted 1 times
...
...
syu31svc
3 years, 8 months ago
"minimize management overhead" I would go for B
upvoted 1 times
17Master
3 years, 3 months ago
if you migrate to sql server in VM you are minimizing the changes. since it is the same platform. Answer is D.
upvoted 1 times
...
...
Gautam1985
3 years, 9 months ago
correct
upvoted 1 times
...
erickim007
4 years ago
there are 3 key requirements that we need to consider. 1. CLR 2. Active Directory (and I believe this is not Azure AD). 3. Minimum Changes With Azure SQL Server, and MI, even with Azure AD is integrated with Admin operation. And I do not believe Window Authentication is supported for both of option. Even with CLR, there are few functions that are not support. Access to File System. We do not know what CLR does and we cannot predict changes that the limitation would cause. In addition, client does not seem mind managing the server by themselves. It seems like there are willing to manage patching and upgrade as they are more concerns around changes/impact/risks comes with migration. Based upon above, SQL using VM should be recommended.
upvoted 7 times
AlexD332
4 years ago
plus they mention db size won't excide 4Gb
upvoted 4 times
...
UnknownSecret
3 years, 10 months ago
You are right, it shuld be D. Azure SQL MI does to support AD on-premises logons. As we move our DM from on-premises, the: "by using their Active Directory credentials" means that Windows Logon type must be supported.
upvoted 2 times
pentium75
3 years, 10 months ago
Per the link below, Azure SQL MI does support AD auth with on-premise credentials if you use SSO ... https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?tabs=azure-powershell
upvoted 2 times
UnknownSecret
3 years, 9 months ago
Yes, I would agree with you if SSO is used. But is not. More about the workaround mentioned by you is here: https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview
upvoted 2 times
...
...
...
pentium75
3 years, 10 months ago
Tricky. SQL Server on VM (D) "is the only way to use Windows authentication to SQL Server." On the other hand, SQL Managed Instance supports "Active Directory integrated authentication ... Use this method if you are logged into Windows using your Azure Active Directory credentials from a federated domain, or a managed domain that is configured for seamless single sign-on for pass-through and password hash authentication." Since they are asking what to INCLUDE in the solution (not for the COMPLETE solution), we could include SQL Managed Instance AND AD Connect with SSO in the solution. Then B would work.
upvoted 2 times
...
17Master
3 years, 3 months ago
D. SQL Server 2016 in VM Azure vs B.Azure SQL Managed Instance CLR Integration - Enabling for both. https://docs.microsoft.com/en-us/sql/relational-databases/clr-integration/clr-integration-enabling?view=sql-server-ver15 So the issue here is: who supports Active Directory authentication? - Directly it would be "D". - Through Azure AD Connect it would be "B". (doesn't mention Azure AD) Correct answer is D
upvoted 1 times
...
...
hendry781
4 years, 2 months ago
Shouldnt the answer be D as it requires Windows AD authentication? Azure SQL MI doesnt support Windows Authentication
upvoted 3 times
rocrock
4 years, 2 months ago
Azure Active Directory (Azure AD) authentication - Azure SQL: Yes. Azure AD users only. SQL Managed Instance: Yes. Including server-level Azure AD logins.
upvoted 1 times
...
17Master
3 years, 3 months ago
D. SQL Server 2016 in VM Azure vs B.Azure SQL Managed Instance CLR Integration - Enabling for both. https://docs.microsoft.com/en-us/sql/relational-databases/clr-integration/clr-integration-enabling?view=sql-server-ver15 So the issue here is: who supports Active Directory authentication? - Directly it would be "D". - Through Azure AD Connect it would be "B". (doesn't mention Azure AD) Correct answer is D
upvoted 1 times
...
...
glam
4 years, 4 months ago
B. Azure SQL Database Managed Instance
upvoted 3 times
...
milind8451
4 years, 4 months ago
CLR is support by SQL Managed instance only. Ans is correct.
upvoted 9 times
TheAzureArchitect
3 years, 7 months ago
CLR also works on SQL on VM. I believe the answer should be D, SQL VM, as AD login not supported on MI.
upvoted 1 times
17Master
3 years, 3 months ago
correct. D. SQL Server 2016 in VM Azure vs B.Azure SQL Managed Instance CLR Integration - Enabling for both. https://docs.microsoft.com/en-us/sql/relational-databases/clr-integration/clr-integration-enabling?view=sql-server-ver15 So the issue here is: who supports Active Directory authentication? - Directly it would be "D". - Through Azure AD Connect it would be "B". (doesn't mention Azure AD) Correct answer is D
upvoted 1 times
...
...
...
JustDiscussing
4 years, 6 months ago
in exam this week
upvoted 2 times
...
Load full discussion...
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