Microsoft 70-458 Online Practice Questions and Exam Preparation

Microsoft 70-458 Online Questions & Answers

• Question 21:

  You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS).

  You need to complete the post-installation configuration.

  A. Install ADOMD.NET.
  B. Run the Configuration component in the Data Quality Client.
  C. Run the DQSInstaller.exe command.
  D. Make the data available for DQS operations.
  C. Run the DQSInstaller.exe command.

• Question 22:

  You are creating a Data Quality Services (DQS) solution. You must provide statistics on the accuracy of the data.

  You need to use DQS profiling to obtain the required statistics.

  Which DQS activity should you use?

  A. Cleansing
  B. Knowledge Discovery
  C. Matching Policy
  D. Matching
  A. Cleansing

• Question 23:

  You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse. The package consists of several data flow tasks.

  The package experiences intermittent errors in the data flow tasks. If any data flow task fails, all package error information must be captured and written to a SQL Server table by using an OLE DB connection manager.

  You need to ensure that the package error information is captured and written to the table.

  A. Use an event handler for OnError for the package.
  B. Use an event handler for OnError for each data flow task.
  C. Use an event handler for OnTaskFailed for the package.
  D. View the job history for the SQL Server Agent job.
  E. View the All Messages subsection of the All Executions report for the package.
  F. Store the System::SourceID variable in the custom log table.
  G. Store the System::ServerExecutionID variable in the custom log table.
  H. Store the System::ExecutionInstanceGUID variable in the custom log table.
  I. Enable the SSIS log provider for SQL Server for OnError in the package control flow.
  J. Enable the SSIS log provider for SQL Server for OnTaskFailed in the package control flow.
  I. Enable the SSIS log provider for SQL Server for OnError in the package control flow.

• Question 24:

  You are developing a SQL Server Integration Services (SSIS) package that downloads data from a Windows Azure SQL Database database.

  A stored procedure will be called in an Execute SQL task by using an ODBC connection. This stored procedure has only the rustomerlD parameter of type INT.

  A project parameter named CustID will be mapped to the stored procedure parameter @CustomerID.

  You need to ensure that the value of the CustID parameter is passed to the @CustomerID stored procedure parameter.

  In the Parameter Mapping tab of the Execute SQL task editor, how should you configure the parameter? (To answer, drag the appropriate option or options to the correct location or locations in the answer area.)

  Select and Place:

  

  

• Question 25:

  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.

  A. Pivot
  B. Merge
  C. Audit
  D. CDC Splitter
  D. CDC Splitter

• Question 26:

  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 the following requirements are met:

  Which Transact-SQL statement should you use?

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

• Question 27:

  You administer a Microsoft SQL Server 2012 database instance.

  You plan to migrate the database to Windows Azure SQL Database. You verify that all objects contained in the database are compatible with Windows Azure SQL Database.

  You need to ensure that database users and required server logins are migrated to Windows Azure SQL Database.

  A. Back up the database from the local server and restore it to Windows Azure SQL Database.
  B. Use the Copy Database wizard.
  C. Use the Database Transfer wizard.
  D. Use SQL Server Management Studio to deploy the database to Windows Azure SQL Database.
  D. Use SQL Server Management Studio to deploy the database to Windows Azure SQL Database.

• Question 28:

  You are developing a SQL Server Integration Services (SSIS) project with multiple packages to copy data to a Windows Azure SQL Database database. An automated process must validate all related Environment references, parameter data types, package references, and referenced assemblies. The automated process must run on a regular schedule.

  You need to establish the automated validation process by using the least amount of administrative effort.

  A. Use an event handler for OnError for the package.
  B. Use an event handler for OnError for each data flow task.
  C. Use an event handler for OnTaskFailed for the package.
  D. View the job history for the SQL Server Agent job.
  E. View the All Messages subsection of the All Executions report for the package.
  F. Store the System::SourceID variable in the custom log table.
  G. Store the System::ServerExecutionID variable in the custom log table.
  H. Store the System::ExecutionInstanceGUID variable in the custom log table.
  I. Enable the SSIS log provider for SQL Server for OnError in the package control flow.
  J. Enable the SSIS log provider for SQL Server for OnTaskFailed in the package control flow.
  N

• Question 29:

  You administer a Microsoft SQL Server 2012 database named Contoso that contains a single user-defined database role namedBillingUsers.

  All objects in Contoso are in the dbo schema.

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  D. Option D

• Question 30:

  You administer a Microsoft SQL Server 2012 database.

  The database is backed up according to the following schedule:

  

  Daily full backup at 23:00 hours.

  

  Differential backups on the hour, except at 23:00 hours.

  

  Log backups every 10 minutes from the hour, except on the hour.

  The database uses the Full recovery model.

  A developer accidentally drops a number of tables and stored procedures from the database between 22:40 hours and 23:10 hours. You perform a database restore at 23:30 hours to recover the dropped table.

  You need to restore the database by using the minimum amount of administrative effort. You also need to ensure minimal data loss.

  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.)

  Select and Place: