Login / Register
Sharpen Your Knowledge with Microsoft MCP (70-767) Certification Sample Questions
CertsTime has provided you with a sample question set to elevate your knowledge about the Microsoft Implementing a SQL Data Warehouse exam. With these updated sample questions, you can become quite familiar with the difficulty level and format of the real 70-767 certification test. Try our sample Microsoft Implementing a SQL Data Warehouse certification practice exam to get a feel for the real exam environment. Our sample practice exam gives you a sense of reality and an idea of the questions on the actual Microsoft Certified Professional certification exam.
Our sample questions are similar to the Real Microsoft MCP 70-767 exam questions. The premium Microsoft Implementing a SQL Data Warehouse certification practice exam gives you a golden opportunity to evaluate and strengthen your preparation with real-time scenario-based questions. Plus, by practicing real-time scenario-based questions, you will run into a variety of challenges that will push you to enhance your knowledge and skills.
Microsoft 70-767 Sample Questions:
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?
You manage a Data Quality Services (DQS) knowledge base.
You need to ensure that DQS will create a synonym relationship between identical tags.
What should you create?
Your company manufactures several types of products.
The company has a production tracking application that stores the following data about the products:
The production date
The cost of production
The names of the products
The amount of waste created
The number of products produced
The name of the facility where the products are produced
You are designing a data warehouse for the data. You add a Date dimension.
You need to ensure that you can create a composite primary key for the fact table.
Which two columns should you add to the new dimension tables? Each correct answer presents part of the
solution.
NOTE: Each correct selection is worth one point.
You are developing a Microsoft SQL Server Integration Service (SSIS) package. You enable the SSIS log
provider for the Windows event log. You configure the package to use the ScriptTaskLogEntry event. You
create a custom Script task.
You need to ensure that when the script completes, it writes the execution status to the event log on the server
that hosts SSIS.
Which code segment should you add to the Script task?
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.
Business users observe that the value displayed for the profit margin is the average profit margin across all
products. The profit margin must be calculated per product.
You need to modify the existing model without changing the overall structure of the data model.
What should you use?
Note: If there is any error in our Microsoft 70-767 certification exam sample questions, please update us via email at support@certstime.com.
