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

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.Write a T-SQL command to drop the dimension from the database.
• B.Use the SQL Server Analysis Services Migration Wizard.
• C.Script the deletion of the dimension as an XMLA command for execution against the production model.
• D.Deploy the project from the development environment by using SQL Server Management Studio.

You need to recommend a partitioning strategy that meets the performance requirements for CUBE1.
What should you include in the recommendation?

• A.Createone dimension for all distinct count attributes.
• B.Createone measure group for all distinct count measures.
• C.Createa separate dimension for each distinct count attribute.
• D.Create separate measure groups for each distinct count measure.

You deploy a PowerPivot workbook to a document library in a Microsoft SharePoint site. Workbook data comes from two different sources: Source A and Source B.
The workbook contains three small lookup tables from Source A, and five tables with a total of 20 million rows from Source B.
Data from Source A is updated at 9:00 A.M. and data from Source B is updated throughout the day.
You have the following requirements:
- Refresh the PowerPivot workbook with updated lookup data as soon as possible.
- Minimize load on the source systems and the SharePoint environment during business hours.
- Minimize user involvement in the data refresh process.
You enable automatic data refresh for the workbook.
You need to configure a data refresh schedule for the workbook that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Set the default schedule to refresh at 3:00 P.M. every day. Do not create individual source schedules.
• B.Set the default schedule to refresh at 9:00 A.M. every day. Create a separate schedule for Source B's connection to refresh outside of business hours.
• C.Set the default schedule to refresh outside of business hours. Manually refresh the workbook at 9:00 A.M. every day.
• D.Set the default schedule to refresh outside of business hours. Do not manually refresh the workbook.
• E.Set the default schedule to refresh at 9:00 A.M. every day. Do not create individual source schedules.

You need to configure the SSRS data source.
What should you do?

• A.Configure Kerberos authentication.
• B.In the data source configuration window, select the Prompt for credentials option.
• C.Store the credentials.
• D.Create a .NET form to enable users to enter their credentials.

You are designing a SQL Server Reporting Services (SSRS) report.
The report defines a single SQL Server data source and dataset.
You need to include additional data sourced from a SQL Azure database in the report.
What should you do?

• A.Create a SQL Azure data source and then add a dataset that uses the new data source.
• B.Create a SQL Server data source and then add a dataset that uses the new data source.
• C.Create a SQL Azure dataset that uses the existing data source.
• D.Generate an Atom-compliant data feed for the report.