Microsoft 70-467 Exam Practice Questions (P. 4)
- Full Access (102 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #18
DRAG DROP -
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.)
Select and Place:
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.)
Select and Place:
Correct Answer:
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.
* To give a database role permission to process a cube
1. In SQL Server Management Studio, connect to the instance of Analysis Services, expand Roles for the appropriate database in Object Explorer, and then double-click a database role (or right-click Roles and select New Role to create a new database role). If this is a new role, make sure that you enter a name for the role in the Role name box.
2. Click Cubes in the Select a Page pane, locate the cube in the Cube list, and then select the Process check box for the cube.
3. Click the OK button.
* There is no write permissions on a cube.
Reference: Grant Process Permissions on an Analysis Services Multidimensional Database
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.
* To give a database role permission to process a cube
1. In SQL Server Management Studio, connect to the instance of Analysis Services, expand Roles for the appropriate database in Object Explorer, and then double-click a database role (or right-click Roles and select New Role to create a new database role). If this is a new role, make sure that you enter a name for the role in the Role name box.
2. Click Cubes in the Select a Page pane, locate the cube in the Cube list, and then select the Process check box for the cube.
3. Click the OK button.
* There is no write permissions on a cube.
Reference: Grant Process Permissions on an Analysis Services Multidimensional Database
Question #19
DRAG DROP -
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.)
Select and Place:
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.)
Select and Place:
Question #20
You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube.
For Customer A, Projected Revenue is defined as 150 percent of the Total Sales for the customer. For all other customers, Projected Revenue is defined as 110 percent of the Total Sales for the customer.
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 Customer A, Projected Revenue is defined as 150 percent of the Total Sales for the customer. For all other customers, Projected Revenue is defined as 110 percent of the Total Sales for the customer.
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.)
All Pages