Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. DRAG DROP - (Topic 8)
You need to recommend a solution to implement the data security requirements for CUBE1.
Which three actions should you recommend performing 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. - (Topic 9)
A company runs SQL Server Database Engine and SQL Server Reporting Services (SSRS) in native mode. Reports are based on data that is cached in multiple shared datasets. Source data is purged each day at midnight for regulatory compliance purposes. The shared datasets may continue to cache data that should not be used in reports. Shared report schedules are often paused during nightly server maintenance windows.
Reports must not return purged data.
You need to create a fully automated solution to ensure that reports do not deliver purged data.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create a shared schedule. Configure the datasets to expire on the shared schedule.
B. Write a script that calls the flushcache method to clear individual items from the SSRS cache. Create a SQL Server Agent job that runs rs.exe with the script as an input file, and schedule the job to run every day after the purge process completes.
C. Create a SQL Server Agent job that uses a Transact-SQL (T-SQL) step to delete the data from the dbo.ExecutionCache table in the ReportServerTempDB database. Schedule the job to run every day after the purge process completes.
D. Republish the cached datasets by using SQL Server Data Tools.
Answer: B
Q3. DRAG DROP - (Topic 10)
You manage a SQL Server Reporting Services (SSRS) instance running in native mode.
You are troubleshooting a performance problem and need to know which reports are frequently executed. You discover that the report server execution logs are empty, despite significant report activity.
You need to ensure that the server is configured for report execution logging.
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:
Q4. DRAG DROP - (Topic 9)
A SQL Server Analysis Services (SSAS) cube named Sales includes a dimension named Date that defines a hierarchy named Calendar. The Calendar hierarchy consists of Year, Quarter, and Month levels. The Type properties of the Date dimension and its attributes are appropriately configured to mark the dimension as a time dimension.
You are creating a Multidimensional Expressions (MDX) query that will return sales for each month of 2011 and a three-month moving average of sales (labeled 3MMA), as shown in the following diagram.
You need to complete the MDX query.
Which set expression should you use? To answer, drag the appropriate expression to the answer area.
Answer:
Q5. DRAG DROP - (Topic 10)
You are planning the installation of PowerPivot for SharePoint.
You install SharePoint Server 2010 Enterprise Edition with Service Pack 1.
You need to install the PowerPivot for SharePoint instance. Then you need to configure the
Default Account username used to provision shared services in the SharePoint farm. 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:
Q6. - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) multidimensional database.
The underlying data source does not have a time dimension table. You need to implement a time dimension.
What should you do?
A. Add an existing SSAS database time dimension as a cube dimension.
B. Use the SQL Server Data Tools Dimension Wizard and generate a time table on the server.
C. Use the SQL Server Data Tools Dimension Wizard and generate a time table in the data source.
D. Use the SQL Server Data Tools Dimension Wizard and generate a time dimension by using the Use an existing table option.
E. Create a CSV file with time data and use the DMX IMPORT statement to import data from the CSV file.
F. Create a time dimension by using the Define time intelligence option in the Business Intelligence Wizard.
G. Create a time dimension by using the Define dimension intelligence option in the Business Intelligence Wizard.
H. Create a script by using a sample time dimension from a different multidimensional database. Then create a new dimension in an existing multidimensional database by executing the script.
Answer: B
Q7. - (Topic 7)
You need to update the Execute SQL task in the OnVariableValueChanged event handler of all SSIS packages.
Which additional variable should be logged?
A. System::ExecutionInstanceGUID
B. System::ServerExecutionID
C. System::VariableID
D. System::SourceID
Answer: C
Q8. - (Topic 7)
You need to ensure that the corporate logos appear in reports.
What should you do?
A. In SharePoint Central Administration, configure the unattended execution account.
B. In SharePoint Central Administration, configure the Report Server service account.
C. In Reporting Services Configuration Manager, configure the unattended execution account.
D. In Reporting Services Configuration Manager, configure the Report Server service account.
Answer: A
Q9. - (Topic 10)
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. Write a T-SQL command to drop the dimension from the database.
D. Delete the dimension by using SQL Server Management Studio Object Explorer.
Answer: D
Q10. DRAG DROP - (Topic 1)
You need to complete the design of the data warehouse.
Which design should you use? (To answer, drag the appropriate tables and relationships to the correct location in the answer area. Use only the tables and relationships that apply.)
Answer:
Q11. - (Topic 1)
You need to configure the SSRS data source.
What should you do?
A. Store the credentials.
B. In the data source configuration window, select the Prompt for credentials option.
C. Create a .NET form to enable users to enter their credentials.
D. Configure Kerberos authentication.
Answer: A
Q12. - (Topic 5)
You need to design a cube partitioning strategy to be implemented as the cube size increases.
What should you do?
A. Use relational OLAP (ROLAP) on all local partitions.
B. Implement monthly remote partitions.
C. Use multidimensional OLAP (MOLAP) on all local partitions.
D. Implement monthly local partitions.
Answer: B
Q13. DRAG DROP - (Topic 9)
You have a business intelligence (BI) infrastructure that contains three servers. The servers are configured as shown in the following table.
You need to recommend a health monitoring solution for the BI infrastructure.
The solution must meet the following requirements:
Monitor the status of the Usage Data Collection feature.
Monitor the number of end-users accessing the solution.
Monitor the amount of cache used when the users query data.
Which health monitoring solution should you recommend using on each server? To answer, drag the appropriate monitoring solutions to the correct servers. Each monitoring solution may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
...
Answer:
Q14. DRAG DROP - (Topic 10)
You manage a SQL Server Reporting Services (SSRS) instance in native mode. You are building a shared dataset for your weekly performance reports. The shared dataset uses a data source that is configured to use credentials that are stored in the Report Server.
You have a predefined shared schedule to perform cleanup and maintenance tasks for SSRS.
You need to enable caching on the shared dataset. You also need to use an existing shared schedule to discard the cache.
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:
Q15. DRAG DROP - (Topic 7)
You need to develop the LoadFactSales package to write the error messages to the SSIS catalog log.
Which components should you use?
To answer, drag the appropriate components to the correct location or locations in the answer area. (Use only components that apply.)
Answer:
Q16. HOTSPOT - (Topic 9)
You are setting role permissions for a SQL Server Analysis Service (SSAS) cube.
You plan to grant Read access for specific attribute members only to specific Active Directory security groups.
You need to enter a Multidimensional Expressions (MDX) expression to configure the attribute member access.
On which tab should you enter the MDX expression? To answer, select the appropriate tab in the answer area.
Answer: