070-765 무료 덤프문제 온라인 액세스

You plan to deploy Microsoft SQL Server on a Microsoft Azure Virtual machine. The virtual machine will have a 30-TB database and will have 10 1-TB VHDs for the database.
You need to configure the storage to meet the following requirements:
Evenly distribute read and write operations across the VHDs.
Minimize the read and write time.
Which storage configuration should you use?

• A.a parity storage pool
• B.a mirrored storage pool
• C.a simple storage pool
• D.a striped volume
• E.a RAID-5 volume

You have been hired as a Database Consultant by ABC.com to design a SQL Server 2014 database solution.
You are tasked with designing a scale-out and high-availability SQL Server 2014 Online Transaction Processing (OLTP) database solution that will maintain copies of data across two server instances.
Your solution must provide scale-out of read operations by distributing the reads from clients across two SQL Server 2014 nodes. The data in both SQL Server nodes needs to be indexed.
What should you include in your solution?

• A.You should include two servers in a Synchronous-Commit Availability Mode Availability Group.
• B.You should include two servers in an Asynchronous-Commit Availability Mode Availability Group.
• C.You should include two servers configured in an Active-Passive SQL Server 2014 Cluster.
• D.You should include a primary database with scheduled log shipping to the secondary database configured.
• E.You should include a primary SQL Server 2014 database that uses transactional replication to replicate data to the secondary database.

You are deploying a virtual machine (VM) to run Microsoft SQL Server in Azure.
The environment currently requires 10,000 IOPS and two terabytes (TB) of data. You expect the IOPS and data volume to double in the first six months after you deploy. The server is currently configured with an Azure Blob storage volume as the F: drive on the SQL Server.
You need to ensure that the environment can support growth requirements while providing the lowest cost solution.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

정답:

1 - Add four premium storage volumes in Azure Blob storage
2 - Formate each storage volume individually
3 - Create a new storage pool within the VM
4 - Create a virtual disk within the storage pool

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are migrating an on-premises Microsoft SQL Server instance to SQL Server on a Microsoft Azure virtual machine. The instance has 30 databased that consume a total of 2 TB of disk space.
The instance sustains more than 30,000 transactions per second.
You need to provision storage for the virtual machine. The storage must be able to support the same load as the on-premises deployment.
Solution: You create one storage account that has one container. You create multiple VHDs in the container.
Does this meet the goal?

• A.Yes
• B.No

You have an on-premises Microsoft SQL Server instance.
You create a database named DB1.
You need to configure DB1 to support In-Memory OLTP.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE; Each correct selection is worth one point.

• A.Enable In-Memory OLTP for the instance.
• B.Configure a new file for a file group.
• C.Configure a new file group for filestream data.
• D.Enable filestream for the instance.
• E.Configure a new file group for memory-optimized data.