070-458 試験問題を無料オンラインアクセス

DRAG DROP
You are a database administrator of a Microsoft SQL Server 2012 environment. The environment contains two servers named SQLServer01 and SQLServer02. The database Contoso exists on SQLServer01.
You plan to mirror the Contoso database between SQLServer01 and SQLServer02 by using database mirroring.
You need to prepare the Contoso database for database mirroring.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

正解：

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 are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system.
Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes.
You need to establish the best technique to log these invalid rows while minimizing the amount of development effort.
What should you do?

• A.Run the package by using the dtexec /dumperror /conn command.
• B.Run the package by using the dtexec /rep /conn command.
• C.Use the dtutil /copy command.
• D.Create a reusable custom logging component.
• E.Use the gacutil command.
• F.Create an OnError event handler.
• G.Deploy the package by using an msi file.
• H.Use the Project Deployment Wizard.
• I.Add a data tap on the output of a component in the package data flow.
• J.Deploy the package to the Integration Services catalog by using dtutfl and use SQL Server to store the configuration.
• K.Run the package by using the dtexecui.exe utility and the SQL Log provider.

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You administer a SQL Server 2012 server that contains a database named SalesDb. SalesDb contains a schema named Customers that has a table named Regions. A user named userA is a member of a role named Sales.
UserA is granted the Select permission on the Regions table. The Sales role is granted the Select permission on the Customers schema.
You need to ensure that UserA is disallowed to select from any of the tables in the Customers schema.
Which Transact-SQL statement should you use?

• A.EXEC sp_addrolemember 'Sales', 'UserA'
• B.DENY SELECT ON Object::Regions FROM Sales
• C.EXEC sp_droprolemember 'Sales', 'UserA'
• D.DENY SELECT ON Schema::Customers FROM UserA
• E.DENY SELECT ON Schema::Customers FROM Sales
• F.REVOKE SELECT ON Schema::Customers FROM Sales
• G.DENY SELECT ON Object::Regions FROM UserA
• H.REVOKE SELECT ON Schema::Customers FROM UserA
• I.REVOKE SELECT ON Object::Regions FROM Sales
• J.REVOKE SELECT ON Object::Regions FROM UserA

You administer a Microsoft SQL Server 2012 database that has Trustworthy set to on. You create a stored procedure that returns database-level information from Dynamic Management Views.
You grant User1 access to execute the stored procedure.
You need to ensure that the stored procedure returns the required information when User1 executes the stored procedure. You need to achieve this goal by granting the minimum permissions required.
What should you do? Choose all that apply.

• A.Create a SQL Server login that has VIEW SERVER STATE permissions. Modify the stored procedure to include the EXECUTE AS {newlogin} statement.
• B.Grant the VIEW SERVER STATE permission to User1.
• C.Grant the db_datareader role on the database to User1.
• D.Move the stored procedure to the User1 schema.
• E.Modify the stored procedure to include the EXECUTE AS OWNER statement. Grant VIEW SERVER STATE permissions to the owner of the stored procedure.

You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads data from a source system that uses the SQL Server change data capture (CDC) feature.
You have added a CDC Source component to the data flow to read changed data from the source system.
You need to add a data flow transformation to redirect rows for separate processing of insert, update, and delete operations.
Which data flow transformation should you use?

• A.Pivot
• B.Merge Join
• C.DQS Cleansing
• D.CDC Splitter