Valid 70-765 Dumps shared by PassLeader for Helping Passing 70-765 Exam! PassLeader now offer the newest 70-765 VCE dumps and 70-765 PDF dumps, the PassLeader 70-765 exam questions have been updated and ANSWERS have been corrected, get the newest PassLeader 70-765 dumps with VCE and PDF here: https://www.passleader.com/70-765.html (155 Q&As Dumps –> 192 Q&As Dumps –> 211 Q&As Dumps –> 282 Q&As Dumps)
BTW, DOWNLOAD part of PassLeader 70-765 dumps from Cloud Storage: https://drive.google.com/open?id=0B-ob6L_QjGLpZHlHSG5KM09xUms
QUESTION 25
Hotspot Question
You need to optimize SRV1. What configuration changes should you implement? (To answer, select the appropriate option from each list in the answer area.)
Answer:
Explanation:
From the scenario: SRV1 has 16 logical cores and hosts a SQL Server instance that supports a mission-critical application. The application hasapproximately 30,000 concurrent users and relies heavily on the use of temporary tables.
Box 1: Change the size of the tempdb log file. The size and physical placement of the tempdb database can affect the performance of a system. For example, if the size that is defined for tempdb is too small, part of the system- processing load may be taken up with autogrowing tempdb to the size required to support the workload every time you restart the instance of SQL Server. You can avoid this overhead by increasing the sizes of the tempdb data and log file.
Box 2: Add additional tempdb files. Create as many files as needed to maximize disk bandwidth. Using multiple files reduces tempdb storage contention and yields significantly better scalability. However, do not create too many files because this can reduce performance and increase management overhead. As a general guideline, create one data file for each CPU on the server (accounting for any affinity mask settings) and then adjust the number of files up or down as necessary.
Case Study 2 – Contoso, Ltd.
Background
You are the database administrator for Contoso, Ltd. The company has 200 offices around the world. The company has corporate executives that are located in offices in London, New York, Toronto, Sydney, and Tokyo. Contoso, Ltd. has a Microsoft Azure SQL Database environment. You plan to deploy a new Azure SQL Database to support a variety of mobile applications and public websites. The company is deploying a multi-tenant environment. The environment will host Azure SQL Database instances. The company plans to make the instances available to internal departments and partner companies. Contoso is in the final stages of setting up networking and communications for the environment. Existing Contoso and Customer instances need to be migrated to Azure virtual machines (VM) according to the following requirements:
– Contoso instances – should use the method requiring the least administrative effort to migrate instances to Azure Vms.
– Customer instances – should use a method that allows customers to bring their own licenses to Azure VMs. Customers have approved down time for the migration.
The company plans to deploy a new order entry application and a new business intelligence and analysis application. Each application will be supported by a new database. Contoso creates a new Azure SQL database named Reporting. The database will be used to support the company’s financial reporting requirements. You associate the database with the Contoso Azure Active Directory domain. Each location database for the data entry application may have an unpredictable amount of activity. Data must be replicated to secondary databases in Azure datacenters in different regions. To support the application, you need to create a database named contosodb1 in the existing environment.
Objects
Database
The contosodb1 database must support the following requirements:
– a size of at least 200 gigabytes (GB).
– 1,000 concurrent sessions.
– point-in-time restore to any point in the two weeks prior to a failure.
– minimize costs.
Application
For the business intelligence application, corporate executives must be able to view all data in near real-time with low network latency. Contoso has the following security, networking, and communications requirements:
– Multi-Location Load Balancing – to ensure customers have access to their tenants at multiple Azure locations across the world.
– Secure Message/Data Flow – to securely support communication between Azure and on-premises applications and services.
– Accounts should support accessing external domain resources and be configured in the most secure and lowest-maintenance way possible, including meeting the company policy of regular service account password changes.
QUESTION 26
Hotspot Question
You need to configure the data entry and business intelligence databases. In the table below, identify the option that you must use for each database. (Make only one selection in each column.)
Answer:
Explanation:
Data Entry: Geo-replicated database only. From Contoso scenario: Each location database for the data entry application may have an unpredictable amount of activity. Data must be replicated to secondary databases in Azure datacenters in different regions.
Business intelligence: Elastic database pools only. From Contoso scenario: For the business intelligence application, corporate executives must be able to view all data in near real-time with low network latency. SQL DB elastic pools provide a simple cost effective solution to manage the performance goals for multiple databases that have widely varying and unpredictable usage patterns.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool
QUESTION 27
Hotspot Question
You need to create the contosodb1 database. How should you complete the Azure PowerShell command? (To answer, select the appropriate Azure PowerShell segments in the answer area.)
Answer:
Explanation:
Box 1: New-AzureRmSqlDatabase. New-AzureRmSqlDatabase creates a database or an elastic database. New-AzureRmSqlDatabase is a command with the Azure Resource Manager (AzureRM) module. Azure Resource Manager enables you to work with the resources in your solution as a group.
Get the newest PassLeader 70-765 VCE dumps here: https://www.passleader.com/70-765.html (155 Q&As Dumps –> 192 Q&As Dumps –> 211 Q&As Dumps –> 282 Q&As Dumps)
And, DOWNLOAD the newest PassLeader 70-765 PDF dumps from Cloud Storage for free: https://drive.google.com/open?id=0B-ob6L_QjGLpZHlHSG5KM09xUms