exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 2 question 1 discussion

Actual exam question from Microsoft's AZ-305
Question #: 1
Topic #: 2
[All AZ-305 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:
✑ Stored procedures are implemented by using CLR.
✑ The largest database is currently 3 TB. None of the databases will ever exceed 4 TB.
You plan to move all the data from SQL Server to Azure.
You need to recommend a service to host the databases. The solution must meet the following requirements:
✑ Whenever possible, minimize management overhead for the migrated databases.
✑ Ensure that users can authenticate by using Azure Active Directory (Azure AD) credentials.
✑ Minimize the number of database changes required to facilitate the migration.
What should you include in the recommendation?

  • A. Azure SQL Database elastic pools
  • B. Azure SQL Managed Instance
  • C. Azure SQL Database single databases
  • D. SQL Server 2016 on Azure virtual machines
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
Redimido
Highly Voted 2 years, 9 months ago
Selected Answer: B
CLR is supported on SQL Managed instance and not on Azure SQL Database.
upvoted 45 times
magichappens
2 years, 4 months ago
But it is also supported for elastic pools and these are probably easier to manage? SQL Manage Instance is a service to reach nearly 100% compatibility with your on-prem machines but that was not required here.
upvoted 3 times
rtony69
1 year, 10 months ago
As far as I know, CLR is not supported in AZ SQL database elastic pools. Do you have a doc reference to prove your statement?
upvoted 6 times
ayadmawla
11 months, 1 week ago
See my comment for reference
upvoted 1 times
...
...
...
...
[Removed]
Highly Voted 2 years, 11 months ago
Selected Answer: B
B is correct
upvoted 11 times
...
shaiketisalat
Most Recent 3 weeks, 2 days ago
Today's exam question
upvoted 1 times
...
SeMo0o0o0o
3 weeks, 2 days ago
Selected Answer: B
B is correct
upvoted 1 times
...
Len83
3 months, 4 weeks ago
This question was in the exam August 2024 and I answered with this same answer. I scored 870
upvoted 2 times
...
23169fd
5 months, 2 weeks ago
Selected Answer: B
Explanation: Azure SQL Managed Instance: Minimized Management Overhead: It is a fully managed PaaS service that reduces management tasks compared to running SQL Server on VMs. Azure AD Authentication: Supports Azure AD integration, allowing users to authenticate using Azure AD credentials. Compatibility: It offers high compatibility with SQL Server, minimizing the need for changes during migration, especially for databases using CLR stored procedures.
upvoted 3 times
23169fd
5 months, 2 weeks ago
Why Not Other Options: A. Azure SQL Database elastic pools: Designed for managing multiple databases with variable and unpredictable usage patterns, but might require significant changes for databases using CLR. C. Azure SQL Database single databases: Like elastic pools, it might require significant changes for databases using CLR and doesn't provide the same level of compatibility as Managed Instance. D. SQL Server 2016 on Azure virtual machines: Increases management overhead since it requires maintaining VMs and SQL Server instances, which is against the goal of minimizing management overhead.
upvoted 3 times
...
...
Lazylinux
7 months, 1 week ago
Selected Answer: B
Given answer is correct Keyword is CLR as SQL MI one that supports it
upvoted 1 times
...
ayadmawla
11 months, 1 week ago
Selected Answer: B
Some high-level guidelines might be: -Use Elastic pools if you need to group a large number of single database that don't need all instance Transact-SQL functionalities that exist in SQL Server. -Use Managed Instance if you want to migrate a large number of SQL Server database that heavily use instance level features such as CLR, Service Broker, SQL Agent, etc.
upvoted 3 times
ayadmawla
11 months, 1 week ago
See: https://learn.microsoft.com/en-us/answers/questions/842070/elastic-pool-in-azure-sql-sql-server-managed-insta
upvoted 1 times
...
...
stonwall12
1 year, 2 months ago
Correct Answer - B: Azure SQL Managed Instance Given the requirements and the need for a seamless migration with reduced management overhead, Azure SQL Managed Instance is the most appropriate choice. Reduced Management Overhead - As a fully managed instance in Azure, it offloads many of the administrative tasks, such as backups, patching, and scaling. Azure AD Authentication - Natively supports Azure Active Directory (Azure AD) credentials, providing integrated and secure authentication. Minimal Database Changes - Offers broad compatibility with SQL Server features, ensuring a smooth transition from on-premises SQL Server 2014 environments. CLR Support - Supports Common Language Runtime (CLR) procedures, which is essential given that your stored procedures use CLR. Database Size - Capable of handling databases of significant size, ensuring it can accommodate databases that approach or exceed 3 TB.
upvoted 7 times
...
memo454
1 year, 2 months ago
This question is on today's exam. I passed the exam today 17-09-2023 with a score of 906/1000. The exam is easier than AZ-104.
upvoted 9 times
...
NotMeAnyWay
1 year, 8 months ago
Selected Answer: B
B. Azure SQL Managed Instance Azure SQL Managed Instance is a fully managed SQL Server instance hosted in Azure that supports most of the SQL Server features. It provides easier migration from on-premises SQL Server with minimal database changes, while also minimizing management overhead. Here's how Azure SQL Managed Instance meets your requirements: Minimizes management overhead: As a fully managed service, Azure SQL Managed Instance handles many administrative tasks like automatic backups, patching, and monitoring. Azure AD authentication: Azure SQL Managed Instance supports Azure Active Directory (Azure AD) authentication, which allows users to authenticate using their Azure AD credentials. Minimizes database changes: Since Azure SQL Managed Instance is highly compatible with SQL Server, migrating to it requires minimal changes to the databases. It supports features like CLR, which are not available in Azure SQL Database.
upvoted 7 times
...
zellck
1 year, 9 months ago
Selected Answer: B
B is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql#features-of-sql-database-and-sql-managed-instance Azure SQL Managed Instance Common language runtime - CLR - Yes, but without access to file system in CREATE ASSEMBLY statement
upvoted 4 times
...
Eusouzati
1 year, 10 months ago
Selected Answer: B
B is correct
upvoted 1 times
...
OPT_001122
1 year, 10 months ago
Selected Answer: B
B. Azure SQL Managed Instance
upvoted 1 times
...
VBK8579
1 year, 10 months ago
B. Azure SQL Managed Instance
upvoted 1 times
...
janvandermerwer
1 year, 10 months ago
Selected Answer: B
B was my first guess.
upvoted 1 times
...
Ghoshy
1 year, 11 months ago
Exam Question 12/28/2022
upvoted 3 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago