web analytics

You need to ensure that the relationship between the product name, the product type, and the product subtype is maintained when products are added to or updates in the database. What should you add to the model?

You create a Master Data Services (MDS) model that manages the master data for a Product dimension. The Product dimension has the following properties: All the members of the Product

You need to ensure that combinations of values stored in the Category and Subcategory attributes are unique. What should you do?

You are developing a Microsoft SQL Server Master Data Services (MDS) solution. The model contains an entity named Product. The Product entity has three user-defined attributes named Category, Subcategory, and

You need to implement the data partitioning strategy. How should you partition the Fact.Order table?

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

You need to modify the data files to minimize latency. What should you do?

You have a data warehouse named DW1. All data files are located on drive E. You expect queries that pivot hundreds of millions of rows for each report. You need

Which stored procedure should you execute first?

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

What should you do?

You have a data warehouse named DW1 that contains 20 years of data. DW1 contains a very large fact table. New data is loaded to the fact table monthly. Many

You need to recommend a solution to perform the actions. What should you recommend?

You manage Master Data Services (MDS). You plan to create entities and attributes and load them with the data. You also plan to match data before loading it into Data

You need to recommend an appropriate dimension usage relationship. What 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

You need to implement the data partitioning strategy. How should you partition the Fact.Order table?

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

You need to ensure that you can view which rows were modified and the hour that the modification occurred. What should you do?

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

Which deployment method should you use for the packages?

You plan to deploy several Microsoft SQL Server Integration Services (SSIS) packages to a highly available SQL Server instance. The instance is configured to use an AlwaysOn availability group that

How many partitions should you recommend?

You have a data warehouse named DW1. In DW1, you plan to create a table named Table1 that will be partitioned by hour. Table1 will contain the last three hours

Which RAID configuration should you recommend?

You are building a server to host a data warehouse. The planned disk activity for the data warehouse is five percent write activity and 95 percent read activity. You need

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?

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

Which component should you use to load the data to the data warehouse?

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 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?

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

You need to ensure that the job loads changes from the previous week. Which stored procedure should you execute?

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

You need to roll back the Integration Services package to the previous version. Which stored procedure should you execute?

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

You need to stop tracking changes to the database temporarily. The solution must ensure that tracking changes can be restored quickly in a few weeks. Which stored procedure should you execute?

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

Your SQL Server login is a member of only the ssis_admin database role. Which stored procedure should you execute?

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

You need to stop tracking changes to the database. The solution must remove all the change data capture configurations from DB1. Which stored procedure should you execute?

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

You need to ensure that a downstream system can consume data in a Master Data Services (MDS) system. What should you configure?

You need to ensure that a downstream system can consume data in a Master Data Services (MDS) system. What should you configure? A. a Data Collector B. a knowledge base

You need to configure the Similarity of Similar percentage that defines a match. Which similarity percentage will always generate a similarity score of 0?

You have a server that has Data Quality Services (DQS) installed. You create a matching policy that contains one matching rule. You need to configure the Similarity of Similar percentage

Solution: You modify the weight of the domain in the matching rule. Does this meet the goal?

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.

Solution: You create a matching rule. Does this meet the goal?

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.

Solution: You profile the data. Does this meet the goal?

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.

Solution: You configure the server to automatically delete the transaction logs nightly. Does this meet the goal?

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.

Solution: You add more data files to DB1. Does this meet the goal?

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.

Solution: You replace the SATA disks with SSD disks. Does this meet the goal?

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.

You need to add a Data Quality Services (DQS) domain rule in the Products domain. Which rule should you use?

You have a data quality project that focuses on the Products catalog for the company. The data includes a product reference number. The product reference should use the following format:

You need to optimize the storage for the data warehouse. What change should you make?

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

How should you partition the Fact.Order table?

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

Create a new row in the data warehouse Products table with the new ReferenceNr value. Does the solution meet the goal?

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.

Does the solution meet the goal?

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.

Does the solution meet the goal?

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.

Solution: You use SQL Server Management Studio (SSMS). Does the solution meet the goal?

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.

Solution: You use the Azure portal. Does the solution meet the goal?

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.

Solution: You use SQL Server Configuration Manager. Does the solution meet the goal?

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.