Question: 1
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. NOTE: Each correct selection is worth one point.
A. file share permissions
B. model object permissions
C. functional area permissions
D. SQL Database permissions
Answer: B,C
Question: 2
You have a data warehouse named DW1. InDvfe you plan to create a table named Tablel that will be partitioned by hour. Tablel will contain the last three hours of data. You plan to implement a sliding window process for inserting data into Tablel. You need to recommend the minimum number of partitions that must be included in Tablel to support the planned implementation. The solution must minimize the number of transaction log records created during the insert process. How many partitions should you recommend?
A. 3
B. 5
C. 9
D. 24
Answer: B
Question: 3
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 SQL Server Management Studio (SSMS). Does the solution meet the goal?
A. Yes
B. No
Answer: B
Question: 4
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
For More Info:
