Microsoft Designing Business Intelligence Solutions with Microsoft SQL Server - 70-467 Exam Practice Test
You need to prepare the infrastructure for the planned implementation of Gallery1.
Which three actions should you perform? Each correct answer presents part of the solution,
Which three actions should you perform? Each correct answer presents part of the solution,
Correct Answer: A,B,D
Vote an answer
You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic.
You have the following requirements:
* Ensure that queries of the data model correctly display average student age by class.
* Ensure that the solution supports role-based security and partitions.
* Minimize development effort.
You need to design the data model.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You have the following requirements:
* Ensure that queries of the data model correctly display average student age by class.
* Ensure that the solution supports role-based security and partitions.
* Minimize development effort.
You need to design the data model.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Correct Answer: B
Vote an answer
A group of report writers develop reports. The report writers currently use Report Builder 1.0 and report models. The report writers are not trained on SQL Server query writing. Their report assignments come from various departments within the organization.
The company is upgrading to SQL Server 2012 with SQL Server Reporting Services (SSRS) in native mode.
After the upgrade, reports will retrieve data from a large new data warehouse that will reside on an instance of the SQL Server 2012 Database Engine. Reports for each department will retrieve data from only a subset of the data warehouse tables.
You are designing the data access strategy. You have the following requirements:
* Ensure that report writers can create only reports that display data which they have database permissions to view.
* Minimize the effort required to update connection strings for all reports developed by the report writers.
* Minimize the number of fields visible in a specific report for report writers who work for multiple departments.
You need to design the data access strategy.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
The company is upgrading to SQL Server 2012 with SQL Server Reporting Services (SSRS) in native mode.
After the upgrade, reports will retrieve data from a large new data warehouse that will reside on an instance of the SQL Server 2012 Database Engine. Reports for each department will retrieve data from only a subset of the data warehouse tables.
You are designing the data access strategy. You have the following requirements:
* Ensure that report writers can create only reports that display data which they have database permissions to view.
* Minimize the effort required to update connection strings for all reports developed by the report writers.
* Minimize the number of fields visible in a specific report for report writers who work for multiple departments.
You need to design the data access strategy.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Correct Answer: D
Vote an answer
You are configuring an Excel Services service application in a Microsoft SharePoint farm.
Users will deploy Excel workbooks to SharePoint libraries that allow interaction with PivotTables through Excel Services. PivotTable data is sourced from secured SQL Server Analysis Services (SSAS) cubes and PowerPivot models inside published workbooks.
You need to ensure that users can refresh the PivotTables from within Excel Services without a warning message appearing.
What should you do?
To answer, drag the appropriate term or terms to the correct location or locations in the answer area. (Use only terms that apply.)
Users will deploy Excel workbooks to SharePoint libraries that allow interaction with PivotTables through Excel Services. PivotTable data is sourced from secured SQL Server Analysis Services (SSAS) cubes and PowerPivot models inside published workbooks.
You need to ensure that users can refresh the PivotTables from within Excel Services without a warning message appearing.
What should you do?
To answer, drag the appropriate term or terms to the correct location or locations in the answer area. (Use only terms that apply.)
Correct Answer:
Explanation
Box 1:
Box 2:
Box 3:
You need to select the appropriate mode for the Sales database.
Which mode should you select?
Which mode should you select?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You are validating whether a SQL Server Integration Services (SSIS) package named Master.dtsx in the SSIS catalog is executing correctly.
You need to display the number of rows in each buffer passed between each data flow component of the package.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
You need to display the number of rows in each buffer passed between each data flow component of the package.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Correct Answer:
Explanation
Box 1:
Box 2:
Box 3:
Note:
* You are going to become very very familiar indeed with [catalog].[executions]. It is a view that provides a record of all package executions on the server and, most importantly, it contains [execution_id] - the identifier for each execution and the field to which all other objects herein will be related.
You need to recommend a SQL Server Integration Services (SSIS) package design that meets the ETL requirements.
What should you include in the recommendation?
What should you include in the recommendation?
Correct Answer: A
Vote an answer
You are designing a strategy for an enterprise reporting solution that uses SQL Server Reporting Services (SSRS).
Many of the SSRS reports will use common utilities and functions, including the following:
* Report utility functions and business logic in code
* Standardized report formatting properties such as fonts and colors for report branding Formatting may change and new functions may be added as the reporting solution evolves.
You need to create a strategy for deploying the formatting and code across the entire enterprise reporting solution. You must also ensure that reports can be easily updated to reflect formatting and function changes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Many of the SSRS reports will use common utilities and functions, including the following:
* Report utility functions and business logic in code
* Standardized report formatting properties such as fonts and colors for report branding Formatting may change and new functions may be added as the reporting solution evolves.
You need to create a strategy for deploying the formatting and code across the entire enterprise reporting solution. You must also ensure that reports can be easily updated to reflect formatting and function changes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Correct Answer: A
Vote an answer
You need to implement the date dimension in the Operations database.
What should you do?
What should you do?
Correct Answer: B
Vote an answer
You need to ensure that the Sales Per Capita calculated measure produces correct results.
What should you do?
What should you do?
Correct Answer: A
Vote an answer
You need to configure Library1 to support the planned self-service reports.
What is the best configuration you should add to Library1? More than one answer choice may achieve the goal. Select the BEST answer.
What is the best configuration you should add to Library1? More than one answer choice may achieve the goal. Select the BEST answer.
Correct Answer: B
Vote an answer