Microsoft Provisioning SQL Databases - 70-765무료 덤프문제 풀어보기
You are building the database platform for a multi-tenant application. The application will have one database per tenant and will have at least 30 tenants. Each tenant will have a separate resource group for billing purposes.
The application will require at least 10 GB of clustered columnstore indexes for each database.
You need to implement the database platform for the application. The solution must minimize costs.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
The application will require at least 10 GB of clustered columnstore indexes for each database.
You need to implement the database platform for the application. The solution must minimize costs.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
정답:
Explanation:
The Standard tier service allows for 1TB of data. Here 30 x 10 GB, 0.3 TB, is required.
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 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 master 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 master 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. Determine whether the solution meets stated goals.
Your company plans to use Microsoft Azure Resource Manager templates for all future deployments of SQL Server on Azure virtual machines.
You need to create the templates.
Solution: You create the desired SQL Server configuration in an Azure Resource Group, then export the Resource Group template and save it to the Templates Library.
Does the solution meet the goal?
Your company plans to use Microsoft Azure Resource Manager templates for all future deployments of SQL Server on Azure virtual machines.
You need to create the templates.
Solution: You create the desired SQL Server configuration in an Azure Resource Group, then export the Resource Group template and save it to the Templates Library.
Does the solution meet the goal?
정답: B
설명: (Fast2test 회원만 볼 수 있음)
You have a Microsoft SQL Server 2014 named SRV2014 that has a single tempdb database file. The tempdb database file is eight gigabytes (GB) in size.
You install a SQL Server 2016 instance named SQL Server 2016 by using default settings. The new instance has eight logical processor cores.
You plan to migrate the databases from SRV2014 to SRV2016.
You need to configure the tempdb database on SRV2016. The solution must minimize the number of future tempdb autogrowth events.
What should you do?
You install a SQL Server 2016 instance named SQL Server 2016 by using default settings. The new instance has eight logical processor cores.
You plan to migrate the databases from SRV2014 to SRV2016.
You need to configure the tempdb database on SRV2016. The solution must minimize the number of future tempdb autogrowth events.
What should you do?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
You deploy a new Microsoft Azure SQL Database instance to support a variety of mobile application and public websites.
You have the following requirements:
* You must be able to replicate the database to azure datacenter in other region geo-replication.
* Clients must only connect to the Azure SQL Datacenter by using contained database users.
* You must be able to move the database to other in the future.
* Only application in the 23.96.52.0-23.96.52.255 IP range are permitted to access the database.
* Only application settings for the instance must not provide access to any other Azure services.
You need to configured the firewall for the requirement.
Which three actions should you perform? Each correct answer presents part of the solution.
You have the following requirements:
* You must be able to replicate the database to azure datacenter in other region geo-replication.
* Clients must only connect to the Azure SQL Datacenter by using contained database users.
* You must be able to move the database to other in the future.
* Only application in the 23.96.52.0-23.96.52.255 IP range are permitted to access the database.
* Only application settings for the instance must not provide access to any other Azure services.
You need to configured the firewall for the requirement.
Which three actions should you perform? Each correct answer presents part of the solution.
정답: B,C,E
설명: (Fast2test 회원만 볼 수 있음)
You administer a Microsoft SQL Server 2014 database.
You need to ensure that the size of the transaction log file does not exceed 2 GB.
What should you do?
You need to ensure that the size of the transaction log file does not exceed 2 GB.
What should you do?
정답: B
You administer a Microsoft SQL Server 2016 instance.
You need to configure a new database to support FILETABLES.
What should you do? Choose all that apply.
You need to configure a new database to support FILETABLES.
What should you do? Choose all that apply.
정답: C,E,F
설명: (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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You use a Microsoft Azure SQL database as a data warehouse. The database is in the Standard service tier and has 400 elastic database throughput units (eDTUs).
You load data to the database by using Azure Data Factory.
You need to reduce the amount of time it takes to load the data.
Solution: You move the database to a Premium database that has 125 eDTUs.
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 use a Microsoft Azure SQL database as a data warehouse. The database is in the Standard service tier and has 400 elastic database throughput units (eDTUs).
You load data to the database by using Azure Data Factory.
You need to reduce the amount of time it takes to load the data.
Solution: You move the database to a Premium database that has 125 eDTUs.
Does this meet the goal?
정답: B
설명: (Fast2test 회원만 볼 수 있음)
A company plans to use a Microsoft Azure SQL Database instance to manage sensitive data.
The solution must allow data to be decrypted while in use but encrypted while at rest.
You need to ensure that the column are protected.
What should you use?
The solution must allow data to be decrypted while in use but encrypted while at rest.
You need to ensure that the column are protected.
What should you use?
정답: D
You are the database administrator in your company. You plan to create 10 identical environments that use SQL Server 2016 as a database engine. Each environment has the following custom requirements:
Three user databases must be preinstalled.
The tempdb database must contain eight data files that are 1024 MB each.
Trace flag 2371 must be turned at the instance level.
The solution must meet the following requirements:
The instance must be preconfigured.
No other database features are required in the future.
The solution must use the minimum administrative effort.
You need to prepare the environments. What should you do?
Three user databases must be preinstalled.
The tempdb database must contain eight data files that are 1024 MB each.
Trace flag 2371 must be turned at the instance level.
The solution must meet the following requirements:
The instance must be preconfigured.
No other database features are required in the future.
The solution must use the minimum administrative effort.
You need to prepare the environments. What should you do?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
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