070-463 무료 덤프문제 온라인 액세스

You have a SQL Server Integration Services (SSIS) package that contains several data flows. You discover that several records fail to load correctly in the destination.
You need to identify the cause of the record failure for each record.
Which event handler should you add to the package?

• A.OnExecStatusChanged
• B.OnTaskFailed
• C.OnError
• D.OnPostExecute

You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server 2012 database.
The name of the target instance is passed to the package via an Environment variable.
The Environment variable provides the server name to the Project parameter named ServerName.
The OLE DB Project Connection Manager has been parameterized.
You need to configure the Connection Manager property to accept the parameter.
Which property and parameter should you use? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

정답:

Explanation

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.Develop a Data Quality Services (DQS) solution.
• B.Develop a custom data lineage solution.
• C.Create a version control repository for the ETL solution.
• D.Develop a Master Data Services (MDS) solution.

You develop a SQL Server Integration Services (SSIS) project by using the Package Deployment Model. A package in the project extracts data from a Windows Azure SQL Database database.
The package is deployed to SQL Server.
The package is not producing the desired results.
You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues.
What should you do?

• A.Run the DTEXEC utility with the /Reporting V option.
• B.Run the DTEXEC utility with the /Logger option.
• C.Execute the catalog.add_data_tap stored procedure with the package execution_id.
• D.Execute the catalog.create_execution_dump stored procedure with the package execution_id.

You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day.
Referential integrity must be enforced declaratively.
You need to design a solution that can join a single time dimension to both fact tables.
What should you do?

• A.Partition the fact tables by day.
• B.Change the level of granularity in both fact tables to be the same.
• C.Join the two fact tables.
• D.Merge the fact tables.