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

A SQL Server Analysis Services (SSAS) cube contains a large measure group. The fact table supporting the measure group is loaded with new data throughout the day.
You have the following requirements:
* Ensure that the cube displays current data as quickly as possible.
* Maximize availability of the cube.
* Maximize query performance for all aggregation levels.
You need to choose a partitioning strategy that meets the requirements.
Which partitioning strategy should you choose? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Create one partition for the current day that uses multidimensional OLAP (MOLAP) with proactive caching as a storage mode.
• B.Create one partition for the current day that uses multidimensional OLAP (MOLAP) as a storage mode.
  Process the partition each night.
• C.Create one partition for the current month that uses hybrid OLAP (HOLAP) as a storage mode.
• D.Create one partition for the current day that uses relational OLAP (ROLAP) as a storage mode.

You are developing a SQL Server Analysis Services (SSAS) tabular project. The DirectQuery Mode property of the data model has been set to On. The current partition for the table is configured as the DirectQuery partition.
Data is loaded into a data mart throughout the day and must be available in the data model as soon as possible.
The model must support querying by clients that issue both Data Analysis Expressions (DAX) queries and Multidimensional Expressions (MDX) queries. Clients issuing DAX queries must receive real-time query results.
You need to select the appropriate Query Mode property for deployment.
Which query mode should you select?
To answer, select the appropriate query mode from the drop-down list in the dialog box.

정답:

Explanation

You are designing a SQL Server Reporting Services (SSRS) solution.
A report project must access multiple SQL Server databases. Each database is on a different instance. 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.)

정답:

Explanation

Note:
The report need a data source.
Through a report parameter the user can select among the available SQL Server instances.
This selection is used through an expression-based connection string.
Authentication is handled through stored credentials.

You are designing a dataset for a SQL Server Reporting Services (SSRS) report.
The report includes the report items displayed in the following graphic.

The dataset is sourced from a commonly used stored procedure in an inventory data mart hosted in a SQL Azure database.
It returns the status for all products across all storage sites. The report must display data for the storage site that is selected by the Site report parameter. You cannot change the stored procedure code.
You need to filter the dataset to use only data specific to the selected site.
How should you configure the filter?
To answer, drag the appropriate expression or expressions to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)

정답:

Explanation

Note:
To set a filter on the dataset
* Open a report in Design view.
* Right-click a dataset in the Report Data pane and then clickDataset Properties. TheDataset Properties dialog box opens.
* ClickFilters. This displays the current list of filter equations. By default, the list is empty.
* ClickAdd. A new blank filter equation appears.
* InExpression, type or select the expression for the field to filter. To edit the expression, click the expression (fx) button.
Box 1: Here we use the Fields expression.
* From the drop-down box, select the data type that matches the type of data in the expression you created
* in step 5.
* In theOperatorbox, select the operator that you want the filter to use to compare the values in the Expressionbox and theValuebox. The operator you choose determines the number of values that are used from the next step.
Box 2: we test for equality.
* In theValuebox, type the expression or value against which you want the filter to evaluate the value in Expression.
Box 3: we compare to the value of the Parameter named Site.
* Click OK.
Reference: How to: Add a Filter (Reporting Services)

You are designing a SQL Server 2012 Integration Services (SSIS) deployment strategy. You currently have many SQL Server 2008 SSIS packages that require upgrading.
The production environment includes SSIS 2012 and SSIS 2008. The environment includes existing command shell scripts that invoke the dtutil command-line utility.
You need to design a deployment strategy that supports existing deployment strategies and requires the minimum amount of effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Use a project deployment model. Change the command shell scripts to reference the SQL Server 2012 path to dtutil.
• B.Use a package deployment model. Use the Integration Services Deployment Wizard.
• C.Use a project deployment model. Use the Integration Services Deployment Wizard.
• D.Use a package deployment model. Change the command shell scripts to reference the SQL Server 2012 path to dtutil.