70-767 무료 덤프문제 온라인 액세스
| 시험코드: | 70-767 |
| 시험이름: | Implementing a SQL Data Warehouse |
| 인증사: | Microsoft |
| 무료 덤프 문항수: | 170 |
| 업로드 날짜: | 2025-08-30 |
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 a Microsoft SQL Server data warehouse with a multi-dimensional data model.
When testing a pilot version of the data warehouse, business users observe that the number of products in stock is inaccurate. The number of products in stock always increases and represents the total number of products that have ever been in stock.
You need to correct the existing model and ensure that it reflects the number of in-stock products. You must not change the overall structure of the data model.
What should you do?
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?
You are using Microsoft SQL Server data Tools (SSID) to create a SQL Server Information Services (SSIS) package. The package contains a single Data Flow task as shown in the Data Flow exhibit. (Click the Data Flow tab.) Project properties are provided in the Project Properties exhibit. (Click the Project Properties tab.)
The data flow imports a remote Microsoft Excel file if it exists. You have all of the appropriate permissions to access the file.
The package fails to complete. The error message is shown in the Execution Results exhibit. (Click the Execution Results tab.) Execution Results
You need to resolve the issue and ensure that you can run the package on a scheduled basis.
For each of the following statements, select Yes if the statement is true. otherwise, select No.
You manage Master Data Services (MDS).
You need to create a new entity with the following requirements:
* Maximize the performance of the MDS system.
* Ensure that the Entity change logs are stored.
You need to configure the transaction Log Type settings.
Which type should you use?
Note: This question is part of a series of questions that present 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 scenarios is exactly the same in each question in this series.
You are developing a Master Data Management (MDM) solution for a company by using Microsoft SQL Server Integration Services (SSIS), SQL Server Master Data Services (MDS), and SQL Server Data Quality Services (DQS).
You have an MDS model named Geography that contains the entities described in the following table.
You define a domain-based attribute in the State entity that references the CountryRegion entity. You define another domain-based attribute in the city entity that references the State and CountryRegion entities. A single derived hierarchy named Geography supports navigation between the CountryRegion, State, and City levels.
Subscription views exist for all entities. The subscription views have the same name as the entity on which they are based.
You initialize each entity member. New City entity members are imported daily based on customer city values in a Customer Relationship Management (CRM) database. The CRM database is a SQL Server relational database. When new cities are imported from the CRM database, the state codes must be standardized to those already defined in the State entity.
In the CRM database, sales managers and assigned to countries/regions. A sales manager may be assigned to one or more countries/regions. A country/region may have one or more assigned sales managers. The CRM database contains a table named ManagerCountryRegion that stores a row for each manager-country/region relationship.
You create the following MDS users and map each user to an Active Directory Domain Services (AD DS) user account: User1, User2, and User3. Both User1 and User2 belong to the Explorer functional area.
Users must be able to complete the tasks described in the following table.
You need to perform the initial data loading process of the DQS knowledge base, based on the CountryRegion Entity in the MDS model.
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.
