2013微软MCITP 70-432题库：SQL Server 2008实施与维护资源管理

需积分: 9 2 浏览量更新于2024-07-25 收藏 1.61MB PDF 举报

"该资源是一份针对MCITP 70-432考试的题库，由henry在2013年8月10日通过考试后分享，包含了230道题目，专注于Microsoft SQL Server 2008的实施与维护。考试名为MSSQLServer2008ImplementationandMaintenance，要求的及格分数为700分，考试时长为100分钟，版本为1.0。题库中涉及到了如下的知识点： 1. 处理器资源管理 - 在问题1中，提到使用Resource Governor来管理SQL Server实例上的处理器资源。当部署新的应用App1时，它被分配到名为MyApp的工作负载组。考生需要了解如何通过sys.dm_os_performance_counters监控特定工作负载组（MyApp）的CPU使用情况，正确答案是A，即使用SQL Server Workload Group Stats性能对象的CPU usage%计数器。 2. 工作负载组监控 - 题目2进一步展示了在订单处理应用程序中管理员如何操作，可能涉及到工作负载组的配置和监控，以便确保资源的有效分配和性能优化。这表明考生需要熟悉工作负载组的功能和视图，如sys.resource_governor_workload_groups_catalog中的request_max_cpu_time_seccolumn，用于查看每个工作负载组的最大CPU时间限制。 3. 系统性能视图 - 题目中的sys.dm_os_performance_counter和sys.dm_resource_governor_workload_groups_dynamic_management_view都是关键的系统动态管理视图，它们提供了对SQL Server内部性能数据的深入了解，这对于理解和分析服务器性能、资源使用以及工作负载的管理至关重要。 4. SQL Server 2008数据库管理 - 作为MCITP 70-432的一部分，考生还需要具备对SQL Server 2008数据库的深入管理知识，包括事务处理、存储过程、索引优化、备份恢复策略等，这些都是考试中可能涵盖的内容。这份题库全面覆盖了432考试的内容，对于准备参加MCITP 70-432考试的考生来说，是一个宝贵的复习资料，可以帮助他们了解考试的重点和难点，并通过实践题目的解答提高实际操作能力。"

WHERE class_desc = OBJECT_ID('Sales.Table1')

AND grantee_principal_id = USER_ID('User1');

D. SELECT *

FROM sys.sysprotects

WHERE uid = USER_ID('User1')

AND id = OBJECT_ID('Sales.Table1');

Correct Answer: B

Section: (none)

Explanation

Explanation/Reference:

http://msdn.microsoft.com/en-us/library/ms176097(v=sql.105).aspx

QUESTION 15

You administer a Microsoft SQL Server 2008 R2 database installed along with the default settings.

You want to migrate a database from a SQL Server 2000 server that is being decommissioned. The

application executes a number of Windows command-line calls from stored procedures in the database.

You need to configure SQL Server 2008 R2 to allow command-line calls from the database.

Which three actions should you perform in sequence? (To answer, move the appropriate actions (steps)

from the list of actions to the answer area and arrange them in the correct order.)

[Note: TO ANSWER, Click "SELECT and PLACE". Press "Enter" when done.]

Select and Place:

C. USE Customers;

ALTER USER User1 WITH LOGIN = User1;

D. USE Customers;

ALTER LOGIN User1 WITH DEFAULT_DATABASE = Customers;

Correct Answer: C

Section: (none)

Explanation

Explanation/Reference:

___________________________________________________________

From MSDN: http://msdn.microsoft.com/en-us/library/ms176060.aspx

ALTER USER : Renames a database user or changes its default schema.

ALTER USER userName

WITH <set_item> [ ,...n ]

<set_item> ::=

NAME = newUserName | DEFAULT_SCHEMA = schemaName | LOGIN = loginName |

PASSWORD = 'password' [ OLD_PASSWORD = 'oldpassword' ]

Arguments:

userName

Specifies the name by which the user is identified inside this database.

Re-maps a user to another login by changing the user’s Security Identifier (SID) to match the login’s SID.

NAME = newUserName

Specifies the new name for this user. newUserName must not already occur in the current database.

DEFAULT_SCHEMA = schemaName

Specifies the first schema that will be searched by the server when it resolves the names of objects for this

user. Renames a database user or changes its default schema.

PASSWORD = 'password'

Specifies the password for the user that is being changed. Passwords are case-sensitive. Note: This

option is available only for contained users. See Contained Databases and sp_migrate_user_to_contained

(Transact-SQL) for more information.

OLD_PASSWORD ='oldpassword'

The current user password that will be replaced by 'password'. Passwords are case-sensitive.

OLD_PASSWORD is required to change a password, unless you have ALTER ANY USER permission.

