Online Access Free 70-460 Practice Test

HOTSPOT
A SQL Server Analysis Services (SSAS) cube contains billions of rows of data and is rapidly increasing in size. The cube consists of a single measure group and a single partition. The cube is currently processed by using the Process Full process option.
You have the following requirements to reduce the cube processing time:
Partition the measure group by month.
Create a staging table that contains only data which is more recent than the last
time the cube was processed.
Do not include data updates or deletions in the staging table.
Insert records from the staging table into the appropriate partition.
You need to change the process option to meet the requirements.
Which process option should you choose?
-- --
To answer, select the appropriate option from the drop-down list in the dialog box.

Correct Answer:

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be
used in the definition of a hierarchy. The City column exists in the Geography table that is
related to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?

• A.Option E
• B.Option C
• C.Option D
• D.Option F
• E.Option A
• F.Option B

You have two servers named Server1 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 master key of the SSISDB database.
• B.Run sp.configure 'clr enabled', 0.
• C.Back up the master key of the master database.
• D.Back up the master database.
• E.Back up the SSISDB database.
• F.Run sp_configure 'clr enabled', 1.

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.Select the Apply compression check box. Select the Encrypt backup file check box and supply a password.
• B.Clear the Apply compression check box. Clear the Encrypt backup file check box.
• C.Select the Apply compression check box. Clear the Encrypt backup file check box.
• D.Clear the Apply compression check box. Select the Encrypt backup file check box and supply a password.

You need to implement the aggregation designs for the cube.
What should you do?

• A.Use the Aggregation Design Wizard.
• B.Partition the cube by month.
• C.Use the Usage-Based Optimization Wizard.
• D.Implement cache warming in SSAS via an SSIS package.