Microsoft Certified Azure Solutions Architect Expert · Free Practice Question Hard
Question 17
Case study
Current environment General An insurance company, GetCloudSkillsInsurance, operates in three states and provides home, auto, and boat insurance. Besides the head office, GetCloudSkillsInsurance has three regional offices.
Technology assessment
The company operates two Active Directory forests: main.getcloudskillsinsurance.com and region.habinsurance.com. The primary internal system of GetCloudSkillsInsurance is the Insurance Processing System (IPS), an ASP.Net/C# application running on IIS/Windows Servers within a data center. IPS is structured into three tiers: web, business logic API, and backend datastore. For the backend, the company utilizes Microsoft SQL Server and MongoDB. The system is divided into two segments: Customer data and Insurance forms and documents. The Customer data resides in Microsoft SQL Server, while the Insurance forms and documents are stored in MongoDB.
Additionally, the company maintains 10 TB of Human Resources (HR) data on NAS at their head office.
Requirements
General
GetCloudSkillsInsurance is planning to migrate its workloads to Azure and has acquired an Azure subscription.
Changes
During the transition, GetCloudSkillsInsurance aims to establish a hybrid identity model in conjunction with a Microsoft Office 365 deployment. The company plans to synchronize its AD forests with Azure AD to utilize the administrative units feature of Azure AD.
GetCloudSkillsInsurance is looking to transition its existing IPSCustomers SQL database to a new, fully managed SQL database in Azure. This database should be cost-effective while offering scalable compute and storage capabilities. The management team anticipates that the Azure database service will dynamically scale the database resources with minimal downtime. The technical team suggests adopting a DTU-based purchasing model for this new database.
The company also intends to transfer insurance forms and documents to the Azure database service.
GetCloudSkillsInsurance is considering migrating the first two tiers of IPS to Azure without alterations. The technology team is exploring the feasibility of operating these IPS tiers on a collection of virtual machine instances, with the number of instances automatically adjusting based on CPU utilization. They aim to ensure a 99.95% SLA for the compute infrastructure.
The company must relocate HR data to Azure File shares.
Within their new Azure environment, GetCloudSkillsInsurance plans to integrate both internal and third-party applications. The company is contemplating implementing user consent for data access within the registered applications.
The technology team is evaluating the addition of a customer self-service portal to IPS and the deployment of a new IPS across multiple regions in Azure Kubernetes Service (AKS). However, the management team has concerns regarding the performance and availability of the multi-region AKS deployments in the event of regional outages.
The technical team suggests adopting a DTU-based purchasing model for the new database.
Which two parameters would you recommend configuring to ensure that the new IPSCustomers database scales effectively to meet workload demands?
-
A
Define the maximum of CPU cores
-
B
Define the maximum resource limit per group of databases
-
C
Define the maximum of Database Transaction Units
-
D
Define the maximum of the allocated storage
-
E
Define the maximum size for a database
Reveal correct answers
Correct answers: C, E
Explanation
Scale resources - Azure SQL Database & Azure SQL Managed Instance | Microsoft Learn
What is the Azure SQL Database service? - Azure SQL Database | Microsoft Learn
What is a single database? - Azure SQL Database | Microsoft Learn
A. Defining the maximum of CPU cores is not directly related to ensuring effective scaling of the database to meet workload demands. While CPU cores play a role in database performance, they are not the primary parameter for scalability in this context.
B. Defining the maximum resource limit per group of databases is important for resource management but does not directly contribute to the scalability of the database to meet workload demands. This parameter focuses on resource allocation rather than scalability.
C. Defining the maximum of Database Transaction Units (DTUs) is crucial for ensuring effective scaling of the database to meet workload demands. DTUs are a measure of the performance and resources allocated to the database, and setting a maximum limit helps in dynamically scaling resources based on workload requirements.
D. Defining the maximum of the allocated storage is important for managing storage capacity but does not directly impact the scalability of the database to meet workload demands. While storage capacity is essential, it is not the primary factor for scaling database resources.
E. Defining the maximum size for a database is a key parameter to ensure effective scaling of the database to meet workload demands. By setting a maximum size limit, the database can dynamically scale its compute and storage resources based on workload requirements, ensuring efficient performance and scalability.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
