Microsoft Provisioning SQL Databases - 070-765무료 덤프문제 풀어보기
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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You need to run a Transact-SQL script against a Microsoft Azure SQL database daily at 01:00.
Solution: You install the Elastic Database jobs PowerShell package, and then you create an Elastic Database job.
Does this meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You need to run a Transact-SQL script against a Microsoft Azure SQL database daily at 01:00.
Solution: You install the Elastic Database jobs PowerShell package, and then you create an Elastic Database job.
Does this meet the goal?
정답: B
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.
How should you complete the Azure PowerShell command? To answer, select the appropriate Azure PowerShell segments in the answer area.
정답:
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.
Topic 3, SQL Server Reporting
Background
You manage a Microsoft SQL Server environment that includes the following databases: DB1, DB2, Reporting.
The environment also includes SQL Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
All SSRS and SSAS servers use named instances. You configure a firewall rule for SSAS.
Databases
You administer all the deployments of Microsoft SQL Server 2014 in your company. You have two servers in the same data center that hosts your production database.
You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs.
You also need to maintain transactional consistency of the data across both servers.
You need to achieve these goals without manual intervention.
Which configuration should you use?
You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs.
You also need to maintain transactional consistency of the data across both servers.
You need to achieve these goals without manual intervention.
Which configuration should you use?
정답: C
설명: (Fast2test 회원만 볼 수 있음)
You plan to migrate a Microsoft sql server instance between physical servers.
You must migrate the metadata associated with the database instance.
You need to ensure that the new instance retains the existing jobs and alerts.
Solutions: You restore the model database.
Does the solution meet the goal?
You must migrate the metadata associated with the database instance.
You need to ensure that the new instance retains the existing jobs and alerts.
Solutions: You restore the model database.
Does the solution meet the goal?
정답: B
설명: (Fast2test 회원만 볼 수 있음)
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 30 storage accounts that each has one container. You create a VHD in each container.
Does this meet the goal?
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 30 storage accounts that each has one container. You create a VHD in each container.
Does this meet the goal?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
You are planning a Microsoft SQL Server deployment. You do not have a Storage Area Network (SAN) or Network Attached Storage (NAS) infrastructure.
You have a physical host that has 128 gigabytes (GB) RAM, two 8-core processors, and two 1 GB network interface cards (NICs). The host supports RAID through a write-caching RAID controller. The RAID controller is not specifically designed for DBMS systems. The host can support up to eight physically attached disks. The system does not include a battery backup power supply.
You must implement SQL Server best practices when installing and configuring the server to host SQL Server.
You need to configure the system to support a SQL Server installation by using best practices.
What should you do?
You have a physical host that has 128 gigabytes (GB) RAM, two 8-core processors, and two 1 GB network interface cards (NICs). The host supports RAID through a write-caching RAID controller. The RAID controller is not specifically designed for DBMS systems. The host can support up to eight physically attached disks. The system does not include a battery backup power supply.
You must implement SQL Server best practices when installing and configuring the server to host SQL Server.
You need to configure the system to support a SQL Server installation by using best practices.
What should you do?
정답: D
You plan to install Microsoft SQL Server 2014 for a web hosting company.
The company plans to host multiple web sites, each supported by a SQL Server database.
You need to select an edition of SQL Server that features backup compression of databases, basic data integration features, and low total cost of ownership.
Which edition should you choose?
The company plans to host multiple web sites, each supported by a SQL Server database.
You need to select an edition of SQL Server that features backup compression of databases, basic data integration features, and low total cost of ownership.
Which edition should you choose?
정답: B
You administer a single server that contains a Microsoft SQL Server 2014 default instance. You plan to install a new application that requires the deployment of a database on the server. The application login requires sysadmin permissions.
You need to ensure that the application login is unable to access other production databases.
What should you do?
You need to ensure that the application login is unable to access other production databases.
What should you do?
정답: C
설명: (Fast2test 회원만 볼 수 있음)
You have a database named DB1 that contains a table named Table1. Table1 has 1 billion rows.
You import 10 million rows of data into Table1.After the import, users report that queries take longer than usual to execute.
You need to identify whether an out-of-date execution plan is causing the performance issue.
Which dynamic management view should you use?
You import 10 million rows of data into Table1.After the import, users report that queries take longer than usual to execute.
You need to identify whether an out-of-date execution plan is causing the performance issue.
Which dynamic management view should you use?
정답: A
설명: (Fast2test 회원만 볼 수 있음)