最新的Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 - 70-463免費考試真題
問題1
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.
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.
正確答案:
Explanation
References:
http://msdn.microsoft.com/en-us/library/ms141821.aspx
http://msdn.microsoft.com/en-us/library/ms189697.aspx
問題2
You are developing a SQL Server Integration Services (SSIS) package that loads data from a source transactional tables in a data warehouse.
You discover that one of the data flows loads incorrect data to one of the destination tables.
You need to identify the cause of the incorrect data flow. Which tool should you use?
You discover that one of the data flows loads incorrect data to one of the destination tables.
You need to identify the cause of the incorrect data flow. Which tool should you use?
正確答案: C
問題3
You are troubleshooting an existing SQL Server Integration Services (SSIS) package. On several occasions, the package execution does not finish and no data seems to have been transferred.
You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts.
What should you do?
You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts.
What should you do?
正確答案: A
說明：（僅 VCESoft 成員可見）
問題4
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.)
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.)
正確答案:
Explanation
Box 1:
Box 2:
Box 3:
問題5
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.
All packages in the project must log custom messages.
You need to produce reports that combine the custom log messages with the system-generated log messages.
What should you do?
All packages in the project must log custom messages.
You need to produce reports that combine the custom log messages with the system-generated log messages.
What should you do?
正確答案: K
問題6
You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rows from a SQL Azure database. The project uses the Package Deployment Model. This project is deployed to SQL Server on a test server.
You need to ensure that the project is deployed to the SSIS catalog on the production server.
What should you do?
You need to ensure that the project is deployed to the SSIS catalog on the production server.
What should you do?
正確答案: C
說明：（僅 VCESoft 成員可見）
問題7
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 and maximizing data flow performance.
What should you do?
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 and maximizing data flow performance.
What should you do?
正確答案: B
問題8
You are deploying a project to the SQL Server Integration Services (SSIS) catalog.
You need to ensure that the project is deployed to the production environment with the least amount of administrative effort.
What should you do?
You need to ensure that the project is deployed to the production environment with the least amount of administrative effort.
What should you do?
正確答案: G
說明：（僅 VCESoft 成員可見）
問題9
You are developing a SQL Server Integration Services (SSIS) package that imports unsorted data into a data warehouse hosted on Microsoft Azure SQL Database.
You have the following requirements:
*A destination table must contain all of the data in two source tables.
*Duplicate records must be inserted into the destination table.
You need to develop a data flow that imports the data while meeting the requirements.
How should you develop the data flow? (To answer, drag the appropriate transformation from the list of transformations to the correct location in the answer area.)
You have the following requirements:
*A destination table must contain all of the data in two source tables.
*Duplicate records must be inserted into the destination table.
You need to develop a data flow that imports the data while meeting the requirements.
How should you develop the data flow? (To answer, drag the appropriate transformation from the list of transformations to the correct location in the answer area.)
正確答案:
Explanation
References:
http://msdn.microsoft.com/en-us/library/ms141703.aspx
http://msdn.microsoft.com/en-us/library/ms141775.aspx
http://msdn.microsoft.com/en-us/library/ms1410
http://msdn.microsoft.com/en-us/library/ms140182
問題10
You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night.
The SQL Azure data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching string from a reference table of allowed values. The number of rows in the reference table is very large.
If no acceptable match is found, the Fuzzy Lookup transformation passes a null value.
The current setting for the Fuzzy Lookup similarity threshold is 0.50.
Many values are incorrectly matched.
You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance.
What should you do?
The SQL Azure data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching string from a reference table of allowed values. The number of rows in the reference table is very large.
If no acceptable match is found, the Fuzzy Lookup transformation passes a null value.
The current setting for the Fuzzy Lookup similarity threshold is 0.50.
Many values are incorrectly matched.
You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance.
What should you do?
正確答案: A
問題11
You are designing a SQL Server Integration Services (SS1S) package that uploads a file to a table named Orders in a SQL Azure database.
The company's auditing policies have the following requirements:
*An entry must be written to a dedicated SQL Server log table named OrderLog.
*The entry must be written as soon as the file upload task completes.
You need to meet the company's policy requirements. Which event handler should you use?
The company's auditing policies have the following requirements:
*An entry must be written to a dedicated SQL Server log table named OrderLog.
*The entry must be written as soon as the file upload task completes.
You need to meet the company's policy requirements. Which event handler should you use?
正確答案: D
說明：（僅 VCESoft 成員可見）
問題12
You are developing a SQL Server Integration Services (SSIS) package.
The package contains several tasks that must repeat until an expression evaluates to FALSE.
You need to add and configure a container to enable this design.
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,)
The package contains several tasks that must repeat until an expression evaluates to FALSE.
You need to add and configure a container to enable this design.
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,)
正確答案:
Explanation
Box 1: Open the Control Flow designer of the package.
Box 2: Add and edit a For Loop container.
Box 3: Configure the EvalExpression property.
Note:
* You create the control flow in a package by using the control flow designer.
Integration Services includes three types of containers that you can use in a control flow.
/ Foreach Loop container
/ For Loop container
/ Sequence container
* For Loop Container
The For Loop container defines a repeating control flow in a package. The loop implementation is similar to the For looping structure in programming languages. In each repeat of the loop, the For Loop container evaluates an expression and repeats its workflow until the expression evaluates to False.
The For Loop container uses the following elements to define the loop:
/ An optional initialization expression that assigns values to the loop counters.
/ An evaluation expression that contains the expression used to test whether the loop should stop or continue.
/ An optional iteration expression that increments or decrements the loop counter.
