Microsoft-Transition Your MCITP Business Intelligence Developer 2008 to MCSE Business Intelligence

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis Services (SSAS). You are configuring security for a tabular project model. You are evaluating the tabular project model roles to determine which users should be assigned to the roles. Company security policy states that all users must be assigned the minimum permissions to perform their required tasks. Which role should users be assigned to to enable them to query data in a data model?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis Services (SSAS). You are configuring security for a tabular project model. You are evaluating the tabular project model roles to determine which users should be assigned to the roles. Company security policy states that all users must be assigned the minimum permissions to perform their required tasks. Which role should users be assigned to to enable them to run Process and Process All operations whilst ensuring they cannot modify the model schema and cannot query data?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis Services (SSAS). You are configuring security for a tabular project model. You are evaluating the tabular project model roles to determine which users should be assigned to the roles. Company security policy states that all users must be assigned the minimum permissions to perform their required tasks. Which role should users be assigned to to enable them to make modifications to the model schema and query all data?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. Company users use a SQL Server Analysis Services (SSAS) cube. You receive reports that an MDX query takes a long time to run. You are using a SQL Server Profiler trace to troubleshoot the query performance issues. You need to gather information about the MDX query statement. Which SQL Server Profile Event Class should you select in the Trace Properties dialog box to identify the MDX query statement?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. The company has a large database named CorpDB which contains terabytes of data. CorpDB is the data source for a SQL Server Analysis Services (SSAS) multidimensional project. The cube is scheduled to begin processing at 1:00 A.M every morning. The processing of the largest partition in the cube takes over 10 hours to complete. You receive complaints from users that they are unable to access the cube until 11:00 A.M. You need to modify the cube to improve the processing time so that users can query the cube as early as possible. Your solution must ensure that CorpDB is not accessed by the cube to respond to queries. Which setting should you configure?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You are configuring servers running SQL Server Reporting Services (SSRS). All SSRS servers run in native mode. You need to configure a report server to use a different report server database. Therefore you need to restore a copy of the Reporting Services encryption keys from backup. The backup file is a:\rsdbkey.snk and the password for the backup is RSKeyPass1. Which of the following commands should you run?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You are configuring servers running SQL Server Reporting Services (SSRS). All SSRS servers run in native mode. You want to back up the Reporting Services encryption keys to enable you to reuse an existing report server database in a new installation. You plan to back up the keys to a floppy disk drive. The backup file must be named rsdbkey.snk and the backup protected with a password of RSKeyPass1. Which of the following commands should you run?

You work as a Database Administrator (DBA) at ABC.com. A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis Services (SSAS). Another Windows Server 2012 server named ABC-SSRS01 runs SQL Server 2012 Reporting Services (SSRS). You are using ABC-SSRS01 to create a report named Current Performance for the Sales department. Sales users need to be able to view the report and see if they are currently behind, on target or ahead of a sales Key Performance Indicator (KPI). A green circle should be displayed if the user is ahead of target, a yellow circle should be displayed if the user is on target, and a red circle should be displayed if the user is behind target. Which of the following report items would be appropriate for your report?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You are using SQL Server Reporting Services (SSRS) to create a report named Quarterly Sales Performance for the Sales department. Sales users need to use the report to view sales trends over the last three months. Which of the following report items could you use in your report? (Choose all that apply)

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You are using SQL Server Reporting Services (SSRS) to create a report to display the names of the company Sales staff and their total sales to date this year. You add a table containing two columns named SalesPersonName and SalesToDate to the report. You plan to define three bands for sales targets: High Sales, Medium Sales and Low Sales. The value in the SalesToDate column will determine which band the sales user is in. You want the report to display the name of the sales person in green for High Sales, yellow for Medium Sales and red for Low Sales. How should you configure the report?