Online Access Free 70-467 Practice Test

You need to implement the product dimension.
What should you do?

• A.In the data warehouse, create a product dimension table that contains product name and product color.
• B.In the data warehouse, create a product dimension from a view that joins the Product and ProductColor tables in the financial database and contains product name and product color attributes.
• C.In the cube, create a named query that joins the Product and ProductColor tables in the financial database.
• D.In the data warehouse, create a dimension table that contains product name and a dimension table that contains product color.

You have two servers named Data5 and Data6. Both servers have SQL Server installed. Both servers have a SQL Server Integration Services (SSIS) catalog. You are preparing a disaster recovery plan for a business intelligence (Bl) solution. You need to ensure that the SSIS catalog from Data5 can be restored to Data6. What should you do on Data5?

• A.Run sp_configure clr enabled', 1.
• B.Run sp configure recovery interval', 0.
• C.Back up the SSISDB database and its master key.
• D.Back up the master database and its database.

You administer a SQL Server Analysis Services (SSAS) instance.
You need to capture a continuous log of detailed event and subevent durations and custom trace events from queries executed in the SSAS instance.
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: Write an XMLA script to log the extended events of the trace.
Box 2: Launch SQL Server Management Studio and connect to the instance.
Box 3: Execute the script.
Note:
* Auditing an instance of SQL Server or a SQL Server database involves tracking and logging events that occur on the system. The SQL Server Audit object collects a single instance of server- or database-level actions and groups of actions to monitor. The audit is at the SQL Server instance level. You can have multiple audits per SQL Server instance. The Server Audit Specification object belongs to an audit. You can create one server audit specification per audit, because both are created at the SQL Server instance scope.
* Trace events can be started and captured using SQL Server Profiler, , or can be started from an XMLA command as SQL Server Extended Events and later analyzed.
* Extended Event tracing is enabled using a similar XMLA create object script.
Reference: Analysis Services Trace Events

You are designing a partitioning strategy for a SQL Server Analysis Services (SSAS) cube.
New data is loaded in real-time into the data warehouse that feeds the cube. Between 10 million and 15 million rows of data are loaded into the main fact table each day from a Microsoft Azure SQL Database.
You have the following requirements:
* Maximize cube query performance during business hours.
* Ensure that data is available in the cube as soon as possible after it is loaded into the data warehouse.
You need to design a partitioning strategy that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Partition the cube by day for history, using multidimensional OLAP (MOLAP) storage mode. Create a daily partition that uses relational OLAP (ROLAP) storage mode during the day. Reprocess the partition in full MOLAP storage mode at night.
• B.Partition the cube by week for history. Create a daily partition that uses multidimensional OLAP (MOLAP) storage mode. Process the partition periodically to add new data.
• C.Partition the cube by day for history, using hybrid OLAP (HOLAP) storage mode. Create a daily partition that uses multidimensional OLAP (MOLAP) storage mode during the day. Reprocess the partition incrementally during the day.
• D.Partition the cube by day for history, using multidimensional OLAP (MOLAP) storage mode. Create a daily partition that uses proactive caching during the day. Reprocess the partition in full MOLAP storage mode at night

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.Install SSRS 2012 on a new SharePoint farm and migrate content to the new farm.
• B.Migrate SSRS content to new servers that run SSRS 2012.
• C.Perform an in-place upgrade of the SSRS environment.
• D.Migrate SSRS content to a separate instance of SSRS 2012 on the same server.