070-470 무료 덤프문제 온라인 액세스

HOTSPOT
You administer a SQL Server Analysis Services (SSAS) cube.
You plan to optimize the cube partitions by using usage-based optimization.
You need to configure the SSAS instance.
Which properties should you configure? To answer, select the appropriate properties in the
dialog box in the answer area.

정답:

You manage an environment that has SharePoint Server 2010 and a SQL Server Reporting Services (SSRS) instance in SharePoint integrated mode. Several report subscriptions are configured to deliver reports through a shared folder by using a shared schedule. The shared folder will be going offline.
You need to temporarily suspend the shared schedule until the shared folder is brought back online.
What should you do?

• A.Open Report Manager and then pause the shared schedule.
• B.In SharePoint Central Administration, pause the shared schedule.
• C.In SharePoint Central Administration, delete the shared schedule.
• D.Open Report Manager and then delete the shared schedule.

You need to configure security for the SSRS instance on SSRS01 to connect to SSAS and minimize downtime.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A.Register a service principal name for the Analysis Services service.
• B.Restart the IIS service.
• C.Configure SSRS01 to use the Negotiate authentication type.
• D.Configure SSRS01 to use the Custom authentication type.
• E.Register a service principal name for the Report Server service.

You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSAS) cube.
The cube contains a Key Performance Indicator (KPI) to show if a salesperson's sales are off target, slightly off target, or on target.
You need to add a report item that visually displays the KPI status value as a red, yellow, or green circle.
Which report item should you add?

• A.Radial Gauge
• B.Indicator
• C.Linear Gauge
• D.Sparkline
• E.Data Bar

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.
-- --

정답: