Online Access Free 70-767 Exam Questions
| Exam Code: | 70-767 |
| Exam Name: | Implementing a SQL Data Warehouse |
| Certification Provider: | Microsoft |
| Free Question Number: | 170 |
| Posted: | Oct 20, 2026 |
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 implementing the data load process for a data warehouse.
The data warehouse uses daily partitions to store data added or modified during the last 60 days. Older data is stored in monthly partitions.
You need to ensure that the ETL process can modify the partition scheme during the data load process.
Which component should you use to load the data to the data warehouse?
You have a database named DB1 that contains millions of rows.
You plan to perform a weekly audit of the changes to the rows.
You need to ensure that you can view which rows were modified and the hour that the modification occurred.
What should you do?
You manage a knowledge base in Data Quality Services (DQS).
You need to create a domain that inherits all values, rules, and properties from another domain.
What should you create?
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 choices, 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:
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.
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.
End of repeated scenario
You need to perform the first step to partition the fact .Transaction table.
How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segments in the answer area.
You are designing an indexing strategy for a data warehouse. The data warehouse contains a table named Table1. Data is bulk inserted into Table1.
You plan to create the indexes configured as shown in the following table.
Which type of index should you use to minimize the query times of each index? To answer, drag the appropriate index types to the correct indexes. Each index type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
