Online Access Free 070-470 Exam Questions

DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to add a calculated column to a table in the model.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)

Correct Answer:

You need to create a measure for DOD sales.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A.Use the Business Intelligence Wizard to define time intelligence.
• B.Use the Multidimensional Expressions (MDX) LAG() function.
• C.Specify a date table by using a Mark as Date table.
• D.Use the Data Analysis Expressions (DAX) PARALLELPERIOD() function.

You have two servers named Served and Server2. Both servers have SQL Server 2012 installed. Both servers have a SQL Server Integration Services (SSIS) catalog.
You are preparing a disaster recovery plan for a business intelligence (BI) solution.
You need to ensure that the SSIS catalog from Server1 can be restored to Server2.
Which two actions should you perform on Server1? Each correct answer presents part of the solution.

• A.Back up the SSISDB database.
• B.Back up the master key of the SSISDB database.
• C.Run sp.configure 'clr enabled', 0.
• D.Back up the master database.
• E.Back up the master key of the master database.
• F.Run sp_configure 'clr enabled', 1.

DRAG DROP
You are the database administrator of a SQL Server 2012 data warehouse implemented as a single database on a production server. The database is constantly updated by using SQL Server Integration Services (SSIS) packages and SQL Server Analysis Services (SSAS) cube writeback operations.
---
The database uses the full recovery model. A backup strategy has been implemented to minimize data loss in the event of hardware failure.
SQL Server Agent jobs have been configured to implement the following backup operations:
A full database backup every day at 12:00 A.M.
Differential database backups every day at 6:00 A.M., 12:00 P.M., and 6:00 P.M.
Transaction log backups every hour on the hour.
At 2:38 P.M. a SSIS package corrupts the data in a fact table. The corruption cannot be undone. You are notified at 3:15 P.M. You immediately take the database offline to prevent further data access and modification.
You need to restore the data warehouse and minimize downtime and data loss.
Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

You are modifying a SQL Server Analysis Services (SSAS) multidimensional database.
You have identified a dimension that is no longer used by any cubes.
You need to delete the dimension.
What should you do?

• A.Delete the dimension by using SQL Server Management Studio Object Explorer.
• B.Write a Multidimensional Expressions (MDX) command to drop the dimension from the database.
• C.Write a T-SQL command to drop the dimension from the database.
• D.Write a Data Mining Extensions (DMX) command to drop the dimension from the database.