Surprising 70 463 dumps

Want to know Examcollection 70 463 pdf Exam practice test features? Want to lear more about Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012 certification experience? Study Refined Microsoft exam 70 463 answers to Abreast of the times 70 463 pdf questions at Examcollection. Gat a success with an absolute guarantee to pass Microsoft 70 463 pdf (Implementing a Data Warehouse with Microsoft SQL Server 2012) test on your first attempt.

Q11. 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: 


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

You need to edit the Script task that has an expression defined. 

Which task should you select? To answer, select the appropriate setting or settings in the answer area. 

Answer: 


Q13. You install a SQL Server 2012 database engine instance on a production server. A month later, you install SQL Server 2012 Integration Services (SSIS). 

You must develop an SSIS project and deploy it to the server by using the Project Deployment model. 

Operations log records that are outside the configured retention period must be cleaned automatically. 

You need to create the SSIS catalog on the production server and ensure that the operations log cleaning requirement is met. 

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

A. Enable CLR Integration. 

B. Enable FILESTREAM with Full Access. 

C. Enable the Resource Governor. 

D. Change the recovery mode of the msdb database to FULL. 

E. Change the Server-wide Default Logging Level in SSISDB to Verbose. 

F. Start the SQL Server Browser service. 

G. Start the SQL Server Agent service. 

Answer: A,D 


Q14. 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: 


Q15. You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment model. 

The project contains many packages. It is deployed on a server named SQLTest1. The project will be deployed to several servers that run SQL Server 2012. 

The project accepts one required parameter. The data type of the parameter is a string. 

A SQL Agent job is created that will call the Loading.dtsx package in the project. A job step is created for the SSIS package. 

The job must pass the value of an SSIS Environment Variable to the project parameter. The value of the Environment Variable must be configured differently on each server that runs SQL Server. The value of the Environment Variable must provide the server name to the project parameter. 

You need to configure SSIS on the SQLTest1 server to pass the Environment Variable to the package. 

Which four actions should you perform in sequence by using SQL Server Management Studio? 

(To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.) 

Answer: 


Q16. 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:


Q17. You are developing a data flow to load sales data into a fact table. In the data flow, you configure a Lookup Transformation in full cache mode to look up the product data for the sale. 

The lookup source for the product data is contained in two tables. 

You need to set the data source for the lookup to be a query that combines the two tables. 

Which page of the Lookup Transformation Editor should you select to configure the query? To answer, select the appropriate page in the answer area. 

Answer: 


Q18. You use SQL Server Integration Services (SSIS) for extract, transformation, load (ETL) processing. 

Issues concerning addresses are discovered in the data warehouse that you manage. Validation must separate the addresses into three categories: 

Valid addresses 

Autocorrected addresses 

Invalid addresses 

You need to enhance the SSIS packages to perform address validation by using an external service. 

Which transformation should you use? (To answer, drag the appropriate transformation from the list of options to the correct location or locations in the answer area.) 

Answer: 


Q19. You are maintaining a Data Quality Services (DQS) environment. The production server failed and a new server has been set up. The DQS databases are restored to a new server. All the appropriate permissions are granted. 

DQS users are experiencing issues connecting to the new Data Quality Server. 

You need to enable users to connect to the new server. 

Which Surface Area Configuration property should you enable? 

A. AdHocRemoteQueriesEnabled 

B. SoapEndpointsEnabled 

C. ClrIntegrationEnabled 

D. RemoteDacEnabled 

E. OleAutomationEnabled 

F. XpCmdShellEnabled 

Answer:


Q20. You are developing a SQL Server Integration Services (SSIS) project that contains a project Connection Manager and multiple packages. 

All packages in the project must connect to the same database. The server name for the database must be set by using a parameter named ParamConnection when any package in the project is executed. 

You need to develop this project with the least amount of development effort. 

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

A. Create a package parameter named ConnectionName in each package. 

B. Edit each package Connection Manager. Set the ConnectionName property to @[$Project::ParamConnection]. 

C. Edit the project Connection Manager in Solution Explorer. Set the ConnectionName property to @ [$Project::ParamConnection]. 

D. Set the Sensitive property of the parameter to True. 

E. Create a project parameter named ConnectionName. 

F. Set the Required property of the parameter to True. 

Answer: B,E,F 

Explanation: B: From question: " The server name for the database must be set by using a parameter named ParamConnection when any package in the project is executed." 

E: SSIS 2012 has introduced the concept of Project level connection managers. An SSIS project is generally more than one package. To simplify lives, the SSIS team now allows for the sharing of common resources across projects, connection managers being one of those resources. 

F: When a parameter is marked as required, a server value or execution value must be specified for that parameter. Otherwise, the corresponding package does not execute. Although the parameter has a default value at design time, it will never be used once the project is deployed. 

Note: 

* Integration Services (SSIS) parameters allow you to assign values to properties within packages at the time of package execution. You can create project parameters at the project level and package parameters at the package level. Project parameters are used to supply any external input the project receives to one or more packages in the project. Package parameters allow you to modify package execution without having to edit and redeploy the package. 

Reference: Integration Services (SSIS) Parameters