New Updated Microsoft MCSA 70-463 Real Exam Questions and Answers Download 181-190

Ensurepass

QUESTION 181

HOTSPOT

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

events must be logged for viewing in the built-in SSIS reports by using SQL Server Management

Studio. You need to execute the package and minimize the number of event types that are logged. Which setting should you use?

 

To answer, change the appropriate setting in the answer area.

 

Hot Area:

70-463-demo-123

 

Correct Answer:

70-463-demo-124

 

 

QUESTION 182

You develop a SQL Server Integration Services (SSIS) package in a project by using the Project Deployment Model. It is regularly executed within a multi-step SQL Server Agent job. You make changes to the package that should improve performance. You need to establish if there is a trend in the durations of the next 10 successful executions of the package. You need to use the least amount of administrative effort to achieve this goal. What should yo
u do?

 

  1. After 10 executions, view the job history for the SQL Server Agent job.

  2. After 10 executions, in SQL Server Management Studio, view the Execution Performance

subsection of the All Executions report for the project.

  1. Enable logging to the Application Event Log in the package control flow for the On

information event. After 10 executions, view the Application Event Log.

  1. Enable logging to an XML file in the package control flow for the OnPostExecute event. After

10 executions, view the XML file.

 

Correct Answer: B

 

 

QUESTION 183

You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data

from a source system into a data warehouse that is hosted on Windows Azure SQL Database. The

package contains a data flow task that has 10 source-to-destination execution trees. Only five of

the source-to-destination execution trees are running in parallel. You need to ensure that all the

execution trees run in parallel. What should you do?

 

  1. Add OnError and OnWarning event handlers.

  2. Create a new project and add the package to the project.

  3. Query the ExecutionLog table.

  4. Add an Execute SQL task to the event handlers.

 

Correct Answer: A

 

 

QUESTION 184

You are the administrator of a server that hosts Data Quality Server for a large retail company.

The server had a hardware failure during business hours. You need to restore the server that

hosts Data Quality Server to another server. You have a recent backup of all the required

databases. What should you do? (Each correct answer presents part of the solution. Choose all

that apply.)

 

  1. Restore the DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases to another

server as soon as possible.

  1. Execute the DQS_MAIN.internal_core.RestoreDQDatabases stored procedure with the

appropriate parameter.

  1. Restore only the DQS_MAIN and DQS_STAGING_DATA databases to another server as soon

as possible.

  1. Execute the DQS_MAIN.internal_core.InitServer stored procedure with the appropriate

parameter.

 

Correct Answer: BD

 

 

QUESTION 185

You are designing an extract, transform, and load (ETL) solution that loads data into dimension

tables. The ETL process involves many transformation steps. You need to ensure that the design

can provide:

 

  • Auditing information for compliance and business user acceptance

  • Tracking and unique identification of records for troubleshooting and error correction

 

What should you do?

 

  1. Create a SQL Common Language Runtime (SQLCLR) component that records all

transformation steps in a Microsoft SharePoint list.

  1. Create a version control repository for the transformation steps in Team Foundation Server

(TFS).

  1. Develop a custom data lineage solution.

  2. Develop a Data Quality Services (DQS) solution.

 

Correct Answer: C

 

 

QUESTION 186

To support the implementation of new reports, Active Directory data will be downloaded to a

SQL Server database by using a SQL Server Integration Services (SSIS) 2012 package. The

following requirements must be met:

 

  • All the user information for a given Active Directory group must be downloaded to a SQL

Server table.

  • The download process must traverse the Active Directory hierarchy recursively.

 

You need to configure the package to meet the requirements by using the least development

effort. What should you use?

 

  1. script component

  2. custom component

  3. XML source

  4. script task

 

Correct Answer: A

 

 

QUESTION 187

HOTSPOT

You are a data warehouse developer responsible for developing data cleansing processes.

Duplicate employees exist in an employee dimension. You need to map, discover, and manage

domain values based on the employee dimension. Which Data Quality Services (DQS) option

should you use?

 

To answer, select the appropriate option in the answer area.

 

Hot Area:

70-463-demo-125

 

Correct Answer:

70-463-demo-126

 

 

QUESTION 188

HOTSPOT

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

defined variable named ©Queue which has an initial value of 10. The package control flow

contains many tasks that must repeat execution until the ©Queue variable equals 0. You need to

enable the tasks to be grouped together for repeat execution. Which item should you add to the

package?

 

To answer, select the appropriate item in the answer area.

 

Hot Area:

70-463-demo-127

 

Correct Answer:

70-463-demo-128

 

 

QUESTION 189

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?

 

  1. Cleansing

  2. Matching

  3. Knowledge Discovery

  4. Matching Policy

 

Correct Answer: A

 

 

QUESTION 190

You are developing a SQL Server Integration Services (SSIS) project to read and write data from a

Windows Azure SQL Database to a server that runs SQL Server 2012. The connection will be used

by data flow tasks in multiple SSIS packages. The address of the target Windows Azure SQL

Database will be provided by a project parameter. You need to create a solution to meet the

requirements by using the least amount of administrative effort. What should you do?

 

  1. Add a SQLMOBILE connection manager to each package.

  2. Add an ADO.NET project connection manager.

  3. Add a SQLMOBILE project connection manager.

  4. Add an ADO.NET connection manager to each data flow task.

  5. Add a SQLMOBILE connection manager to each data flow task.

  6. Add an ADO.NET connection manager to each package.

 

Correct Answer: A

 

 

QUESTION 191

A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a

Windows Azure SQL Database. To improve sales data accuracy, exchange rates must be

downloaded daily from a public HTTP website instead of from a weekly flat file. The public

website hosts a comma separated values (CSV) file that contains one row per currency. You need

to download the CSV file to the environment. What should you use to retrieve the document

from the website?

 

  1. a Script component

  2. a Web Service task

  3. a Web Service source

  4. a Script task

 

Correct Answer: D

 

 

QUESTION 192

You are administering SQL Server Integration Services (SSIS) permissions on a production server

that runs SQL Server 2012. Package developers in your company must have permission to

perform the following tasks only on their own projects:

 

  • View projects and packages

  • View Environments

  • Validate packages Execute packages

 

You need to grant rights to the developers without assigning unnecessary privileges. What should

you do? (Each correct answer presents part of a solution. Choose all that apply.)

 

  1. Add developer logins to the db_ssisltduser role in the msdb database.

  2. Add developer logins to the db_ssisoperator role in the msdb database.

  3. Grant Execute permission in the projects for the developer logins.

  4. Grant Read permission in the SSIS catalog folder, the projects, and the Environments.

  5. Add developer logins to the ssis_admin role in the SSISDB database.

  6. Grant Modify permission in the projects for the developer logins.

 

Correct Answer: BD

 

Instant Access to Download Latest Complete Collection of Microsoft MCSE 70-463 Real Exam

Try Microsoft MCSE 70-463 Free Demo

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.