Free Microsoft 70-767 Exam Dumps Questions & Answers

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.

Correct Answer:

Explanation

Box 1: Validate the current version.
In Master Data Services, validate a version to apply business rules to all members in the model version.
You can validate a version after it has been locked.
Box 2: Commit the current version.
In Master Data Services, commit a version of a model to prevent changes to the model's members and their attributes. Committed versions cannot be unlocked.
Prerequisites:
Box 3: Create a copy of the current version.
In Master Data Services, copy a version of the model to create a new version of it.
Note:
References:

You are implementing a Microsoft SQL Server data warehouse with a multi-dimensional data model.
Orders are stored in a table named Factorder. The addresses that are associated with all orders are stored in a fact table named FactAddress. A key in the FoctAddress table specifies the type of address for an order.
You need to ensure that business users can examine the address data by either of the following:
* shipping address and billing address
* shipping address or billing address type
Which data model should you use?

• A.star schema
• B.fact table
• C.slowly changing dimension (SCD)
• D.conformed dimension
• E.semi-additive measure
• F.non-additive measure
• G.dimension table reference relationship
• H.snowflake schema

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 have a database named DB1 that has change data capture enabled.
A Microsoft SQL Server Integration Services (SSIS) job runs once weekly. The job loads changes from DB1 to a data warehouse by querying the change data capture tables.
You discover that the job loads changes from the previous three days only.
You need re ensure that the job loads changes from the previous week.
Which stored procedure should you execute?

• A.catalog.deploy_project
• B.catalog.restore_project
• C.sys.sp_cdc_disable_db
• D.sys.sp_cdc.stopJob
• E.sys.sp.cdc.changejob
• F.sys.sp_cdc_enable_db
• G.sys.sp_cdc.addJob
• H.catalog.stop.operation

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 Microsoft Azure SQL Data Warehouse instance that must be available six months a day for reporting.
You need to pause the compute resources when the instance is not being used.
Solution: You use the Azure portal.
Does the solution meet the goal?

• A.No
• B.Yes

You are developing a Microsoft SQL Server Integration Services (SSIS) package. You create a data flow that has the following characteristics:
* The package moves data from the table [source].Tabid to DW.Tablel.
* All rows from [source].Table1 must be captured in DW.Tablel for error.Tablel.
* The table error.Tablel must accept rows that fail upon insertion into DW.Tablel due to violation of nullability or data type errors such as an invalid date, or invalid characters in a number.
* The behavior for the Error Output on the "OLE DB Destination" object is Redirect.
* The data types for all columns in [sourceJ.Tablel are VARCHAR. Null values are allowed.
* The Data access mode for both OLE DB destinations is set to Table or view - fast load.


Use the drop-down menus to select the answer choice that answers each question.

Correct Answer: