Microsoft 70-450 SQL Server 2008数据库管理员考试题库

需积分: 10 27 浏览量更新于2024-07-26 收藏 468KB PDF 举报

本资源是一份针对Microsoft认证考试70-450的题库，该考试主要聚焦于SQL Server的相关知识。考试版本为2012年8月29日，由Conner提供，适用于专业级的SQL Server 2008数据库管理员。题库包含100多道题目，旨在测试考生在数据库管理和优化方面的技能。考试时间为120分钟，文件版本为9.5。题库分为多个部分，包括Part1至Part11，每个部分可能涵盖了不同的主题或技能模块。例如，如果看到的这部分是"QUESTION1"，它涉及到了数据库设计与存储管理。具体到问题1，情景设定为数据库中有一个名为EmployeeData的表，其中包含一个Profile列，该列用于存储Microsoft Office Word 2003文档。问题关注如何在满足减少空间利用和保持合理性能的前提下处理这个数据。答案选项： A. ROW compression（行压缩）：适用于大量重复数据，但可能不适合文档这样的复杂内容，因为每条记录的数据结构不同。 B. FILESTREAM storage with NTFS compression（文件流存储和NTFS压缩）：这是推荐的做法，文件流将大对象数据存储在非SQL Server文件系统上，可以利用操作系统级别的压缩，既节省空间又允许高效检索。 C. PAGE_LEVEL compression（页面级别压缩）：适合于大量相似数据，但对于文档内容来说，可能不适用，且对性能的影响可能不如文件流存储。 D. CLR user-defined type（用户定义的.NET类型）：主要用于存储自定义数据结构，不适合存储文档。正确答案是B，这意味着在实际场景中，作为专业数据库管理员，应选择利用文件流存储并结合NTFS压缩来管理EmployeeData表中的Profile列，以达到最优的空间利用和性能。这部分知识点深入讲解了SQL Server中关于数据存储和管理的最佳实践，特别是对于大型对象数据（如文档）的高效处理策略。考生在准备70-450考试时，需要理解并能够应用这些技术来解决实际问题。此外，后续的题目可能还会涉及查询优化、备份恢复、事务管理、安全性等多个数据库管理的核心领域。

QUESTION 19

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named

Wiikigo.

There is a team of database administrators in your company.

SQL Server 2008 Integration Services (SSIS) packages are created on the test server in a shared

project by a team of application developers. A fixed cache file is required by one of the packages.

The company will deploy the packages to the production server on completion of development.

The production server is available only to the database administrators.

Since you are the technical support, you need to confirm that the project can be deployed

successfully to the production server by the application developers.

Which action 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 configuration 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 configuration should be created for all packages.

Correct Answer: C

Section: (none)

Explanation

Explanation/Reference:

The first step in deploying packages is to create a deployment utility for an Integration Services

project. The deployment utility is a folder that contains the files you need to deploy the packages

in an Integration Services project on a different server. The deployment utility is created on the

computer on which the Integration Services project is stored.

You create a package deployment utility for an Integration Services project by first configuring the

build process to create a deployment utility, and then building the project. When you build the

project, all packages and package configurations in the project are automatically included. To

deploy additional files such as a Fteadme file with the project, place the files in the

Miscellaneous folder of the Integration Services project. When the project is built, these files are

also automatically included.

You can configure each project deployment differently. Before you build the project and create

the package deployment utility, you can set the properties on the deployment utility to customize

the way the packages in the project will be deployed. For example, you can specify whether

package configurations can be updated when the project is deployed. To access the properties of

an Integration Services project, right-click the project and click Properties.

The following table lists the deployment utility properties.

When you build an Integration Services project, a manifest file, qproject

name>.SS|SDep|oymentlv1anifest.xmI, is created and added, together with copies of the project

packages and package dependencies, to the bintlileployment folder in the project, or to the

location specified in the DepIoymentOutputPath property. The manifest file lists the packages,

the package configurations, and any miscellaneous files in the project.

The content 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 configuration files saved to the deployment folders will be

deleted.

QUESTION 20

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named

Wiikigo.

A 32-bit version is utilized by the instance on a Windows Server 2008 64-bit server. You activate the awe

enabled

option. 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 on

the same hardware.

A data collector type that proper information 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

Correct Answer: B

Section: (none)

Explanation

Explanation/Reference:

Performance Counters collector is used as it contains information about the CPU, Memory and

Disk usage of the SQL Server instance. As we need to know if it will o benefit to migrate to 64 bit

version of SQL Server.

QUESTION 21

You are a professional level SQL Sever 2008 Database Administrator.

A database is hosted by the instance and the database is configured by utilizing high-safety

mirroring operation mode along with a witness server. A memory failure is experienced by the

witness server; therefore the server will be offline for five hours. The mirroring strategy should be

reset to cut the risk of database unavailability to the least level.

Which action should you perform to finish the task?

A. To finish the task, database mirroring should be paused.

B. To finish the task, the witness server should be moved from the mirroring session.

C. To finish the task, asynchronous operating mode should be utilized.

D. To finish the task, database mirroring should be removed.

Correct Answer: B

Section: (none)

Explanation

Explanation/Reference:

Removing the witness will keep the mirroring session, but without automatic failover

You can remove the witness from a session if you are connected to the current principal server.

To remove the witness

1. Connect to the principal server instance and, in the Object Explorer pane, click the server

