Microsoft 70-467 Actual Free Exam Questions & Community Discussion
You need to create the Sales Reporting shared SSRS data source.
Which SSRS data connection type should you use?
Which SSRS data connection type should you use?
Correct Answer: B
Vote an answer
You have an OLAP cube named Cube1. Cube1 has two partitions named partition1 and partition2.
You need to configure the storage mode for each cube partition.
The solution must meet the following requirements:
* Users must be able to retrieve aggregate data from partition1 as quickly as possible.
* The processing time for partition1 and partition2 must be minimized.
* The least possible amount of storage must be used for partition2.
What should you do? To answer, select the appropriate storage mode for each partition in the answer area.
You need to configure the storage mode for each cube partition.
The solution must meet the following requirements:
* Users must be able to retrieve aggregate data from partition1 as quickly as possible.
* The processing time for partition1 and partition2 must be minimized.
* The least possible amount of storage must be used for partition2.
What should you do? To answer, select the appropriate storage mode for each partition in the answer area.
Correct Answer:
Explanation
You are administering a SQL Server Analysts Services (SSAS) database on a server. The database hosts a financial cube based on a SQL Azure database.
You need to grant write access to the financial cube for all users in the group USA\PowerUsers.
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 grant write access to the financial cube for all users in the group USA\PowerUsers.
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: In the SQL Management Studio (SSMS), connect to the SSAS instance on the server.
Box 2: Create a new role for the database.
Box 3: Add the USA\PowerUsers group to the role. Set the cube access for the role to Read and Process.
Note:
* A member of the server role for Microsoft SQL Server Analysis Services, or a member of a database role that has Full Control (Administrator) permissions in a particular database, can create a database role that only has permission to process specified objects within the database. Giving a database role permission to process a database object lets an administrator delegate the task of processing certain objects, without also granting extraneous permissions to the user who is performing the processing.
* In SQL Server Management Studio, connect to the instance of Analysis Services, expandRolesfor the appropriate database in Object Explorer, and then double-click a database role (or right-click Rolesand selectNew Roleto create a new database role). If this is a new role, make sure that you enter a name for the role in theRole namebox.
* ClickCubesin theSelect a Page list, and then select theProcesscheck box for the cube.
* Click theOKbutton.
* To give a database role permission to process a cube
* There is no write permissions on a cube.
Reference: Grant Process Permissions on an Analysis Services Multidimensional Database
You are designing a customer dimension for a multidimensional OLAP (MOLAP) database. The dimension table will contain millions of rows of data.
Customer dimension attributes will come from the following two sources:
* An enterprise resource planning (ERP) system that contains millions of rows of data. Attributes from this source will be updated daily.
* A marketing database that contains thousands of rows of data representing customers' geographic information. Attributes from this source will be updated monthly.
Most report queries against the cube use attributes from both sources. Customers in the cube dimension will frequently be filtered by the geographic attributes.
You need to design the dimension table and cube dimension to ensure that report queries perform well, and minimize the time required to reprocess cube attributes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Customer dimension attributes will come from the following two sources:
* An enterprise resource planning (ERP) system that contains millions of rows of data. Attributes from this source will be updated daily.
* A marketing database that contains thousands of rows of data representing customers' geographic information. Attributes from this source will be updated monthly.
Most report queries against the cube use attributes from both sources. Customers in the cube dimension will frequently be filtered by the geographic attributes.
You need to design the dimension table and cube dimension to ensure that report queries perform well, and minimize the time required to reprocess cube attributes.
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 creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube.
For Product A, Projected Revenue is defined as 150 percent of the Total Sales of the product. For all other products, Projected Revenue is defined as 110 percent of the Total Sales of the product.
You need to calculate the Projected Revenue as efficiently as possible.
Which calculation should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
For Product A, Projected Revenue is defined as 150 percent of the Total Sales of the product. For all other products, Projected Revenue is defined as 110 percent of the Total Sales of the product.
You need to calculate the Projected Revenue as efficiently as possible.
Which calculation should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
Correct Answer: C
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 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: A
Vote an answer
You administer a SQL Server Analysis Services (SSAS) cube.
You plan to optimize the cube partitions by using usage-based optimization.
You need to configure the SSAS instance.
Which properties should you configure? To answer, select the appropriate properties in the dialog box in the answer area.
You plan to optimize the cube partitions by using usage-based optimization.
You need to configure the SSAS instance.
Which properties should you configure? To answer, select the appropriate properties in the dialog box in the answer area.
Correct Answer:
Explanation
You need to implement the SalesCommission model to support the planned reports and queries.
What should you do?
What should you do?
Correct Answer: B
Vote an answer
0
0
0
10