70-767 試験問題を無料オンラインアクセス
| 試験コード: | 70-767 |
| 試験名称: | Implementing a SQL Data Warehouse |
| 認定資格: | Microsoft |
| 無料問題数: | 170 |
| 更新日: | 2026-10-17 |
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer chokes, but the text of the scenario is exactly the same in each question in the series.
Start of repeated scenario
Contoso. Ltd. has a Microsoft SQL Server environment that includes SQL Server Integration Services (SSIS), a data warehouse, and SQL Server Analysis Services (SSAS) Tabular and multi-dimensional models.
The data warehouse stores data related to your company sales, financial transactions and financial budgets. All data for the data warehouse originates from the company s business financial system.
The data warehouse includes the following tables:
The company plans to use Microsoft Azure to store older records from the data warehouse. You must modify the database to enable the Stretch Database capability.
Users report that they are becoming confused about which city table to use for various queries. You plan to create a new schema named Dimension and change the name of the dbo.diamension_city table to Diamension.city. Data loss is not permissible, and you must not leave traces of the old table in the data warehouse.
The fact. Transaction table has measures named RawCost and Totaisale that calculate the wholesale cost of materials. You plan to create a measure that calculates the profit margin based on the two existing measures.
You must implement a partitioning scheme for the fact.Transaction table to move older data to less expensive storage. Each partition will store data for a single calendar year, as shown in the exhibit (Click the Exhibit button.) You must align the partitions.
You must improve performance for queries against the fact.Transaction table. You must implement appropriate indexes and enable the Stretch Database capability.
End of repeated scenario
You need to create the ProfitMargin measure for the fact. Transaction table.
How should you complete the MDX statement? To answer, select the appropriate MDX segments in the answer area.
You have a data warehouse named DW1.
InDvfe you plan to create a table named Tablel that will be partitioned by hour. Tablel will contain the last three hours of data.
You plan to implement a sliding window process for inserting data into Tablel.
You need to recommend the minimum number of partitions that must be included in Tablel to support the planned implementation. The solution must minimize the number of transaction log records created during the insert process.
How many partitions should you recommend?
A database has tables named Table1, Table2, and Table3.
* Table1 has a foreign key relationship with Table2.
* Table2 has a foreign key relationship with Table3.
* Table1 does not have a direct relationship with Table3.
You need to recommend an appropriate dimension usage relationship.
What should you recommend?
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.
Each night you receive a comma separated values (CSV) file that contains different types of rows. Each row type has a different structure. Each row in the CSV file is unique. The first column in every row is named Type. This column identifies the data type.
For each data type, you need to load data from the CSV file to a target table. A separate table must contain the number of rows loaded for each data type.
Solution: You create a SQL Server Integration Services (SSIS) package as shown in the exhibit. (Click the Exhibit tab.)
Does the solution meet the goal?
You administer a Microsoft SQL Server Master Data Services (MDS) model. All model entity members have passed validation.
The current model version should be committed to form a record of master data that can be audited and create a new version to allow the ongoing management of the master data.
You lock the current version. You need to manage the model versions.
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.
