originale Fragen70-450 Microsoft it-pruefungen

Alle unsere Online-Training Werkzeuge sind mit den wechselnden Prüfungszielen verfügbar, so dass Sie sicher sein, immer für Ihre Business Solutions mit den neuesten und origninalsten Praxisprüfungen vorzubereiten und unsere Business Solutions kann aktualisiert werden und Sie bekommen Werkzeuge zu günstigen Preisen für Ihren eigenen Komfort.

70-450 PRO:MS SQL Serv 08,Design,Optimize, and Maintain DB Admin Solution Vorbei an den Praxisprüfungen ist es keineswegs schon schneller und einfacher, jetzt mit spezifischen Fragen und Antworten, mit aus den chaotisch Business Solutions, die sein oft falsch kann. grenzenlose Prüfungen sind nicht nur die weniger kostspielige Methode, sondern um mit sich Rückgriff auf Praxisprüfung passieren.

originale Fragen70-450 Microsoft it-pruefungen

QUESTION 1
You administer a SQL Server 2008 instance for your company. Your company has a team of database administrators.

A team of application developers create SQL Server 2008 Integration Services (SSIS) packages on the test server in a shared project. One of the packages requires a fixed cache file. On completion of development, the packages will be deployed to the production server.

Only the database administrators can access the production server.

You need to ensure that the application developers can deploy the project successfully to the production server.

What should you do?

A. Use the Import and Export Wizard to save packages.
B. Create a deployment utility for the SSIS project.
C. Create a direct package configuration for each package.
D. Create an indirect package configuration for all packages.

Answer: B

Explanation/Reference:
—Jeff—
This is a strange question. I think the underlying lession is that deployment utilities make SSIS package deployment easier, especially in situations where limited access may be available. Direct and indirect package configurations are explained on MSDN.

Official source: http://msdn.microsoft.com/en-us/library/ms141682.aspx

QUESTION 2
You administer a SQL Server 2008 infrastructure. You plan to design an infrastructure for a new application.

The application has the following requirements:

Users can connect to an instance named SQLSERVER1.
SQLSERVER1 is linked to a server named SQLSERVER2.
SQLSERVER1 and SQLSERVER2 run on different computers.
The SQL Server instances use only Windows authentication.

You need to configure the infrastructure to ensure that the distributed queries are executed in the Windows security context of the login.

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A. Configure all servers to use the Shared Memory network protocol.
B. Register a server principal name (SPN) for SQLSERVER1 and SQLSERVER2.
C. Use the local computer account as a service account for SQLSERVER1 and SQLSERVER2.
D. Create a map for each SQL login from SQLSERVER1 to SQLSERVER2 and use the
impersonate option.
E. Ensure that the two instances use the same Windows account for the Microsoft SQL
Service. Create the link so that each account uses the current security context.

Answer: BD

Explanation/Reference:

http://msdn.microsoft.com/en-us/library/ms189580%28v=SQL.100%29.aspx

QUESTION 3
You administer two SQL Server 2008 instances named Instance1 and Instance2. Instance1 contains the Sales database, and Instance2 contains the Accounts database.

A procedure in the Sales database starts a transaction. The procedure then updates the Sales.dbo.Order table and the Accounts.dbo.OrderHistory table through a linked server.

You need to ensure that the transaction uses a two-phase commit.

What should you do?

A. Configure the linked server to use distributed transactions.
B. Configure a Service Broker to enable the appropriate transaction control.
C. Ensure that the linked server is appropriately configured for delegation.
D. Ensure that the linked server is appropriately configured for impersonation.

Answer: A

originale Fragen70-450 Microsoft it-pruefungen