IT分野での実力を示す指標として、Microsoft Implementing a SQL Data Warehouseは多くの企業から評価されている認定資格です。GoShikenの070-767練習問題170問は、公式の出題範囲に基づいて作成されています。

Microsoft 070-767 試験概要:

Microsoft 070-767 試験シラバストピック:

Microsoft Implementing a SQL Data Warehouseのよくある疑問を解決します

Microsoft Implementing a SQL Data Warehouse 認定 070-767 試験問題：

問題 #1

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are loading data from an OLTP database to a data warehouse.
The OLTP database includes a table for sales data and a table for refund data.
The data warehouse contains a single table for all the sales and refund data.
Which component should you use to load the data to the data warehouse?

A. the Data Conversion transformation
B. the Slowly Changing Dimension transformation
C. the Conditional Split transformation
D. an Execute SQL task
E. the Merge transformation
F. the Lookup transformation
G. the Aggregate transformation

問題 #2

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are a database administrator for an e-commerce company that runs an online store. The company has the databases described in the following table.

Product prices are updated and are stored in a table named Products on DB1. The Products table is deleted and refreshed each night from MDS by using a Microsoft SQL Server Integration Services (SSIS) package. None of the data sources are sorted.
You need to update the SSIS package to add current prices to the Products table.
What should you use?

A. Union All transformation
B. Sequential container
C. Merge Join transformation
D. Foreach Loop container
E. MERGE statement
F. Balanced Data Distributor transformation
G. Merge transformation
H. Lookup transformation

問題 #3

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You create a set of Microsoft SQL Server Integration Services (SSIS) packages to support an ETL process.
You need to deploy the SSIS packages and meet the following requirements:
* Maximize ease of use for backup processes.
* Manage security of packages from a single place.
* Maintain versioning pf packages.
* Implement parameters to assign values to packages.
* Use stored procedures to run SSIS packages.
* Use SQL Server Agent to run packages.
Solution: You use the Project Deployment model. You save the packages to team Foundation Server.
Does this meet the goal?

A. No
B. Yes

問題 #4

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a data warehouse that stores information about products, sales, and orders for a manufacturing company. The instance contains a database that has two tables named SalesOrderHeader and SalesOrderDetail.
SalesOrderHeader has 500,000 rows and SalesOrderDetail has 3,000,000 rows.
Users report performance degradation when they run the following stored procedure:

You need to optimize performance.
Solution: You run the following Transact-SQL statement:

Does the solution meet the goal?

A. No
B. Yes

問題 #5

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it As a result, these questions will not appear in the review screen.
You have an on-premises Microsoft SQL Server instance and a Microsoft Azure SQL Data Warehouse instance. You move data from the on-premises database to the data warehouse once each day by using a SQL Server Integration Services (SSIS) package.
You observe that the package no longer completes within the allotted time.
You need to determine which tasks are taking a long time to complete.
Solution: You enable package logging within SSIS.
Does the solution meet the goal?

A. No
B. Yes

解説：