Microsoft
70-467 · Question #173
70-467 Question #173: Real Exam Question with Answer & Explanation
Sign in or unlock 70-467 to reveal the answer and full explanation for question #173. The question stem and answer options stay visible for context.
Question
A hospital has a relational data warehouse, a SQL Server Analysis Services (SSAS) database, and a SQL Server Reporting Services (SSRS) instance. The SSAS database contains a cube named Pharmacy. Shared data sources exist in SSRS for the relational and SSAS databases. Each hospital department has its own report writers. Report writers in the Human Resources (HR) department want to create new reports by using Report Builder. Many reports will include data generated by a custom formula that references data stored either in a data warehouse table or in the Pharmacy cube. The custom formula will compare time periods across multiple products, categories, and employees. You have the following requirements: - Ensure that only the HR department report writers can access the custom formula. - Implement only one dataset. - Ensure that the dataset references the data source that will provide the fastest data retrieval. You need to meet the requirements to support the HR department report writers. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- ACreate, deploy, and secure a shared dataset that references the data warehouse shared
- BCreate a calculated member in the Pharmacy cube.
- CCreate and secure in the data warehouse a stored procedure that implements the custom
- DCreate, deploy, and secure a shared dataset that references the SSAS database shared data
Unlock 70-467 to see the answer
You've previewed enough free 70-467 questions. Unlock 70-467 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.