Free Microsoft 70-470 Exam Dumps Questions & Answers

DRAG DROP
You are the administrator of a SQL Server Integration Services (SSIS) catalog. You have access to the original password that was used to create the SSIS catalog.
A full database backup of the SSISDB database on the production server is made each day. The server used for disaster recovery has an operational SSIS catalog.
Information that is encrypted in the SSISDB database must not be lost.
You need to document the disaster recovery solution that restores the production SSIS catalog to the disaster recovery server.
Which three steps should you document in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

DRAG DROP
You are designing a SQL Server Reporting Services (SSRS) solution.
A report project must access multiple SQL Azure databases. Each database is on a different host. The databases have identical schema and security configurations. You have the following requirements:
--
The report must support subscriptions.
Users must be able to select the host when running the report.
What should you do?
To answer, drag the appropriate phrase or phrases from the list to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)

Correct Answer:

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 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.
• B.  Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• C.  Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• D.  Use role playing dimensions.
• E.  Create several dimensions. Add each dimension to the cube.
• F.  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.
• G.  Add a measure that uses the Count aggregate function to an existing measure group.
• H.  Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
• I.  Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• J.  Create a dimension. Then add a cube dimension and link it several times to the measure group.
• K.  Use the Business Intelligence Wizard to define dimension intelligence.
• L.  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.
• M.  Add a measure group that has one measure that uses the DistinctCount aggregate function.
• N.  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.
• O.  Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.

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 one data-driven SSRS subscription. Schedule the subscription to frequently retrieve user preferences.
• C.  Create a standard SSRS subscription for each subscription schedule.
• D.  Create a standard SSRS subscription for each record in the table.

You are modifying a SQL Server Analysis Services (SSAS) cube.
Users of the cube report that the precision for the TransactionCost measure is five digits.
You need to ensure that the TransactionCost measure stores values to two digits of precision.
What should you do?

• A.  Add a named query in the data source view that casts the data source column to two digits of precision. Bind the TransactionCost measure to the new query.
• B.  Add a named calculation in the data source view that casts the data source column to two digits of precision. Bind the TransactionCost measure to the new column.
• C.  Use the FormatString measure property to format TransactionCost as #,##0.00;#,##0.00.
• D.  Use the MeasureExpression measure property to change the precision of TransactionCost to two digits.
• E.  Use the FormatString measure property to format TransactionCost as Currency.