name to expand the server tree.

2. Expand Databases, and select the database whose witness you want to remove.

3. Flight-click the database, select Tasks, and then click Mirror. This opens the Mirroring page

of the Database Properties dialog box.

4. To remove the witness, delete its server network address from the Witness field.

Note lf you switch from high-safety mode with automatic failover to high-performance mode, the

Witness field is automatically cleared.

QUESTION 22

You are a professional level SQL Sever 2008 Database Administrator.

A large financial database is hosted by the instance. The backup strategies listed below are contained by

the database:

First, the performance of a full database backup is implemented once a week.

Secondly, the performance of a differential backup is implemented every day.

Thirdly, the performance of a transaction log backup is implemented every hour.

An end-of-year batch process should be implemented, and the process takes two hours to run.

About five percent of data within the database will be changed by the batch process.

Since you are the technical support, you are required to make sure that the batch operation can be rolled

back

in the shortest time, if the batch process is not approved by the Finance department.

What should you do first before start the batch process?

A. You should perform a differential backup.

B. You should create a marked transaction. And then you should perform a transaction log backup.

C. You should create a database snapshot.

D. You should record the time before the batch operation. And then you should perform a transaction log

Correct Answer: C

Section: (none)

Explanation

Explanation/Reference:

Reasons to take database snapshots include:

· Maintaining historical data for report generation.

Because a database snapshot provides a static view of a database, a snapshot can extend

access to data from a particular point in time. For example, you can create a database

snapshot at the end of a given time period (such as a financial quarter} tor later reporting. You

can then run end-of-period reports on the snapshot. If disk space permits, you can also

maintain end-of-period snapshots indefinitely, allowing queries against the results from these

periods; for example, to investigate organizational performance.

- Using a mirror database that you are maintaining for availability purposes to offload reporting.

Using database snapshots with database mirroring permits you to make the data on the mirror

server accessible for reporting. Additionally, running queries on the mirror database can free

up resources on the principal. For more information, see Database Mirroring and Database

Snapshots.

- Safeguarding data against administrative error.

- Before doing major updates, such as a bulk update or a schema change,

create a database snapshot on the database protects data. lf you make a

mistake, you can use the snapshot to recover by reverting the database

to the snapshot. Fleverting is potentially much faster for this purpose

than restoring from a backup; however; you cannot roll forward afterward.

QUESTION 23

You are a professional level SQL Sever 2008 Database Administrator.

They are respectively named Ins01, Ins02, Ins03 and Ins04. A single database application is hosted by

each instance.

All four instances should be removed to a new SQL Server failover cluster. You can see the configuration of

the

four instances from the table listed below:

All the four instances are sufficiently optimized, and there are no spare CPU cycles or extra memory in

the instances.

All four databases will be hosted by the new cluster on a single virtual cluster IP address.

Since you are the technical support, you are required to set the new cluster to handle the workload of all

the

database applications with the least amount of hardware resources.

From the four cluster configuration, which one should be utilized?

A. Four-node active/active/active/active cluster should be utilized and a minimum of 9 processors and a

25-GB memory are contained by each node.

B. Two-node active/passive cluster should be utilized and a minimum of 18 processors and a 50-GB

memory are contained by each node.

C. Two-node active/active cluster should be utilized and a minimum of 9 processors and a 25-GB memory

are contained by each node.

D. Four-node active/active/active/passive cluster should be utilized and a minimum of 18 processors and a

50-GB memory are contained by each node.

Correct Answer: B

Section: (none)

Explanation

Explanation/Reference:

To-use the least amount ot hardware resources, we will create a single two nodes Active-Passive

cluster.

As all the instances should be able to run without impact, we will sum the number of CPU; here it

is 18 CPU for each node

Memory needed: 18 GB + 8 GB + 16 GB + 8 GB = 48 GB + 2 GB forthe OS = 50 GB

QUESTION 24

You are a professional level SQL Sever 2008 Database Administrator.

An instance runs on a computer, and the computer has eight quad-core processors and 128-GB RAM.

The instance is utilized by four different applications. Not only a low number of CXPACKET waits but also a

large

number of lazy writer waits are experienced by the instance. The performance of the instance should be

optimized.

Which action will you perform to accomplish the goal?

A. To accomplish the goal, software non-uniform memory access (soft-NUMA) should be configured.

To accomplish the goal, the Resource Governor should be configured.

剩余82页未读，继续阅读

伤心一瞬间

粉丝: 0
资源: 4

Microsoft 70-450 SQL Server 2008数据库管理员考试题库

微软考试70-450\Microsoft.CertifyMe.70-450.v2011-05-19.by.Sharon.55q.vce

Microsoft.CertifyMe.70-432.v2012-08-29

Microsoft.CertifyMe.70-451.v2012-08-29.by.Conner

微软数据库考证题库Microsoft.CertifyMe.70-432.v2012-10-04.by.Anonymous

Microsoft.CertifyMe.70-640.v2012-03-16.by.alex.255q

Microsoft.CertifyMe.70-511.v2012-03-14.by.Reymon.131q.pdf

微软70528最新题库（4.21）Microsoft.CertifyMe.70-528.v2011-04-21

Microsoft.CertifyMe.70-503.v2010-05-25.by.Gamede.91q.vce

Microsoft.CertifyMe.70-293

Microsoft.CertifyMe.70-298

最新资源