Requiring OLD_PASSWORD prevents users with IMPERSONATION permission from changing the

password. Note: This option is available only for contained users.

___________________________________________________________

Remarks:

If DEFAULT_SCHEMA is left undefined, the user will have dbo as its default schema.

DEFAULT_SCHEMA can be set to a schema that does not currently occur in the database. Therefore, you

can assign a DEFAULT_SCHEMA to a user before that schema is created. DEFAULT_SCHEMA cannot

be specified for a user who is mapped to a Windows group, a certificate, or an asymmetric key.

Important:

The value of DEFAULT_SCHEMA is ignored if the user is a member of the sysadmin fixed server role. All

members of the sysadmin fixed server role have a default schema of dbo.

You can change the name of a user who is mapped to a Windows login or group only when the SID of the

new user name matches the SID that is recorded in the database. This check helps prevent spoofing of

Windows logins in the database.

The WITH LOGIN clause enables the remapping of a user to a different login. Users without a login, users

mapped to a certificate, or users mapped to an asymmetric key cannot be re-mapped with this clause.

Only SQL users and Windows users (or groups) can be remapped. The WITH LOGIN clause cannot be

used to change the type of user, such as changing a Windows account to a SQL Server login.

The name of the user will be automatically renamed to the login name if the following conditions are true.

The user is a Windows user.

The name is a Windows name (contains a backslash).

No new name was specified.

The current name differs from the login name.

Otherwise, the user will not be renamed unless the caller additionally invokes the NAME clause.

QUESTION 17

Note: This question is part of a series of questions that use the same or similar answer choices.

An answer choice may be correct for more than one question in the series. Each question is

independent of the other questions in this series. Information and details provided in a question

apply only to that question.

You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table.

The table has the following definition:

CREATE TABLE [OrderItems]

(OrderID INT NOT NULL,

OrderDate DATETIME NOT NULL,

OrderLine INT NOT NULL,

ProductID INT NOT NULL,

Quantity INT NOT NULL,

PriceEach MONEY NOT NULL,

);

Currently, the table is partitioned by year with each in its own filegroup.

You need to add a new partition for the upcoming year.

What should you do?

A. Remove the clustered index from the table.

Use the ALTER PARTITION FUNCTION … SPLIT RANGE statement.

Use the ALTER TABLE statement to remove the COLLATE option.

Execute the DBCC CLEANTABLE command on the OrderItems table.

E. Create a new Filegroup.

Create a new database file.

Use the ALTER PARTITION SCHEME statement along with NEXT USED clause.

Use ALTER INDEX REORGANIZE statement.

F. Create a new Filegroup.

Create a new database file.

Use the ALTER PARTITION SCHEME statement along with NEXT USED clause

Use ALTER PARTITION FUNCTION statement along with the SPLIT RANGE clause

G. Create a new table.

Use the ALTER TABLE statement along with the SWITCH PARTITION clause.

Use ALTER PARTITION FUNCTION statement along with the MERGE RANGE clause.

H. Create a new partition function.

Create a new partition scheme.

Add a clustered index to place the data onto the partition scheme.

I. Run the following statement:

CREATE PARTITION SCHEME SEC_FG

AS PARTITION FUNC_FG

ALL TO ( SECONDARY );

J. Run the following statement:

EXECUTE sp_tableoption

@TableNamePattern ='OrderItems',

@OptionName= 'PartitionByYear',

@OptionValue= 'true';.

Correct Answer: F

Section: (none)

Explanation

Explanation/Reference:

QUESTION 18

Note: This question is part of a series of questions that use the same or similar answer choices.

An answer choice may be correct for more than one question in the series. Each question is

independent of the other questions in this series. Information and details provided in a question

apply only to that question.

You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table.

The table has the following definition:

CREATE TABLE [OrderItems]

剩余133页未读，继续阅读

才华抛物线19

粉丝: 1
资源: 7

2013微软MCITP 70-432题库：SQL Server 2008实施与维护资源管理

MCITP最新题库 70-448.2013-08.31.139q.by_henry.PDF

MCITP中文教程.70-646.Windows.Server.2008.网管员自学宝典.part2

MCITP.Self-Paced.Training.Kit.(Exam 70-443).pdf

Microsoft.Press.MCITP.Self.Paced.Training.Kit.Exam.70-686.Oct.2010.pdf

MCITP.70-646.题库

Windows.Server.2008.70-646.网管员自学宝典MCITP教程part4.pdf

Windows.Server.2008.70-646.网管员自学宝典MCITP教程part2.pdf

Windows.Server.2008.70-646.网管员自学宝典MCITP教程part1.pdf

Windows.Server.2008.70-646.网管员自学宝典MCITP教程part3.pdf

MCITP题库全集 70-643.v1.21.by.JW.98q

最新资源