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

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 Migration Wizard.
• B.Backup and restore the database.
• C.Deploy the project from SQL Server Data Tools to the production server.
• D.Use the SQL Server Analysis Services Deployment Wizard.

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT).
The report must define a report parameter to prompt the user for the business unit. Each business unit has a unique font scheme combination of font and size properties.
You need to ensure that all of the text boxes in the table headers use the correct business unit font properties.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Add two Microsoft Visual C# functions to the code block of the report to implement FontFamily and FontSize functions. For each header text box, use expressions to set the FontFamily and FontSize properties by using the functions.
• B.Add one report variable for FontFamily Assign it with an expression to return the appropriate colors. For each header text box, set the Color and FontSize properties by using the variables.
• C.Add two report variables named FontFamily and FontSize. Assign them with expressions to return the appropriate colors. For each header text box, use expressions to set the FontFamily and FontSize properties by using the variables.
• D.For each header text box, assign expressions to the FontFamily and FontSize properties.

You execute the following code:

You need to reduce the amount of time it takes to execute the query.
What should you do?

• A.Replace LEFT (CustomerName, 1) = 'a' with CustomerName LIKE 'a%'.
• B.Replace IX_CustomerName with a clustered index.
• C.Partition the table and use the CustomerName column for the partition scheme.
• D.Replace LEFT (CustomerName, 1) = 'a' with SUBSTRING (CustomerName, 1/1) = 'a'.

You are working with multiple tabular models deployed on a single SQL Server Analysis Services (SSAS) instance.
You need to ascertain the memory consumed by each object in the SSAS instance.
What should you do?

• A.Use SQL Server Profiler to review session events for active sessions.
• B.Use the Usage Based Optimization wizard to design appropriate aggregations.
• C.Use the Performance Counter group named Processing.
• D.Use the $System.discover_object_memory_usage dynamic management view.

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A role named Folder Access Controller is present on the server.
The Folder Access Controller role consists of only the Set security for individual items task.
When role members open Report Manager, they cannot view folders.
You need to modify the Folder Access Controller role so that the role members can view folders.
Which task should you add to the Folder Access Controller role?

• A.Manage reports
• B.View reports
• C.Manage folders
• D.Manage models