Q1. DRAG DROP - (Topic 4)
You install a SQL Server Analysis Services (SSAS) instance in tabular mode on a server.
While processing a very large tabular model, you receive an out-of-memory error. You identify that the amount of physical memory in the server is insufficient. Additional physical memory cannot be installed in the server.
You need to configure the server to allow paging to disk by using the operating system page file (pagefile.sys).
Which four 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.)
Answer:
Q2. DRAG DROP - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) tabular project based on a Microsoft Azure SQL Database database. The ProcessingOption property for the project is set to Do Not Process.
Several calculated columns have been added to a table. The project has been deployed to the production server.
You need to ensure that newly added data is processed on the production server.
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.)
Answer:
Q3. - (Topic 4)
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 Multidimensional Expressions (MDX) command to drop the dimension from the database.
B. Write a Data Mining Extensions (DMX) command to drop the dimension from the database.
C. Script the deletion of the dimension as an XMLA command for execution against the production model.
D. Write a T-SQL command to drop the dimension from the database.
Answer: C
Q4. - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant the minimum permissions necessary to enable users to query data in a data model.
Which role permission should you use?
A. Explorer
B. Process
C. Browser
D. Administrator
E. Select
F. Read
Answer: F
Q5. - (Topic 4)
You have a tabular model hosted in SQL Server Analysis Services (SSAS).
You need to add new rows to an existing table. The solution must load only the new rows to the table.
Which processing mode should you use?
A. Process Data
B. Process Full
C. Process Add
D. Process Clear
E. Process Default
Answer: E
Q6. - (Topic 4)
You manage a SQL Server Reporting Services (SSRS) instance.
An application must pass credentials to the local security authority for Reporting Services.
You need to configure Reporting Services to issue a challenge/response when a
connection is made without credentials.
Which authentication type should you configure in the RSReportServer.config file?
A. RSWindowsKerberos
B. RSWindowsNegotiate
C. RSWindowsNTLM
D. RSWindowsBasic
Answer: A
Q7. - (Topic 4)
...
You are modifying a SQL Server Analysis Services (SSAS) cube that aggregates order data from a Microsoft Azure SQL Database database. The existing database contains a customer dimension.
The marketing team has requested that customer marketing categories be added to the database.
The marketing categories must meet the following requirements:
A customer member must be able to belong to multiple category members.
A category member must be able to group several customer members.
The marketing team must be able to create new categories every month in the
data source.
You need to implement the appropriate solution to meet the requirements while ensuring that the amount of development and maintenance time is minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create a dimension named Marketing Category Name and then configure a many-to-many relationship.
B. Create a dimension named Marketing Category Name and then configure a regular relationship.
C. Add an attribute hierarchy named Marketing Category Name to the customer dimension.
D. Add an attribute hierarchy for each marketing category to the customer dimension. Configure each hierarchy to have two members named Yes and No.
Answer: D
Q8. - (Topic 3)
You need to configure the SSRS data source.
What should you do?
A. Use Windows credentials.
B. Prompt the user for credentials.
C. In the data source configuration window, select the Credentials are not required option.
D. Store the credentials.
Answer: A
Q9. - (Topic 2)
You need to develop the executive reports.
What should you do? (Each correct answer presents part of the solution. Choose ail that apply.)
A. Provide default values for all parameters.
B. Set the data source to use Windows authentication.
C. Remove default values from all parameters.
D. Implement dataset filters to filter data.
E. Set the data source to use stored Windows credentials.
F. Implement dataset query parameters to filter data.
Answer: A,D,E
20. - (Topic 2)
You need to configure the UserRegions role.
Which Multidimensional Expressions (MDX) function should you use?
A. USERNAME ( )
B. USERID ( )
C. CUSTOMDATA ( )
D. UNIQUENAME ( )
E. LOOKUPVALUE ( )
Q10. - (Topic 4)
You manage an environment that has SharePoint Server 2010 and a SQL Server Reporting Services (SSRS) instance in SharePoint integrated mode. Several report subscriptions are configured to deliver reports through email by using a shared schedule.
The email server will be going offline.
You need to temporarily suspend the shared schedule until the email server is brought back online.
What should you do?
A. In Report Manager, pause the shared schedule.
B. In SharePoint Central Administration, pause the shared schedule.
C. In Report Manager, delete the shared schedule.
D. In SharePoint Central Administration, delete the shared schedule.
Answer: B