Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. You are designing a strategy for an enterprise reporting solution that uses SQL Server Reporting Services (SSRS).
Many of the SSRS reports will use common utilities and functions, including the following:
. Report utility functions and business logic in code . Standardized report formatting properties such as fonts and colors for report branding
Formatting may change and new functions may be added as the reporting solution evolves.
You need to create a strategy for deploying the formatting and code across the entire enterprise reporting solution. You must also ensure that reports can be easily updated to reflect formatting and function changes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create a report as a template. Apply standardized formatting to the template. Store code in the Code section of the template.
B. Build a web service that retrieves formatting properties and runs code. Call the web service through a report dataset.
C. Store the formatting properties and code in database objects. Use stored procedures to populate a default value for report parameters and map each parameter to a corresponding formatting property.
D. Create an assembly that contains formatting properties and code. Deploy the assembly on the Reporting Server and reference the assembly from each report.
Answer: D
Q2. 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.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create a standard subscription for each record in the table.
B. Create a data-driven subscription for each record in the schedule table.
C. Create one data-driven subscription. Schedule the subscription to frequently retrieve user preferences.
D. Create a standard subscription for each subscription schedule.
Answer: C
Q3. You need to ensure that managers can successfully run reports.
What should you do?
A. Implement Kerberos delegation.
B. Configure the SSRS data sources to store Windows credentials.
C. Implement forms-based authentication.
D. Configure the CustomData property in the connection strings.
Answer: A
Q4. You need to select the appropriate mode for the Sales database.
Which mode should you select?
A. ROLAP
B. Direct Query
C. MOLAP
D. In-Memory
Answer: B
Q5. 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
Q6. You need to create the Sales Reporting shared SSR5 data source.
Which SSRS data connection type should you use?
A. OData
B. Microsoft SQL Server
C. ODBC
D. OLE DB
Answer: C
Q7. You have a SQL Server Reporting Services (SSRS) 2008 instance integrated with an Internet-facing Microsoft SharePoint 2010 farm. PerformancePoint Services and Excel Services are installed and configured.
You need to upgrade to SSRS 2012 with the minimum downtime and hardware requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Migrate SSRS content to a separate instance of SSRS 2012 on the same server.
B. Perform an in-place upgrade of the SSRS environment.
C. Migrate SSRS content to new servers that run SSRS 2012.
D. Install SSRS 2012 on a new SharePoint farm and migrate content to the new farm.
Answer: C
Q8. You need to configure a parameter for the database connection string.
What should you do?
A. Use a required package parameter.
B. Use a required project parameter.
C. Use a package configuration.
D. Use a global variable.
Answer: B
Q9. 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 archived 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 archived data.
You need to create a fully automated solution to ensure that reports do not deliver archived data.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. 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 archive process completes.
B. Create a SQL Server Agent job that uses a Transact-SQL (T-SQL) step to truncate the dbo.ExecutionCache table in the ReportServerTempDB database. Schedule the job to run every day after the archive process completes.
C. Create a SQL Server Agent job that restarts the SQL Server Reporting Services service. Schedule the job to run every day after the archive process completes.
D. Create a shared schedule. Configure the datasets to expire on the shared schedule.
Answer: A
Q10. You need to ensure that you can monitor the usage data. What should you do?
A. In SharePoint Central Administration, enable usage data collection.
B. In the PowerPivot Configuration Tool, repair PowerPivot for SharePoint.
C. In the PowerPivot Configuration Tool, upgrade PowerPivot for SharePoint.
D. In Reporting Services Configuration Manager, enable report execution logging.
Answer: A
Q11. You are designing a partitioning strategy for a large fact table in a Manufacturing data warehouse.
Tens of millions of new inventory fact records are loaded into the data warehouse weekly, outside of business hours. Most queries against the database are generated by reports and by cube processing. Data is frequently queried at the day level and occasionally at the month level.
A. Partition the inventory fact table by month, and compress each partition.
B. Partition the inventory fact table by day, and compress each partition.
C. Partition the inventory fact table by year.
D. Partition the inventory fact table by week.
Answer: B
Q12. You need to design the dimCustomers table.
Which design approach should you use?
A. Reference dimension
B. Type 2 slowly changing dimension
C. Junk dimension
D. Conformed dimension
E. Type 1 slowly changing dimension
Answer: B
Q13. You are designing a complex report that displays sales metrics for a customer hierarchy. The customer hierarchy has six levels and contains approximately 1 million members.
You have the following requirements:
Allow users to easily display and navigate data.
Minimize report processing time.
Simplify the report design and maintenance processes.
You need to design a report that meets the requirements.
How should you design the report? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Retrieve all customers and use drilldown groupings to show or hide hierarchy levels.
B. Add a report part for each hierarchy level.
C. Add a subreport for each hierarchy level.
D. Display only the children of the current hierarchy level and drill through to the selected member.
Answer: D
Q14. You need to perform the pre-upgrade database backup operation by using SQL Server Management Studio (SSMS).
How should you configure the backup options?
A. Select the Apply compression check box. Select the Encrypt backup file check box and supply a password.
B. Clear the Apply compression check box. Select the Encrypt backup file check box and supply a password.
C. Clear the Apply compression check box. Clear the Encrypt backup file check box.
D. Select the Apply compression check box. Clear the Encrypt backup file check box.
Answer: D
Q15. An existing cube dimension that has 30 attribute hierarchies is performing very poorly. You have the following requirements:
. Implement drill-down browsing.
. Reduce the number of attribute hierarchies but ensure that the information contained within them is available to users on demand.
. Optimize performance.
You need to redesign the cube dimension to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. set the AggregateFunction property to Sum on all measures. Use the SCOPE statement in a Multidimensional Expressions (MDX) calculation to tune the aggregation types.
B. Set the AttributeHierarchyOptimizedState property to FullyOptimized on the attribute hierarchies.
C. Create user-defined hierarchies. For the attributes sourced by the levels of the user-defined hierarchies, set the RelationshipType property to Rigid. Run incremental processing.
D. Remove as many attribute hierarchies as possible from the dimension. Reintroduce the information in the attribute hierarchies as properties. Implement natural hierarchies and set the AttributeHierarchyVisible property to False for attributes used as levels in the natural hierarchies.
Answer: D