Valid 70-767 Dumps shared by PassLeader for Helping Passing 70-767 Exam! PassLeader now offer the newest 70-767 VCE dumps and 70-767 PDF dumps, the PassLeader 70-767 exam questions have been updated and ANSWERS have been corrected, get the newest PassLeader 70-767 dumps with VCE and PDF here: https://www.passleader.com/70-767.html (377 Q&As Dumps –> 407 Q&As Dumps)
BTW, DOWNLOAD part of PassLeader 70-767 dumps from Cloud Storage: https://drive.google.com/open?id=0B-ob6L_QjGLpcXZXWUl4dHhIUVk
NEW QUESTION 363
You create a set of Microsoft SQL Server Integration Services (SSIS) packages to support an ETL process. You need to deploy the SSIS packages and meet the following requirements:
– Maximize ease of use for backup processes.
– Manage security of packages from a single place.
– Maintain versioning pf packages.
– Implement parameters to assign values to packages.
– Use stored procedures to run SSIS packages.
– Use SQL Server Agent to run packages.
Solution: You use the Project Deployment model with an SSIS catalog to store and manage packages.
Does this meet the goal?
A. Yes
B. No
Answer: A
Explanation:
Built-in stored procedures only work for with an SSIS catalog to store.
https://docs.microsoft.com/en-us/sql/integration-services/packages/run-integration-services-ssis-packages
NEW QUESTION 364
You create a set of Microsoft SQL Server Integration Services (SSIS) packages to support an ETL process. You need to deploy the SSIS packages and meet the following requirements:
– Maximize ease of use for backup processes.
– Manage security of packages from a single place.
– Maintain versioning pf packages.
– Implement parameters to assign values to packages.
– Use stored procedures to run SSIS packages.
– Use SQL Server Agent to run packages.
Solution: You use the Project Deployment model. You save the packages to the msdb database.
Does this meet the goal?
A. Yes
B. No
Answer: B
Explanation:
Built-in stored procedures only work for with an SSIS catalog to store.
https://docs.microsoft.com/en-us/sql/integration-services/packages/run-integration-services-ssis-packages
NEW QUESTION 365
You are the administrator of a Microsoft SQL Server Master Data Services (MDS) instance. The instance contains a model named Geography and a model named Customer. The Geography model contains an entity named CountryRegion. You need to ensure that the CountryRegion entity members are available in the customer model.
Solution: In the Geography model, publish a business rule with a Change Value action.
Does this meet the goal?
A. Yes
B. No
Answer: B
Explanation:
Instead configure an entity sync relationship to replicate the CountryRegion entity. Note: In Master Data Services, a business rule is a rule that you use to ensure the quality and accuracy of your master data. You can use a business rule to automatically update data, to send email, or to start a business process or workflow.
https://docs.microsoft.com/en-us/sql/master-data-services/entity-sync-relationship-master-data-services
NEW QUESTION 366
You are the administrator of a Microsoft SQL Server Master Data Services (MDS) instance. The instance contains a model named Geography and a model named Customer. The Geography model contains an entity named CountryRegion. You need to ensure that the CountryRegion entity members are available in the customer model.
Solution: Configure an entity sync relationship to replicate the CountryRegion entity.
Does this meet the goal?
A. Yes
B. No
Answer: A
Explanation:
Entity sync is a one-way and repeatable synchronization between entity versions. It enables you to share entity data between different models. You can keep a single source of truth in one model and reuse this master data in other models. For example, you can store US state data in one model entity and reuse that data in other models.
https://docs.microsoft.com/en-us/sql/master-data-services/entity-sync-relationship-master-data-services
NEW QUESTION 367
You manage the user accounts in master data Services (MDS). You need to assign a user access to the MDS data and functions. Which two components must you assign? (Each correct answer presents part of the solution. Choose two.)
A. file share permissions
B. model object permissions
C. functional area permissions
D. SQL Database permissions
Answer: BC
Explanation:
B: In Master Data Services, assign permissions to model objects when you need to give a user or group access to data in the Explorer functional area of Master Data Manager, or when you need to make a user or group an administrator.
C: Assign functional area permission to grant users or groups access to the functional areas of Master Data Manager.
https://docs.microsoft.com/en-us/sql/master-data-services/assign-model-object-permissions-master-data-services
https://docs.microsoft.com/en-us/sql/master-data-services/assign-functional-area-permissions-master-data-services
NEW QUESTION 368
You are implementing a Microsoft SQL Server data warehouse with a multi-dimensional data model. You are optimizing the data model across multiple cubes. You examine the existing data model and observe that each cube contains multiple date dimension tables. You need to optimize the data model in and across cubes without changing the overall table structure. What should you use?
A. star schema
B. snowflake schema
C. conformed dimension
D. slowly changing dimension (SCD)
E. fact table
F. semi-additive measure
G. non-additive measure
H. dimension table reference relationship
Answer: C
Explanation:
In data warehousing, a conformed dimension is a dimension that has the same meaning to every fact with which it relates. Conformed dimensions allow facts and measures to be categorized and described in the same way across multiple facts and/or data marts, ensuring consistent reporting across the enterprise. A conformed dimension can exist as a single dimension table that relates to multiple fact tables within the same data warehouse, or as identical dimension tables in separate data marts. Date is a common conformed dimension because its attributes (day, week, month, quarter, year, etc.) have the same meaning when joined to any fact table.
Incorrect:
Not H: Dimension usage defines the relationships between a cube dimension and the measure groups in a cube.
https://searchdatamanagement.techtarget.com/definition/conformed-dimension
NEW QUESTION 369
You are implementing a Microsoft SQL Server data warehouse with a multi-dimensional data model. Sales information is stored in a single table. The table includes the order date, expected shipping date, promotion ID, currency, and sales office columns. A dimension table exists for each attribute. Business users must be able to examine the sales data based on dates, promotions, currency, and the office of the sale. You need to design the data model. Which data model should you use?
A. star schema
B. snowflake schema
C. conformed dimension
D. slowly changing dimension (SCD)
E. fact table
F. semi-additive measure
G. non-additive measure
H. dimension table reference relationship
Answer: A
Explanation:
https://www.guru99.com/star-snowflake-data-warehousing.html
NEW QUESTION 370
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?
A. star schema
B. snowflake schema
C. conformed dimension
D. slowly changing dimension (SCD)
E. fact table
F. semi-additive measure
G. non-additive measure
H. dimension table reference relationship
Answer: G
Explanation:
There are three types of facts:
– Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.
– Additive: Additive facts are facts that can be summed up through all of the dimensions in the fact table.
– Semi-Additive: Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others.
https://www.1keydata.com/datawarehousing/fact-table-types.html
NEW QUESTION 371
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. Choose two.)
A. Cost of Production
B. Amount Produced
C. Waste Amount
D. Product Name
E. Facility Name
Answer: DE
Explanation:
Both the Product Name and the Facility Name are unique.
NEW QUESTION 372
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?
A. new domain
B. linked domain
C. term-based relations
D. new knowledge base
Answer: C
Explanation:
If a term-based relation transformation causes two values to be identical, then DQS will create a synonym relationship between them (in knowledge discovery), a correction relationship between them (in data correction), or an exact match (in matching).
https://docs.microsoft.com/en-us/sql/data-quality-services/create-term-based-relations
NEW QUESTION 373
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?
A. Simple
B. Full
C. Member
D. Attribute
E. None
Answer: C
Explanation:
Member provides better performance than Attribute.
Incorrect:
Not A, B: You can change the transaction log type of an entity, to attribute, member, or none.
Not E: None. No change logs are saved. Provides the best performance.
https://docs.microsoft.com/en-us/sql/master-data-services/change-the-entity-transaction-log-type-master-data-services
NEW QUESTION 374
Drag and Drop
A company is designing a database storage strategy. The company wants to segment online transaction processing (OLTP) and analytic workloads. You need to design the workload. Which index types should you use? (To answer, drag the appropriate index types to the correct workloads. 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.)
Answer:
Explanation:
https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/indexes-for-memory-optimized-tables
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-analytical-processing
NEW QUESTION 375
HotSpot
You have a data warehouse that includes three databases named DB1, DB2, and DB3 respectively. The data warehouse no longer meets the needs of users. You plan to modify the design of the data warehouse. The dimensions in the databases have the following requirements:
– DB1 must support overwriting history
– DB2 must support preserving all history
– DB3 must support preserving a version of history
You need to design the slowly changing dimensions (SCDs) for the databases. For each database, which SCD type should you use? (To answer, select the appropriate SCD types in the answer area.)
Answer:
Explanation:
https://en.wikipedia.org/wiki/Slowly_changing_dimension
NEW QUESTION 376
……
Get the newest PassLeader 70-767 VCE dumps here: https://www.passleader.com/70-767.html (377 Q&As Dumps –> 407 Q&As Dumps)
And, DOWNLOAD the newest PassLeader 70-767 PDF dumps from Cloud Storage for free: https://drive.google.com/open?id=0B-ob6L_QjGLpcXZXWUl4dHhIUVk