Surprising 70 463 training kit pdf

Pass4sure offers free demo for 70 463 dumps exam. "Implementing a Data Warehouse with Microsoft SQL Server 2012", also known as exam 70 463 exam, is a Microsoft Certification. This set of posts, Passing the Microsoft 70 463 training kit pdf exam, will help you answer those questions. The 70 463 exam Questions & Answers covers all the knowledge points of the real exam. 100% real Microsoft 70 463 training kit pdf exams and revised by experts!

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

The package sources data from an HTML web page that lists product stock levels. 

You need to implement a data flow task that reads the product stock levels from the HTML web page. 

Which data flow source should you use? 

A. Use an msi file to deploy the package on the server. 

B. Open a command prompt and run the dtutil /copy command. 

C. Add an OnError event handler to the SSIS project. 

D. Open a command prompt and run the gacutil command. 

Answer: B 

Q22. You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup transformation. 

The reference data to be used in the transformation changes with every package execution. 

Common language runtime (CLR) integration cannot be enabled on the SQL Server database where the reference table is located. 

You need to configure the Fuzzy Lookup transformation in the most efficient manner. 

What should you do? 

A. Execute the sp_FuzzyLookupTableMaintenanceInvoke stored procedure. 

B. Select the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor. 

C. Execute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure. 

D. Select the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Editor. 

Answer: B 

Q23. You are developing a SQL Server Integration Services (SSIS) package that is ready for deployment to a production server. The package contains sensitive information secured by using the EncryptSensitiveWithUserKey package protection level. 

You are preparing the package for deployment by the production operations team. 

You need to ensure that the production operations team can open and execute the package without re-entering the sensitive information. 

Which three steps 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.) 

Answer: 

Q24. 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 Onlnformation 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. 

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

What should you do? 

A. Run the Data Quality Server Installer. 

B. Install the data providers that are used for data refresh. 

C. Run the dbimpexp.exe command. 

D. Install the Analysis Services OLE DB Provider. 

Answer: B 

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

You use a Data Profiling task to examine the data from a source system. You need to establish: 

. The minimum and maximum dates for the datetime columns in the source data 

. The minimum, maximum, and average values for numeric columns in the source data 

You need to use the appropriate profile type in the Data Profiling task. 

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

Answer: 

Q27. You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server 2012 database. 

The package is allowed to connect to only one database. An Environment variable contains the name of the database. 

The OLE DB project connection manager has been parameterized. 

You need to configure the connection manager property to accept the value of the Environment variable. 

Which property should you use? (To answer, configure the appropriate option or options in the dialog box in the answer area.) 

Answer: 

Q28. A SQL Server Integration Services (SSIS) project has been deployed to the SSIS catalog. The project includes a project Connection Manager to connect to the data warehouse. 

The SSIS catalog includes two Environments: 

. Development 

. QA 

Each Environment defines a single Environment Variable named ConnectionString of type string. The value of each variable consists of the connection string to the development or QA data warehouses. 

You need to be able to execute deployed packages by using either of the defined Environments. 

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

Answer: 

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

Q30. You are administering SQL Server Integration Services (SSIS) permissions on a production server that runs SQL Server 2012. 

Quality Assurance (QA) testers in the company must have permission to perform the following tasks on specific projects: 

View and validate projects and packages 

View Environments and Environment variables 

Execute packages 

You need to grant the minimum possible privileges to the QA testers. 

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

A. In the SSISDB database, add QA Tester logons to the ssis_admin role. 

B. In the msdb database, add QA Tester logons to the db_ssisoperator role. 

C. Grant Modify permission in the projects to the QA Tester logons. 

D. Grant Read permission in the SSIS catalog folder, the projects, and the Environments to the QA Tester logons. 

E. Grant Execute permission in the projects to the QA Tester logons. 

F. In the msdb database, add QA Tester logons to the db_ssisItduser role. 

Answer: B,D