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

You need to implement the Customer Sales and Manufacturing data models.
What should you do? (Each correct answer presents a partial solution. Choose all that
apply.)

• A.Use SQL Server Integration Services (SSIS) to copy the database design to the SSAS instance, and specify tabular mode as the destination.
• B.Use the current SSAS instance.
• C.Use SQL Server Data Tools (SSDT) to redevelop and deploy the projects.
• D.Use the Database Synchronization Wizard to upgrade the database to tabular mode.
• E.Install a new instance of SSAS in tabular mode.

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations.
You need to hide the tables and columns.
What should you do?

• A.Right-click the applicable tables and columns and select the Hide option.
• B.In the Properties window for the applicable tables and columns, set the Enabled property to False
• C.Right-click the applicable tables and columns and select the Hide from Client Tools option.
• D.In the Properties window for the applicable tables and columns, set the Visible property to True

You need to use SQL Server Management Studio (SSMS) to make the SSAS databases available for application testing.
What should you do?

• A.Use the Import/Export Wizard to copy the databases from the production server to the development server.
• B.Script the databases as a Create script to a new window and then execute the script on SSAS01.
• C.Restore the SSAS databases from the latest backup to SSAS01.
• D.Detach the SSAS databases from the SSASCluster, and then attach them to SSAS01.

HOTSPOT
A SQL Server Analysis Services (SSAS) cube has roles to define dimension data security. A role named USA allows users to browse data pertaining to the United States. A role named Canada allows users to browse data pertaining to Canada.
A user can browse sales data pertaining to the United States but cannot browse sales data pertaining to Canada. You validate that the user belongs to the USA and Canada roles.
You need to reproduce the issue in SQL Server Management Studio (SSMS).
Which option should you select? To answer, select the appropriate action in the answer area.

正解：

You install SQL Server Reporting Services (SSRS). You need to restore a copy of the symmetric key. Which command should you run?

• A.Rskeymgmt -e -f %temp%\rs.key -p Password1
• B.Rskeymgmt -i
• C.Rskeymgmt -a -f %temp%\rs.key -p Password1
• D.Rskeymgmt -d