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

You need to design the recovery strategy for SSRS01.
What should the strategy include? (Each correct answer presents part of the solution. Choose all that apply.)

• A.Restore the ReportServer and ReportServerTempDB databases with recovery.
• B.Re-create the SQL Server Agent jobs that are used to trigger schedules.
• C.Restore the database encryption key.
• D.Restore the Report Server encryption key.
• E.Restore the ReportServer and ReportServerTempDB databases with no recovery.
• F.Restore the msdb database.

You are developing a multidimensional project that includes a dimension named Organization. The dimension is based on the DimOrganization table in the data warehouse. The following diagram illustrates the table design.

The Organization dimension includes a parent-child hierarchy named Organizations.
The dimension includes the following dimension attributes:
Organization, which is a key attribute
Organizations, which defines the parent-child hierarchy
Currency Code, which is a regular attribute
When users browse the dimension, three hierarchies are visible to them.
---
You need to ensure that the Organization hierarchy is not visible to users.
What should you do?

• A.Set the AttributeHierarchyEnabled property to False for the Organization attribute.
• B.Set the AttributeHierarchyVisible property to False for the Organization attribute.
• C.Delete the Organization attribute.
• D.Set the AttributeHierarchyDisplayFolder property to Null for the Organization attribute.

You manage a SQL Server Reporting Services (SSRS) instance. The
ReportingServicesService.exe.config file has been modified to enable logging.
Some users report that they cannot access the server.
You need to ascertain the IP addresses of the client computers that are accessing the server.
What should you do?

• A.View the Windows System event log.
• B.View the Report Server HTTP log.
• C.View the ExecutionLog view in the Report Server database.
• D.View the Report Server service trace log.

You are creating a SQL Server Analysis Services (SSAS) cube.
You need to create a time dimension. It must be linked to a measure group named Sales at the day granularity level. It must also be linked to a measure group named Salary at the month granularity level.
What should you do?

• A.Create a dimension. Then add a cube dimension and link it several times to the measure group.
• B.Use the Business Intelligence Wizard to define dimension intelligence.
• C.Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.
• D.Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.
• E.Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.
• F.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.
• G.Add a measure that uses the Count aggregate function to an existing measure group.
• H.Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• I.Use role playing dimensions.
• J.Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• K.Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• L.Add a measure group that has one measure that uses the DistinctCount aggregate function.
• M.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
• N.Create several dimensions. Add each dimension to the cube.
• O.Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.

HOTSPOT
You are designing aggregations for a SQL Server Analysis Services (SSAS) cube. You need to ensure that every aggregation excludes the Category attribute. Which option should you select?
To answer, select the appropriate option in the answer area.

正解：