PrepAway - Latest Free Exam Questions & Answers

Which SQL Database configuration should you use?

###BeginCaseStudy###
Testlet 1
Background
You are developing an Azure solution that individuals and small businesses will use to prepare and file taxrelated documents.
Business Requirements
General
The solution must provide a way for customers to enter personal and demographic information. Customers
must be able to upload income documents and related documents to the solution. The solution must provide
reports and summary documents for customers in PDF format.
Scope and Device Accessibility
The solution must support two operational modes: On-Peak and Off-Peak. On-Peak is defined as the first
quarter of a year. Off-Peak is defined as the other three quarters of a year. Customers must be able to access
the solution by using desktop computers, laptop computers, mobile devices, and tablets.
High Availability and Business Continuity
The solution must be available at all times. When the solution transitions between Off-Peak mode and On-Peak
mode, solution availability must not be affected. Disaster recovery must be established for the customers’
stored data.
Diagnostics
The solution must log relevant diagnostic data that can be used to troubleshoot the cloud service.
Scalability
The solution must scale out while transitioning from Off-Peak mode to On-Peak mode.
Cost
The solution must use cloud resources optimally to minimize operating costs.
Storage and Security
The solution must be secure to prevent any anonymous access (including read access) to the customers’ tax
documents.
Cross-Premises Networking
The solution must extend the developers’ on-premises network into Azure.
Technical Requirements
The logical design for the solution is shown in the following exhibit.

Platform-as-a-Service (PaaS)
The solution must have two roles: a web role and worker role. The web interface of the solution uses a web role
to accept and send user input and any related documents. The worker role must access the stored data and
prepare the tax documents in the background.
Compute
The solution must support a minimum of 10 role instances. When the solution is in On-Peak mode, each role
instance must be allocated at least 6 GB of memory. The memory can be scaled down to 3 GB when the
solution is in Off-Peak mode.
The solution must cache documents locally. The cache does not need to be refreshed during the lifecycle of the
worker role.
Role instances that are running should not be affected by topology changes such as an increase in instance
count.
Storage
The web role must store documents in blob storage. A SQL database is used to store customer information.
The worker role must use queues to process the final tax documents.
Performance and Scalability
When the solution is in Off-Peak mode, it must support at least 150 concurrent database sessions, and the
maximum size of the database is 50 GB. When the solution is in On-Peak mode, it must support 750
concurrent database sessions, and the maximum size of the database is 300 GB. Geo-replication must be
enabled and must be configurable by using the Azure management portal.
Software Prerequisites
The solution must install the software that is necessary to generate PDF documents on the server. The
software will be provided as a Windows Installer package.
Debugging
Solution errors and warnings that occur in a web role must be logged. The worker role must log any crash
dump files. Detailed information about errors and their context must be collected so that the environment in
which errors occurred can be simulated locally.
Security
At the time that a customer’s tax information and documents are accepted, the solution must send an email to
the customer. The email contains a secure hyperlink that the customer can use to upload any additional
necessary documents. The customer is asked to upload these documents within 48 hours. If the customer does
not upload the documents within 48 hours, the solution should not issue a new hyperlink. The solution mustsend an email to the customer to remind the customer to use the original hyperlink to upload any additional
necessary documents.
Network Services
The solution must use a cross-premises secure network. The network must be configurable by using the Azure
management portal.
Social Structure
Relevant portions of the solution files are shown in the following code segments. Line numbers in the code
segments are included for reference only and include a two-character prefix that denotes the specific file to
which they belong.

###EndCaseStudy###

You need to meet the performance and scalability requirements.
Which SQL Database configuration should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
Use the S1 performance level for On-Peak mode.

B.
Use the P2 performance level for On-Peak mode.

C.
Use the S2 performance level for On-Peak mode.

D.
Use the P1 performance level for On-Peak mode.

One Comment on “Which SQL Database configuration should you use?


Leave a Reply