Echte Fragen 70-450 Microsoft Fragenkatalog
it-pruefungen bietet qualitativ hochwertige Prüfungsfragen und Antworten für die Vorbereitung auf Ihre IT-Zertifizierungsprüfungen, die alle Examfragen und Examsantworten abdecken. Bei zertifizierung-portal.de stehen Ihnen zahlreiche kostenlose Zertifizierungsfragen von IT Prüfungen zur Verfügung. Die neuesten Unterlagen und Simulationssoftware bei zertifizierung-portal.de machen die IT Prüfungen ganz leicht für Sie. Im Falle eines Scheiterns erhalten Sie nämlich die Gebühr zurückerstattet
70-450 PRO:MS SQL Serv 08,Design,Optimize, and Maintain DB Admin Solution IT Prüfung,IT Zertifizierung,Prüfungsfrage, originale Fragen,Antorten, Fragenkataloge,Prüfungsunterlagen, Prüfungsfragen, Prüfungsfrage, Testfagen, Testantworten, Vorbereitung, Zertifizierungsfragen, Zertifizierungsantworten, Examsfragen, Antworten, echte Fragen
Echte Fragen 70-450 Microsoft Fragenkatalog
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
Echte Fragen 70-450 Microsoft Fragenkatalog
