Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Microsoft Official New Released 70-463
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/70-463.html
Implementing a Data Warehouse with Microsoft SQL Server 2012
Question No: 51 – (Topic 1)
You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system.
Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes.
You need to establish the best technique to log these invalid rows while minimizing the amount of development effort.
What should you do?
-
Add a data tap on the output of a component in the package data flow.
-
Deploy the package by using an msi file.
-
Run the package by using the dtexecui.exe utility and the SQL Log provider.
-
uses the dtutil /copy command.
-
Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.
-
Create an OnError event handler.
-
uses the Project Deployment Wizard.
-
Use the gacutil command.
-
Create a reusable custom logging component.
-
Run the package by using the dtexec /rep /conn command.
-
Run the package by using the dtexec /dumperror /conn command.
Answer: A
Reference:
http://www.rafael-salas.com/2012/01/ssis-2012-quick-peek-to-data-taps.html http://msdn.microsoft.com/en-us/library/hh230989.aspx http://msdn.microsoft.com/en-us/library/jj655339.aspx
Question No: 52 DRAG DROP – (Topic 1)
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:
Question No: 53 – (Topic 1)
To ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS) package logging methodology.
The methodology has the following requirements:
鈥entralized logging in SQL Server
鈥imple deployment
鈥vailability of log information through reports or T-SQL
鈥utomatic purge of older log entries
鈥onfigurable log details
You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort.
What should you do?
-
Deploy the package by using an msi file.
-
Use the gacutil command.
-
Create an OnError event handler.
-
Create a reusable custom logging component.
-
Use the dtutil /copy command.
-
Use the Project Deployment Wizard.
-
Run the package by using the dtexec /rep /conn command.
-
Add a data tap on the output of a component in the package data flow.
-
Run the package by using the dtexec /dumperror /conn command.
-
Run the package by using the dtexecui.exe utility and the SQL Log provider.
-
Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.
Answer: J Explanation: References:
http://msdn.microsoft.com/en-us/library/ms140246.aspx http://msdn.microsoft.com/en-us/library/ms180378(v=sql.110).aspx
Question No: 54 – (Topic 1)
You are developing a SQL Server Integration Services (SSIS) package.
To process complex scientific data originating from a SQL Azure database, a custom task component is added to the project.
You need to ensure that the custom component is deployed on a test environment correctly.
What should you do?
-
Add an OnError event handler to the SSIS project.
-
Open a command prompt and run the gacutil command.
-
Configure the SSIS solution to use the Project Deployment Model.
-
Open a command prompt and run the dtexec /dumperror /conn command.
-
Configure the output of a component in the package data flow to use a data tap.
-
Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
-
Open a command prompt and run the dtexec /rep /conn command.
-
Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.
-
Use an msi file to deploy the package on the server.
-
Open a command prompt and run the dtutil /copy command.
-
Create a reusable custom logging component and use it in the SSIS project.
Answer: B
Reference:
http://msdn.microsoft.com/en-us/library/ms403356.aspx
Question No: 55 – (Topic 1)
You are developing a project that contains multiple SQL Server Integration Services (SSIS) packages. The packages will be deployed to the SSIS catalog. One of the steps in each package accesses an FTP site to download sales transaction data.
You create project parameters to store the username and password that are used to access the FTP site.
You need to ensure that the username and password values are encrypted when they are deployed.
What should you do?
-
Set the Sensitive property of the parameters to True.
-
Set the ProtectionLevel property of the package to EncryptSensitiveWithUserKey.
-
Change the parameters to package parameters.
-
Change the project to the Legacy Deployment model.
Answer: A
Question No: 56 – (Topic 1)
You manage a SQL Server Master Data Services (MDS) environment.
A new application requires access to the product data that is available in the MDS repository.
You need to design a solution that gives the application access to the product data with the least amount of development effort.
What should you do?
-
Use sp_addlinkedserver to add a linked server to access the MDS database tables directly.
-
Create an OLE DB connection string that sets the Provider property to MDS.
-
Use transactional replication for data synchronization.
-
Create a Subscription View in MDS.
Answer: D
Question No: 57 – (Topic 1)
You are creating a SQL Server Master Data Services (MDS) model. This model is used to store a master list of products.
An attribute must be added to the Product entity to define the sales manager responsible for each product.
You need to create an attribute in the Product entity that prevents users from entering invalid sales manager values.
Which type of attribute should you create?
-
Recursive
-
Explicit
-
Domain-based
-
User-defined
-
Derived
-
Parent
Answer: C
Explanation: References: http://msdn.microsoft.com/en-us/library/bb190163.aspx http://msdn.microsoft.com/en-us/library/ee633737.aspx http://msdn.microsoft.com/en-us/library/ee633759.aspx http://msdn.microsoft.com/en-us/library/ee633745.aspx http://msdn.microsoft.com/en-us/library/ee633724.aspx http://msdn.microsoft.com/en-us/library/ee633733.aspx http://msdn.microsoft.com/en-us/library/ff487058.aspx
Question No: 58 DRAG DROP – (Topic 1)
You are editing a SQL Server Integration Services (SSIS) package that contains a task with a sensitive property.
You need to create a project parameter and configure it so that its value is encrypted when
it is deployed to the SSIS catalog.
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:
Question No: 59 – (Topic 1)
You are using a SQL Server Integration Services (SSIS) project that is stored in the SSIS catalog. An Environment has been defined in the SSIS catalog.
You need to add the Environment to the project. Which stored procedure should you use?
-
catalog.set_environment_reference_type
-
catalog.set_environment_property
-
catalog.create_environment_reference
-
catalog.create_environment
Answer: C
Question No: 60 DRAG DROP – (Topic 1)
You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse. You are developing the part of the SSIS package that populates the ProjectDates dimension table.
The business key of the ProjectDates table is the ProjectName column. The business user has given you the dimensional attribute behavior for each of the four columns in the ProjectDates table:
鈥xpectedStartDate – New values should be tracked over time.
鈥ctualStartDate – New values should not be accepted.
鈥xpectedEndDate – New values should replace existing values.
鈥ctualEndDate – New values should be tracked over time.
You use the SSIS Slowly Changing Dimension Transformation.
You must configure the Change Type value for each source column.
Which settings should you select? (To answer, select the appropriate setting or settings in the answer area. Each Change Type may be used once, more than once, or not at all.)
Answer: Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms141715.aspx http://msdn.microsoft.com/en-us/library/ms141662.aspx
100% Ensurepass Free Download!
–Download Free Demo:70-463 Demo PDF
100% Ensurepass Free Guaranteed!
–70-463 Dumps
EnsurePass | ExamCollection | Testking | |
---|---|---|---|
Lowest Price Guarantee | Yes | No | No |
Up-to-Dated | Yes | No | No |
Real Questions | Yes | No | No |
Explanation | Yes | No | No |
PDF VCE | Yes | No | No |
Free VCE Simulator | Yes | No | No |
Instant Download | Yes | No | No |
100-105 Dumps VCE PDF
200-105 Dumps VCE PDF
300-101 Dumps VCE PDF
300-115 Dumps VCE PDF
300-135 Dumps VCE PDF
300-320 Dumps VCE PDF
400-101 Dumps VCE PDF
640-911 Dumps VCE PDF
640-916 Dumps VCE PDF
70-410 Dumps VCE PDF
70-411 Dumps VCE PDF
70-412 Dumps VCE PDF
70-413 Dumps VCE PDF
70-414 Dumps VCE PDF
70-417 Dumps VCE PDF
70-461 Dumps VCE PDF
70-462 Dumps VCE PDF
70-463 Dumps VCE PDF
70-464 Dumps VCE PDF
70-465 Dumps VCE PDF
70-480 Dumps VCE PDF
70-483 Dumps VCE PDF
70-486 Dumps VCE PDF
70-487 Dumps VCE PDF
220-901 Dumps VCE PDF
220-902 Dumps VCE PDF
N10-006 Dumps VCE PDF
SY0-401 Dumps VCE PDF