Microsoft MCTS 070-432

Microsoft MCTS 070-432 Microsoft

www.it-pruefungen.ch hilft Ihnen mit hochwertigenUnterlagen und Software, die Fragen und Antworten Zertifizierungsprüfung zu bestehen. Mit Hilfe der www.it-pruefungen.ch sind Sie sicher, die Zertifizierung mit einem hohen Punkt zu bestehen und den Erfolg im IT-Bereich erobern.

070-432 TS:MS SQL Server 2008,Implementation and Maintenance Vorbereitung für IT-Prüfung hat eine Reihe von spezialisierten Zertifizierungsprüfung im Zusammenhang mit einem bestimmten Gebiet, und so ist die Wahl der richtigen Training Produkt ist sehr wichtig.

Microsoft MCTS 070-432 Microsoft

QUESTION 1
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database.

Now you are in charge of a SQL Server 2008 instance. There is a database developer who is named UserJack.

UserJack views the definitions of all database objects in a database to read data from all user-defined tables, views, and table-valued functions. For UserJack, you have to assign the required permissions.

Besides this, you must make sure that other developers can also be given the same permissions, but this should be achieved by executing as little Transact-SQL statements as possible.

In the options below, which Transact-SQL statements should you execute?

A. GRANT VIEW ANY DEFINITION TO UserJack;EXEC sp_addrolemember ‘db_datareader’, ‘UserJack’;
B. CREATE ROLE Developers;GRANT CONTROL TO Developers;EXEC sp_addrolemember ‘Developers’, ‘UserJack’;
C. CREATE ROLE Developers;GRANT VIEW DEFINITION TO Developers;GRANT SELECT TO Developers;EXEC sp_addrolemember ‘Developers’, ‘UserJack’;
D. CREATE ROLE Developers;EXEC sp_addrolemember ‘sp_dbdatareader’, ‘Developers’;EXEC sp_addrolemember ‘sp_dbddladmin’, ‘Developers’;EXEC sp_addrolemember ‘Developers’,
‘UserJack’;

Answer: C

Explanation/Reference:
Create ROLE: Roles are database-level securables. After you create a role, configure the database-level permissions of the role by using GRANT, DENY, and REVOKE. To add members to a database role, use the sp_addrolemember stored procedure.
VIEW DEFINITION:The VIEW DEFINITION permission lets a user see the metadata of the securable on which the permission is granted. However, VIEW DEFINITION permission does not confer access to the securable itself. For example, a user that is granted only VIEW DEFINITION permission on a table can see metadata related to the table in the sys.objects catalog view. However, without additional permissions such as SELECT or CONTROL, the user cannot read data from the table.
GRANT SELECT: Grants permissions on a securable to a principal.

QUESTION 2
You administer a SQL Server 2008 instance that contains a database named DB1.

A table named Sales.Table1 exists in the Sales schema.
You need to move the Sales.Table1 table to a new schema named Billing.

Which Transact-SQL statement should you execute?

A. ALTER SCHEMA Billing TRANSFER Sales.Table1;
B. ALTER USER Sales WITH DEFAULT_SCHEMA = Billing;
C. ALTER AUTHORIZATION ON Sales.Table1 TO Billing;
D. ALTER TABLE Sales.Table1 SWITCH TO Billing.Table1;

Answer: A

QUESTION 3
You work for a company which uses SQL Server 2008. You are the administrator of the
company database and in charge of three SQL Server 2008 instances.

All the instances run on their independent server. The three instances are respectively named InstanceA, InstanceB, and InstanceC. Between InstanceA and InstanceB, you configure a mirroring mission-critcal database. InstanceA currently acts as the Principal and InstanceC acts as the witness. You intend to apply a patch to both servers as soon as possible, the patch needs to restart the server. You must make sure that the database is online on the partner that currently does not apply the patch and during this time the database does not failover to the other partner.

So what action should you perform to achieve this goal?

A. First, you should stop the mirroring session. Second you apply the patch to the server that
runs InstanceB. Third, you should resume the mirroring session. Fourth, you should manually
failover the mirroring session. At last, you should apply the patch to the server that runs
Instance1.
B. First, you should apply the patch to the server that runs InstanceB. Second you apply the
patch to the server that runs InstanceA.
C. First, you should apply the patch to the server that runs InstanceB. Second you failover
the mirroring session manually. At last apply the patch to the server that runs InstanceA
D. First, you should remove the mirroring session. Second you apply the patch to the server
that runs InstanceB. Third, you should apply the patch to the server that runs Instance1. At
last re-establish the mirroring session.

Answer: A

Microsoft MCTS 070-432 Microsoft