Braindump2go Updates Microsoft 70-463 VCE Exam Questions for Free Download (171-180)

2015 Braindumo2go Updates Microsoft 70-463 Exam Dumps Questions, adds some new changed questions from Microsoft Official Exam Center. Want to know 2015 70-463 Exam test points? Download the following free Braindump2go Latest Exam Questions Today!

Vendor: Microsoft
Exam Code: 70-463
Exam Name: Implementing a Data Warehouse with Microsoft SQL Server 2012 Exam

QUESTION 171
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 you do?

A.    After 10 executions, view the job history for the SQL Server Agent job.
B.    After 10 executions, in SQL Server Management Studio, view the Execution Performance
subsection of the All Executions report for the project.
C.    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.
D.    Enable logging to an XML file in the package control flow for the OnPostExecute event.
After 10 executions, view the XML file.

Answer: B
Explanation:
The All Executions Report displays a summary of all Integration Services executions that have been performed on the server. There can be multiple executions of the sample package.
Unlike the Integration Services Dashboard report, you can configure the All Executions report to show executions that have started during a range of dates.
The dates can span multiple days, months, or years.
The report displays the following sections of information.
- Filter
Shows the current filter applied to the report, such as the Start time range.
- Execution Information
Shows the start time, end time, and duration for each package execution.
You can view a list of the parameter values that were used with a package execution, such as values that were passed to a child package using the Execute Package task.

QUESTION 172
Hotspot Questions
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.)

Answer:

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

A.    Restore the DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases to
another server as soon as possible.
B.    Execute the DQS_MAIN.internal_core.RestoreDQDatabases stored procedure with the
appropriate parameter.
C.    Restore only the DQS_MAIN and DQS_STAGING_DATA databases to another server as
soon as possible.
D.    Execute the DQS_MAIN.internal_core.InitServer stored procedure with the appropriate
parameter.

Answer: AB
Explanation:
Steps to restore DQS Databases:
- Restore DQS_MAIN database.
- Restore the DQS_PROJECTS database.
- Restore the DQS_STAGING_DATA database.
- In Object Explorer, right-click the server, and then click New Query.
- In the Query Editor window, copy the following SQL statements, and replace <PASSWORD> with the password that you provided during the DQS installation for the database master key:
USE [DQS_MAIN]
GO
EXECUTE [internal_core].[RestoreDQDatabases] '<PASSWORD>'
GO
- Press F5 to execute the statements. Check the Results pane to verify that the statements have executed successfully.
Note:
- Backup and restore of SQL Server databases are common operations that database administrators perform for preventing loss of data in a case of disaster by recovering data from the backup databases. Data Quality Server is primarily implemented by two SQL Server databases: DQS_MAIN and DQS_PROJECTS. The backup and restore procedures of the Data Quality Services (DQS) databases are similar to any other SQL Server databases.
http://msdn.microsoft.com/en-gb/library/hh213068(v=sql.110).aspx ¹

QUESTION 174
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?

A.    Create a SQL Common Language Runtime (SQLCLR) component that records all
transformation steps in a Microsoft SharePoint list.
B.    Create a version control repository for the transformation steps in Team Foundation
Server (TFS).
C.    Develop a custom data lineage solution.
D.    Develop a Data Quality Services (DQS) solution.

Answer: C

QUESTION 175
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?

A.    script component
B.    custom component
C.    XML source
D.    script task

Answer: A

QUESTION 176
Hotspot Questions
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.)

Answer:

QUESTION 177
Hotspot Questions
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.)

Answer:

QUESTION 178
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.    Matching
C.    Knowledge Discovery
D.    Matching Policy

Answer: A
Explanation:
http://msdn.microsoft.com/en-gb/library/hh213055(v=sql.110).aspx ²

QUESTION 179
You are developing a SQL Server Integration Services (SSIS) project to read and write data from a Windows Azure SQL Database 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 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?

A.    Add a SQLMOBILE connection manager to each package.
B.    Add an ADO.NET project connection manager.
C.    Add a SQLMOBILE project connection manager.
D.    Add an ADO.NET connection manager to each data flow task.
E.    Add a SQLMOBILE connection manager to each data flow task.
F.    Add an ADO.NET connection manager to each package.

Answer: B
Explanation:
http://www.databasejournal.com/features/mssql/windows-azure-sql-database-uploading-data-by-using-sql-server-integration-services.html ³

QUESTION 180
A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows Azure SQL Database 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?

A.    a Script component
B.    a Web Service task
C.    a Web Service source
D.    a Script task

Answer: D

http://www.braindump2go.com/70-463.html

1. http://msdn.microsoft.com/en-gb/library/hh213068(v =sql.110).aspx
2. http://msdn.microsoft.com/en-gb/library/hh213055(v =sql.110).aspx
3. http://www.databasejournal.com/features/mssql/wind ows-azure-sql-database-uploading-data-by-using-sql -server-integration-services.html