Microsoft 070-466 Actual Free Exam Questions & Community Discussion
DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to source data from a SQL Azure database.
You plan to use multiple servers to process different partitions simultaneously. You create and configure a new data source.
You need to create a new partition and configure SQL Server Analysis Services (SSAS) to use a remote server to process data contained within the partition.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to source data from a SQL Azure database.
You plan to use multiple servers to process different partitions simultaneously. You create and configure a new data source.
You need to create a new partition and configure SQL Server Analysis Services (SSAS) to use a remote server to process data contained within the partition.
Which three actions should you perform 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:
Explanation:
Box 1:
Box 2:
Box 3:
Note:
* You create a remote partition using the Partition Wizard. On the Specify Processing and Storage Options page, for the Remote Analysis Services data source, specify the dedicated database on the remote instance of Analysis Services. This instance of Analysis Services is called the remote server of the remote partition. For Storage location, you can specify the default data location for the remote server or a specified folder on the server.
You must create an Analysis Services database on the remote server and provide appropriate security settings. An additional OLAP data source is created on the remote database pointing to the server on which the partition is defined. The MasterDatasourceID property setting on the remote database points to the data source which, in turn, points to the master server. This property is only set on a database that contains remote partitions.
The RemoteDatasourceID property setting on the remote partition specifies the ID of the OLAP data source on the master server that points to the remote server. A remote database can only host remote partitions for a single server.
* Before you create a remote partition, the following conditions must be met:
* uk.co.certification.simulator.questionpool.PList@12ef9670
* uk.co.certification.simulator.questionpool.PList@12ef96e0
* uk.co.certification.simulator.questionpool.PList@12ef9720
The domain user account for the local instance of Analysis Services must have administrative access to the remote database.
You are creating a SQL Server Analysis Services (SSAS) multidimensional database.
Users need a time dimension for:
* Dates
* Delivery dates
* Ship dates
You need to implement the minimum number of required SSAS objects.
What should you do?
Users need a time dimension for:
* Dates
* Delivery dates
* Ship dates
You need to implement the minimum number of required SSAS objects.
What should you do?
Correct Answer: C
Vote an answer
You maintain SQL Server Analysis Services (SSAS) instances.
You need to configure an installation of PowerPivot for Microsoft SharePoint in a SharePoint farm.
Which tool should you use? (Each correct answer presents a complete solution. Choose all that apply.)
You need to configure an installation of PowerPivot for Microsoft SharePoint in a SharePoint farm.
Which tool should you use? (Each correct answer presents a complete solution. Choose all that apply.)
Correct Answer: A,D,E
Vote an answer
You need to create the sales territory and product measures.
Which aggregate function should you use for both measures?
Which aggregate function should you use for both measures?
Correct Answer: B
Vote an answer
You are developing a SQL Server Analysis Services (SSAS) tabular project. The model includes a table named Sales. The Sales table includes a single date column.
The Sales table must meet the following requirements:
* Queries must be able to return all rows.
* Must be able to support four different processing schedules for different date ranges.
* Date ranges must not include any overlapping data.
You need to implement a solution that meets the requirements.
What should you do?
The Sales table must meet the following requirements:
* Queries must be able to return all rows.
* Must be able to support four different processing schedules for different date ranges.
* Date ranges must not include any overlapping data.
You need to implement a solution that meets the requirements.
What should you do?
Correct Answer: C
Vote an answer
DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) multidimensional project.
You identify that a dimension, which has a large number of attributes, is issuing a separate (SELECT DISTINCT) query for each attribute even though they all come from a single database table. The table does not have a large number of rows.
You need to configure the processing of the dimension to issue only a single SQL query to the underlying database, and processing must continue if any errors are encountered.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
You are developing a SQL Server Analysis Services (SSAS) multidimensional project.
You identify that a dimension, which has a large number of attributes, is issuing a separate (SELECT DISTINCT) query for each attribute even though they all come from a single database table. The table does not have a large number of rows.
You need to configure the processing of the dimension to issue only a single SQL query to the underlying database, and processing must continue if any errors are encountered.
Which three actions should you perform 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:
You need to recommend a solution for the sales department that meets the security requirements.
What should you recommend?
What should you recommend?
Correct Answer: D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
DRAG DROP
You are making changes to a cube named Sales.
You must increase the value of the measure named Sales Amount by 10%. The increase must be applied only to the children of the member named East in the dimension named Customer.
You need to complete the Multidimensional Expressions (MDX) statement in the calculations section of the Sales cube.
Which statement fragments should you use? (To answer, drag the appropriate statement component to the correct location or locations in the answer area. Use only components that apply.)
You are making changes to a cube named Sales.
You must increase the value of the measure named Sales Amount by 10%. The increase must be applied only to the children of the member named East in the dimension named Customer.
You need to complete the Multidimensional Expressions (MDX) statement in the calculations section of the Sales cube.
Which statement fragments should you use? (To answer, drag the appropriate statement component to the correct location or locations in the answer area. Use only components that apply.)
Correct Answer:
Explanation:
Note:
SCOPE THIS END SCOPE
* SCOPE Statement (MDX)
Limits the scope of specified Multidimensional Expressions (MDX) statements to a specified subcube.
* Example:
cope
(
[Date].[Fiscal Year].&[2002],
[Date].[Fiscal].[Month].Members
) ;
This = [Date].[Fiscal].CurrentMember.Parent / 3 ;
End Scope;
You are conducting a design review of a multidimensional project.
In the Customer Geography dimension, all non-key attributes relate directly to the key attribute.
The underlying data of the Customer Geography dimension supports relationships between attributes.
You need to increase query and dimension processing performance.
What should you do?
In the Customer Geography dimension, all non-key attributes relate directly to the key attribute.
The underlying data of the Customer Geography dimension supports relationships between attributes.
You need to increase query and dimension processing performance.
What should you do?
Correct Answer: C
Vote an answer
You have a database for a mission-critical web application. The database is stored on a SQL Server 2012 instance and is the only database on the instance. The application generates all T-SQL statements dynamically and does not use stored procedures.
You need to maximize the amount of memory available for data caching.
Which advanced server option should you modify?
You need to maximize the amount of memory available for data caching.
Which advanced server option should you modify?
Correct Answer: B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be used in the definition of a hierarchy. The City column exists in the Geography table that is related to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?
A column named City must be added to the table named Customer. The column will be used in the definition of a hierarchy. The City column exists in the Geography table that is related to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?
Correct Answer: A
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
0
0
0
10