Microsoft 70-458 Online Practice Questions and Exam Preparation

Microsoft 70-458 Online Questions & Answers

• Question 71:

  You are designing a package control flow. The package moves sales order data from a Windows Azure SQL Database transactional database to an on-premise reporting database. The package will run several times a day, while new sales orders are being added to the transactional database.

  The current design of the package control flow is shown in the answer area. (Click the Exhibit button.)

  

  The Insert New Orders Data Flow task must meet the following requirements:

  

  Usage of the tempdb database should not be impacted.

  

  Concurrency should be maximized, while only reading committed transactions.

  

  If the task fails, only that task needs to be rolled back.

  You need to configure the Insert New Orders Data Flow task to meet the requirements.

  How should you configure the transaction properties? To answer, select the appropriate setting or settings in the answer area.

  

  Hot Area:

  

  

• Question 72:

  You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN).

  The financial database has the following characteristics:

  

  A data file of 2 terabytes is located on a dedicated LUN (drive D).

  A transaction log of 10 GB is located on a dedicated LUN (drive E).

  

  

  Drive D has 1 terabyte of free disk space.

  

  Drive E has S GB of free disk space.

  The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of the existing data is modified each day.

  The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of data to the database.

  These data load operations must occur in the minimum amount of time.

  A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours.

  On Wednesday at 10:00 hours, the development team requests you to refresh the database on a development server by using the most recent version.

  You need to perform a full database backup that will be restored on the development server.

  A. Differential
  B. Transaction log
  C. FULL
  D. SIMPLE
  E. BULK_LOGGED
  F. SKIP
  G. RESTART
  H. STANDBY
  I. CHECKSUM
  J. DBO_ONLY
  K

• Question 73:

  You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size. The Sales database is configured as shown in the following

  

  You discover that all files except Sales_2.ndf are corrupt.

  You need to recover the corrupted data in the minimum amount of time.

  What should you do?

  A. Perform a file restore.
  B. Perform a restore from a full backup.
  C. Perform a transaction log restore.
  D. Perform a filegroup restore.
  D. Perform a filegroup restore.

• Question 74:

  You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN).

  The financial database has the following characteristics:

  

  A data file of 2 terabytes is located on a dedicated LUN (drive D).

  

  A transaction log of 10 GB is located on a dedicated LUN (drive E).

  

  Drive D has 1 terabyte of free disk space.

  

  Drive E has 5 GB of free disk space.

  The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of the existing data is modified each day.

  The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of data to the database.

  These data load operations must occur in the minimum amount of time.

  A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours.

  You need to ensure that your backup will continue if any invalid checksum is encountered.

  A. Differential
  B. Transaction log
  C. FULL
  D. SIMPLE
  E. BULK_LOGGED
  F. SKIP
  G. RESTART
  H. STANDBY
  I. CHECKSUM
  J. DBO_ONLY
  N

• Question 75:

  You are developing a SQL Server Integration Services (SSIS) package. The data source for the data flow task is a table that has been configured as a change data capture (CDC) table. You are using a CDC Source component to obtain the

  CDC data.

  The data source will be polled once per hour. The data is updated with multiple important status changes per minute.

  For each captured data change, the before and after values must be included.You need to configure the CDC Source component.

  Which CDC processing mode should you select? (To answer, configure the appropriate option in the dialog box in the answer area.)

  

  Hot Area:

  

  

• Question 76:

  You administer two Microsoft SQL Server 2012 servers named ServerA and ServerB. You use a database named AdventureWorks.

  You need to prepare the AdventureWorks database for database mirroring. ServerB will act as the mirror in a mirroring partnership along with ServerA.

  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:

  

  

• Question 77:

  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.

  To ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS) package logging methodology.

  The methodology has the following requirements:

  

  Centralized logging in SQL Server

  

  Simple deployment

  

  Availability of log information through reports orT-SQL Automatic purge of older log entries Configurable log details

  You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort.

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

• Question 78:

  You are building a fact table In a data warehouse.

  The table must have a columnstore index. The table cannot be partitioned.

  You need to design the fact table and load it with data.

  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:

  

  

• Question 79:

  You are developing a SQL Server Integration Services (SSIS) package.

  The package contains an ActiveX Data Objects (ADO) source variable that holds a result set that was returned by a stored procedure execution.

  You need to add and configure a container that will execute several tasks for each row in the ADO object source variable.

  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:

  

  

• Question 80:

  You are the data steward at your company.

  Duplicate customers exist in a Microsoft Excel workbook. You create a Data Quality Services (DQSJ knowledge base and matching policy to identify these duplicate customers.

  You need to identify the duplicate customers.

  Which option should you use? (To answer, select the appropriate option in the answer area.)

  Hot Area: