微软mcitp认证70-450考试：列几个样题和答案解析16-20
QUESTIo n 16
You are a professio nal level SQL Sever 2008 Database Administrator in an internatio nal corporatio n named Wiikigo.
You are experienced in managing databases in an enterprise-level organizatio n, optimizing and sustaining the database life cycle. In the company, your job is to implement solutio ns o n security, troubleshooting, deployment and optimizatio n.
A SQL Server 2008 infrastructure is managed by you. A corporate backup and recovery strategy that has to be validated is designed.
You are required to make sure that any single database can be restored successfully from a severe failure, and during the restoratio n, a backup data center should not be required in a different locatio n.
Which three actio ns should be co ntained by your solutio n? (Choose more than o ne)
A. All SQL Server instances should be installed o n a failover cluster.
B. o ne list of all Windows logins and passwords should be sustained.
C. All backup media offsite should be stored.
D. SQL login accounts and credentials should be scripted.
E. The administrative processes and applicatio n access requirements should be documented.
QUESTIo n 16
Answer: ADE
Explanatio n/Reference:
QUESTIo n 17
You are a professio nal level SQL Sever 2008 Database Administrator in an internatio nal corporatio n named Wiikigo.
You are experienced in managing databases in an enterprise-level organizatio n, optimizing and sustaining the database life cycle. In the company, your job is to implement solutio ns o n security, troubleshooting, deployment and optimizatio n.
A SQL Server 2008 instance is managed by you. A new database should be deployed, and the capacity requirements listed below should be satisfied.
There should be 275 GB for the database data file, while there should be 50 GB for the transactio n log file.
There are six 100-GB disk drives which are accessible for the database in the storage array.
The six disks are attached to a redundant array of independent disks (RAID) co ntroller, and the co ntroller supports RAID levels 0, 1, 5, and 10.
Since you are the technical support, you are required to maximize the write performance of the transactio n log.
In additio n, you should protect the database and transactio n log files, when a drive fails.
The storage system should be designed.
From the following four storage co nfiguratio n, which o ne should you utilize?
A. A single RAID 5 volume should be utilized.
B. A RAID 1 volume and a RAID 5 volume should be utilized.
C. A single RAID 10 volume should be utilized.
D. A RAID 0 volume and a RAID 5 volume should be utilized.
QUESTIo n 17
Answer: B
Explanatio n/Reference:
You have to
"maximize the write performance of the transactio n log."
"you should protect the database and transactio n log files, when a drive fails"
To maximimza the perf of the transactio n log and have it protected, for this, you should use the raid 1, because it is a disk mirror and the size is 50GB, the half of the 100GB, but you need two disks for this. Then it will o nly reamins four disks, but you can't have RAID 1 for the data files as the data file is 275GB. So, RAID 5 is the o nly solutio n.
QUESTIo n 18
You are a professio nal level SQL Sever 2008 Database Administrator in an internatio nal corporatio n named Wiikigo.
You are experienced in managing databases in an enterprise-level organizatio n, optimizing and sustaining the database life cycle.
In the company, your job is to implement solutio ns o n security, troubleshooting, deployment and optimizatio n.
SQL Server 2008 servers o n a single site are managed by you. Two SQL Server 2008 instances are co ntained by the site.
o ne is an Enterprise Editio n server, and it is o n a server that has a redundant array of independent disks (RAID) 10 disk system.
The other is a Standard Editio n server, and it is o n a server that has a RAID 5 disk system.
A single applicatio n is hosted by each instance.
A high-availability solutio n should be recommended for the site to satisfy the business requirements listed below.
First, the solutio n can be implemented o n the current systems.
Seco ndly, the database is available with least downtime.
Thirdly, Data loss should be cut to the least.
Fourthly, the existing system should be with least impact.
Which solutio ns should be utilized to finish the task? (Choose more than o ne)
A. To finish the task, Log shipping should be utilized.
B. To finish the task, Failover clustering should be utilized.
C. To finish the task, Replicatio n should be utilized.
D. To finish the task, Database snapshot should be utilized.
QUESTIo n 18
Answer: AC
Explanatio n/Reference:
Failover clustering is not possible, because the two system are not o n the same array of disk and furthermore, you have to implement it o n the current system.
Database snapshot is not o ne HA solutio n, beacuse it is stored o n the same server.
Replicatio n and Log shipping are both answering to the four requirements.
QUESTIo n 19
You are a professio nal level SQL Sever 2008 Database Administrator in an internatio nal corporatio n named Wiikigo.
You are experienced in managing databases in an enterprise-level organizatio n, optimizing and sustaining the database life cycle.
In the company, your job is to implement solutio ns o n security, troubleshooting, deployment and optimizatio n.
A SQL Server 2008 instance of your company is managed by you. There is a team of database administrators in your company.
SQL Server 2008 Integratio n Services (SSIS) packages are created o n the test server in a shared project by a team of applicatio n developers. A fixed cache file is required by o ne of the packages.
The company will deploy the packages to the productio n server o n completio n of development. The productio n server is available o nly to the database administrators.
Since you are the technical support, you need to co nfirm that the project can be deployed successfully to the productio n server by the applicatio n developers.
Which actio n will you perform to achieve the goal?
A. To achieve the goal, the Import and Export Wizard should be utilized to save packages.
B. To achieve the goal, a direct package co nfiguratio n should be created for each package.
C. To achieve the goal, a deployment utility should be created for the SSIS project.
D. To achieve the goal, an indirect package co nfiguratio n should be created for all packages.
QUESTIo n 19
Answer: C
Explanatio n/Reference:
The first step in deploying packages is to create a deployment utility for an Integratio n Services project. The deployment utility is a folder that co ntains the files you need to deploy the packages in an Integratio n Services project o n a different server. The deployment utility is created o n the computer o n which the Integratio n Services project is stored.
You create a package deployment utility for an Integratio n Services project by first co nfiguring the build process to create a deployment utility, and then building the project. When you build the project, all packages and package co nfiguratio ns in the project are automatically included. To deploy additio nal files such as a Readme file with the project, place the files in the Miscellaneous folder of the Integratio n Services project. When the project is built, these files are also automatically included.
You can co nfigure each project deployment differently. Before you build the project and create the package deployment utility, you can set the properties o n the deployment utility to customize the way the packages in the project will be deployed. For example, you can specify whether package co nfiguratio ns can be updated when the project is deployed. To access the properties of an Integratio n Services project, right-click the project and click Properties.
The following table lists the deployment utility properties.
Property Descriptio n
AllowCo nfiguratio nChange A value that specifies whether co nfiguratio ns can be updated during deployment.
CreateDeploymentUtility A value that specifies whether a package deployment utility is created when the project is built. This property must be True to create a deployment utility.
DeploymentOutputPath The locatio n, relative to the Integratio n Services project, of the deployment utility.
When you build an Integratio n Services project, a manifest file, <project name>.
SSISDeploymentManifest.xml, is created and added, together with copies of the project packages and package dependencies, to the bin\Deployment folder in the project, or to the locatio n specified in the DeploymentOutputPath property. The manifest file lists the packages, the package co nfiguratio ns, and any miscellaneous files in the project.
The co ntent of the deployment folder is refreshed every time that you build the project. This means that any file saved to this folder that is not copied to the folder again by the build process will be deleted. For example, package co nfiguratio n files saved to the deployment folders will be deleted.
QUESTIo n 20
You are a professio nal level SQL Sever 2008 Database Administrator in an internatio nal corporatio n named Wiikigo.
You are experienced in managing databases in an enterprise-level organizatio n, optimizing and sustaining the database life cycle.
In the company, your job is to implement solutio ns o n security, troubleshooting, deployment and optimizatio n.
A SQL Server 2008 instance is managed by you. A 32-bit versio n is utilized by the instance o n a Windows Server 2008 64-bit server. You activate the awe enabled optio n.
A predictable increase in query activity will be experienced by the instance. You are required to figure out the most proper and beneficial time to have the databases migrated to a 64-bit SQL Server 2008 server o n the same hardware.
A data collector type that proper informatio n is provided should be identified.
What kind of collector should you utilize?
A. You should utilize SQL Trace collector
B. You should utilize Performance Counters collector
C. You should utilize T-SQL Query collector
D. You should utilize Query Activity collector
QUESTIo n 20
Answer: B
Explanatio n/Reference:
Performance Counters collector is used as it co ntains informatio n about the CPU, Memory and Disk usage of the SQL Server instance. As we need to know if it will be benefit to migrate to 64 bit versio n of SQL Server.
收集运行 SQL Server 2008 的计算机上的特定性能计数器信息。用此类数据作为故障排除或容量规划的依据。
32转移到64