Online Access Free 70-460 Practice Test

You are designing a customer dimension for a multidimensional OLAP (MOLAP) database. The dimension table will contain millions of rows of data.
Customer dimension attributes will come from the following two sources:
- An enterprise resource planning (ERP) system that contains millions of rows of data. Attributes from this source will be updated daily.
- A marketing database that contains thousands of rows of data representing customers' geographic information. Attributes from this source will be updated monthly.
Most report queries against the cube use attributes from both sources. Customers in the
cube dimension will frequently be filtered by the geographic attributes.
You need to design the dimension table and cube dimension to ensure that report queries perform well, and minimize the time required to reprocess cube attributes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Create one dimension table that combines data from both sources. Create a cube dimension for each source.
• B.Create a dimension table for each source, and a cube dimension for each source.
• C.Create a dimension table for each source. Create one cube dimension that joins the two dimension tables together.
• D.Create one dimension table that combines data from both sources. Create one cube dimension that references the dimension table.

You need to perform the pre-upgrade database backup operation by using SQL Server Management Studio (SSMS).
How should you configure the backup options?

• A.Clear the Apply compression check box. Select the Encrypt backup file check box and supply a password.
• B.Select the Apply compression check box. Clear the Encrypt backup file check box.
• C.Select the Apply compression check box. Select the Encrypt backup file check box and supply a password.
• D.Clear the Apply compression check box. Clear the Encrypt backup file check box.

You need to implement security in the cube to limit the sites visible to each user.
What should you do?

• A.Create an SSAS database role and define a Multidimensional Expressions (MDX) calculation to implement dynamic dimension security.
• B.Create a view on the SalesTransactions table that uses the SecurityFilter and User table data to limit the sites for each user.
• C.Create an SSAS database role in the cube for each user and assign the sites each user can access to his or her database role.
• D.Create an SSAS server role for each user and assign the sites each user can access to his or her server role.

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.

Correct Answer:

You are creating a new report in SQL Server Report Builder. You add a Windows Azure SQL Database data source. Then you add a dataset that has four fields named Year, Country, Category, and Sales.
You must design a matrix as shown in the following table.

The category rows (the first three rows as shown in the diagram) must present total sales amount by category. The country rows (the next six rows as shown in the diagram) must present total sales amount by country. The total row must present the total sales for each year.
You add a matrix to the report. You add a grouping of the Country field on the rows and a grouping of the Year field on the columns.
You need to add the categories on the rows of the matrix.
Which Row Group option should you select when you add the group?

• A.Parent Group
• B.Adjacent Above
• C.Adjacent Below
• D.Child Group