070-470 試験問題を無料オンラインアクセス

You are designing a subscription strategy for a SQL Server Reporting Services (SSRS) report.
You have an application that populates a table with user-specific subscription schedules and report formats.
You need to ensure that users can receive reports by email according to their preferences. Email messages will be sent via an internal mail server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Create a data-driven SSRS subscription for each record in the schedule table.
• B.Create a standard SSRS subscription for each subscription schedule.
• C.Create a standard SSRS subscription for each record in the table.
• D.Create one data-driven SSRS subscription. Schedule the subscription to frequently retrieve user preferences.

HOTSPOT
You create a new report in SQL Server Data Tools (SSDT). The report queries a Windows Azure SQL Database database table.
In a report table showing sales by countries and cities, you need to enable users to hide or show cities by clicking the name of a country.
Which property page of the city text box should you use? (To answer, select the appropriate tab in the answer area.)

正解：

You need to deploy a solution for the planned self-service reports that will be used by the sales department managers.
What is the best solution you should deploy? More than one answer choice may achieve
the goal. Select the BEST answer.

• A.A measure
• B.A filter
• C.A KPI
• D.A calculated column

You need to scale out SSAS.
What should you do?

• A.Process the cube on both ServerB and ServerC each day.
• B.Back up the cube on ServerB and restore it on ServerC each day.
• C.Synchronize the cube from ServerB to ServerC each day.
• D.Create an empty cube on ServerC and link to the objects in the cube on Server

A company runs SQL Server Database Engine and SQL Server Reporting Services (SSRS) in native mode. Reports are based on data that is cached in multiple shared datasets. Source data is archived each day at midnight for regulatory compliance purposes. The shared datasets may continue to cache data that should not be used in reports. Shared report schedules are often paused during nightly server maintenance windows.
Reports must not return archived data.
You need to create a fully automated solution to ensure that reports do not deliver archived data.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Write a script that calls the flushcache method to clear individual items from the SSRS cache. Create a SQL Server Agent job that runs rs.exe with the script as an input file, and schedule the job to run every day after the archive process completes.
• B.Create a shared schedule. Configure the datasets to expire on the shared schedule.
• C.Create a SQL Server Agent job that uses a Transact-SQL (T-SQL) step to truncate the dbo.ExecutionCache table in the ReportServerTempDB database. Schedule the job to run every day after the archive process completes.
• D.Create a SQL Server Agent job that restarts the SQL Server Reporting Services service. Schedule the job to run every day after the archive process completes.