070-768 試験問題を無料オンラインアクセス

You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant the minimum permissions necessary to enable users to query data in a data model.
Which role permission should you use?

• A.Process
• B.Explorer
• C.Read
• D.Administrator
• E.Select
• F.Browser

You are developing a SQL Server Analysis Services (SSAS) tabular project for a Power View solution.
You need to grant permission for salespersons to view only the data based on their sales territory.
What should you do?

• A.Use SQL Server Management Studio to create a role. Then create a Multidimensional Expressions (MDX) filter.
• B.Create a member and then create a Multidimensional Expressions (MDX) filter.
• C.Use SQL Server Management Studio to create a role. Then create a Data Analysis Expressions (DAX) filter.
• D.Create a member and then create a Data Analysis Expressions (DAX) filter.

You are developing a SQL Server Analysis Services (SSAS) tabular project.
In the data warehouse, a table named Sales Persons and Territories 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 need to use the least amount of development effort to achieve this goal.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Create a new role named Sales Persons with Read permission.
  Add each salesperson's logon as a member to the role.
• B.Create a separate tabular model for each sales territory and assign each tabular model a corresponding sales territory name.
  Grant each salesperson access to the corresponding tabular model of the assigned sales territory.
• C.Add the Sales Persons and Territories 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 new Active Directory Domain Services (AD DS) security group and add each salesperson as a member.
  Then create a new role named Sales Persons with Read permission.
  Add the group as a member to the new role.

You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used by the finance, sales, and marketing teams.
The sales team reports that the model is too complex and difficult to use. The sales team does not need any information other than sales-related resources in the tabular model. The finance and marketing teams need to see all the resources in the tabular model.
You need to implement a solution that meets the needs of the sales team while minimizing development and administrative effort.
What should you do?

• A.Create a separate data source for each team.
• B.Create a separate partition for each team.
• C.Enable client side security to filter non-sales data.
• D.Create a perspective for the sales team.

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You administer a Microsoft SQL Server Analysis Services (SSAS) tabular model for a travel agency that specializes in vacation packages. Vacation bookings and packages are stored in a SQL Server database. You use the model as the basis for customer emails that highlight vacation packages that are currently underbooked, or projected to be underbooked.
The company plans to incorporate cruise ship vacation packages. Cruise ship vacation packages include new features such as region availability and cruise line specialties that require changes to the tabular model.
You must ensure that the tabular model reflects the new vacation packages.
You need to configure the tabular data model.
What should you do?

• A.Process the model in Process Defrag mode.
• B.Process the model in Process Full mode.
• C.Ensure that DirectQuery is disabled for the model.
• D.Process the model in Process Data mode.
• E.Ensure that the Transactional Deployment property is set to True.
• F.Ensure that the Transactional Deployment property is set to False.
• G.Ensure that DirectQuery is enabled for the model.