Online Access Free 70-470 Exam Questions

You need to select a method of moving data from the staging tables to the factOrders table.
What type of Transact-SQL (T-SQL) statement should you use?

• A.ALTER PARTITION FUNCTION
• B.ALTER PARTITION-SWITCH
• C.SELECT...INTO
• D.ALTER TABL..SWITCH
• E.INSERT INTO...SELECT

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.in the Properties window for the applicable tables and columns, set the Enabled property to False.
• B.Right-click the applicable tables and columns and select the Hide option.
• 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 ensure that you can monitor the usage data.
What should you do?

• A.In Reporting Services Configuration Manager, enable report execution logging.
• B.In the PowerPivot Configuration Tool, upgrade PowerPivot for SharePoint.
• C.In SharePoint Central Administration, enable usage data collection.
• D.In the PowerPivot Configuration Tool, repair PowerPivot for SharePoint.

DRAG DROP
You are designing a SQL Server Reporting Services (SSRS) solution.
A report project must access multiple SQL Azure databases. Each database is on a different host. The databases have identical schema and security configurations. You have the following requirements:
--
The report must support subscriptions.
Users must be able to select the host when running the report.
What should you do?
To answer, drag the appropriate phrase or phrases from the list to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)

Correct Answer:

You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube.
For Customer A, Projected Revenue is defined as 150 percent of the Total Sales for the customer. For all other customers, Projected Revenue is defined as 110 percent of the Total Sales for the customer.
You need to calculate the Projected Revenue as efficiently as possible.
Which calculation should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Option B
• B.Option A
• C.Option D
• D.Option C