Free Microsoft 70-466 Exam Dumps Questions & Answers

You are developing a SQL Server Analysis Services (SSAS) tabular project.
In the data warehouse, a table named Employee Security defines a relationship between a salesperson's name, logon ID, and assigned sales territory.
You need to ensure that each salesperson has access to data from only the sales territory assigned to that salesperson. You also need to minimize the development effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.  Create a new Active Directory Domain Services (AD DS) security group and add each salesperson as a member. Then create a new role with Read permission. Add the group as a member to the new role.
• B.  Create a new role with Read permission and then add each salesperson's logon as a member to the role.
• C.  Add the Employee Security table to the model, define the relationships, and then implement dynamic security by using row filters. Grant each salesperson access to the model.
• D.  Create a separate tabular project for each sales territory. Grant each salesperson access to the corresponding tabular model of the assigned sales territory.

You manage a SQL Server Reporting Services (SSRS) instance in SharePoint integrated mode.
You identify a problem with the operations performed by the Report Server Web service.
You need to view the Report Server trace logs. In which directory should you view the files?

• A.  %ProgramFiles%\Common Files\Microsoft Shared\Web Server Extensions\14\Web Services\ReportServer\LogFiles
• B.  %ProgramFiles%\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting
  Services\LogFiles
• C.  %ProgramFiles%\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting
  Services\LogFiles
• D.  %ProgramFiles%\Common Files\ReportServer\LogFiles

You work in the Business Intelligence (BI) department of a multinational company.
To share its sales data between the various subsidiaries, the company has requested a new corporate BI solution that meets the following requirements:
* The solution must use SQL Server Analysis Services (SSAS) multidimensional or tabular Business Intelligence Semantic Model (BISM).
* The model must incrementally add 10 million fact rows of sales data per month.
* The model must be translated to English, German, Chinese, or Spanish based on users' locale.
* The model must be able to contain the most recent 36 months of data, in order to let users query the data.
You need to select the appropriate model type and partitioning strategy to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.  Create and deploy a BISM tabular model with one partition for all of the data.
• B.  Create and deploy a BISM tabular model with one partition for each of the 36 months.
• C.  Create and deploy a BISM multidimensional model with one partition for all of the data.
• D.  Create and deploy a BISM multidimensional model with one partition for each of the 36 months.

You need to develop the executive reports.
What should you do? (Each correct answer presents part of the solution. Choose ail that apply.)

• A.  Implement dataset query parameters to filter data.
• B.  Provide default values for all parameters.
• C.  Set the data source to use stored Windows credentials.
• D.  Set the data source to use Windows authentication.
• E.  Remove default values from all parameters.
• F.  Implement dataset filters to filter data.

You are deploying an update to a SQL Server Analysis Services (SSAS) cube to a production environment.
The production database has been configured with security roles.
You need to preserve the existing security roles in the production database. Database roles and their user accounts from the development environment must not be deployed to the production server.
Which deployment method should you use?

• A.  Use the SQL Server Analysis Services Deployment Wizard.
• B.  Backup and restore the database.
• C.  Use the SQL Server Analysis Services Migration Wizard.
• D.  Deploy the project from SQL Server Data Tools to the production server.