Q1. 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. 

View Answer

Q2. 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 

View Answer

Q3. You need to configure package execution logging to meet the requirements. What should you do? 

A. Configure logging in each ETL package to log the OnError, Onlnformation, and Diagnostic events. 

B. Set the SSIS catalog's Server-wide Default Logging Level property to Performance. C set the SSIS catalog's Server-wide Default Logging Level property to Basic. 

C. Set the SSIS catalog's Server-wide Default Logging Level property to Verbose. 

D. Configure logging in each ETL package to log the OnError, OnPreExecute, and OnPostExecute events. 

View Answer

Q4. A SQL Server Analysis Services (SSAS) cube contains a large measure group. The fact table supporting the measure group is loaded with new data throughout the day. 

You have the following requirements: 

Ensure that the cube displays current data as quickly as possible. 

Maximize availability of the cube. 

Maximize query performance for all aggregation levels. 

You need to choose a partitioning strategy that meets the requirements. 

Which partitioning strategy should you choose? (More than one answer choice may achieve the goal. Select the BEST answer.) 

A. Create one partition for the current day that uses multidimensional OLAP (MOLAP) with proactive caching as a storage mode. 

B. Create one partition for the current month that uses hybrid OLAP (HOLAP) as a storage mode. 

C. Create one partition for the current day that uses relational OLAP (ROLAP) as a storage mode. 

D. Create one partition for the current day that uses multidimensional OLAP (MOLAP) as a storage mode. Process the partition each night. 

View Answer

Q5. You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube. 

The cube includes a Product dimension that contains a Category hierarchy and a Color attribute hierarchy. 

You need to return only the blue products in the Category hierarchy. 

Which set should you use? (More than one answer choice may achieve the goal. Select the BEST answer.) 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

View Answer

Q6. You need to implement the product dimension. 

What should you do? 

A. 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. 

B. In the data warehouse, create a dimension table that contains product name and a dimension table that contains product color. 

C. In the data warehouse, create a product dimension table that contains product name and product color. 

D. In the cube, create a named query that joins the Product and ProductColor tables in the financial database. 

View Answer

Q7. You need to choose the appropriate key to use when designing a dimension table based on the Customer table. 

What should you do? 

A. Use a surrogate key. 

B. Use a natural key. 

C. Use the CustomerNumber column as the key. 

D Concatenate the CustomerName and CustomerNumber columns and use the concatenated string as the key. 

D. Use the CustomerName column as the key. 

View Answer

Q8. You are designing a fact table in a SQL Server database. 

The fact table must meet the following requirements: 

Include a columnstore index. 

Allow users to choose up to 10 dimension tables and up to five facts at one time. 

Maximize performance of queries that aggregate measures by using any of the 10 dimensions. 

Support billions of rows. 

Use the most efficient design strategy. 

You need to design the fact table to meet the requirements. 

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.) 

A. Design a fact table with 5 dimensional key columns and 10 measure columns. Place the columnstore index on the dimensional key columns. 

B. Design a fact table with 5 dimensional key columns and 10 measure columns. Place the columnstore index on the measure columns. 

C. Design a fact table with 10 dimensional key columns and 5 measure columns. Place the columnstore index on the dimensional key columns and the measure columns. 

D. Design a fact table with 10 dimensional key columns and 5 measure columns. Place the columnstore index on only the measure columns. 

View Answer

Q9. You need to implement security in the cube to limit the sites visible to each user. 

What should you do? 

A. Create an SSAS database role in the cube for each user and assign the sites each user can access to his or her database role. 

B. Create an SSAS server role for each user and assign the sites each user can access to his or her server role. 

C. Create an SSAS database role and define a Multidimensional Expressions (MDX) calculation to implement dynamic dimension security. 

D. Create a view on the SalesTransactions table that uses the SecurityFilter and User table data to limit the sites for each user. 

View Answer

Q10. You need to develop the tabular project to support the date analysis requirements. 

What should you do? 

A. 

Create one date table named Date. 

. Create an active relationship between the DateKey column of the Date table and the OrderDateKey column of the Sales table. 

. Create an inactive relationship between the DateKey column of the Date table and the ShipDateKey column of the Sales table. 

B. 

.Create two date tables, one named Order Date and one named Ship Date. 

. Create an active relationship between the DateKey column of the Order Date table and the OrderDateKey column of the Sales table. 

. Create an inactive relationship between the DateKey column of the Ship Date table and the ShipDateKey column of the Sales table. 

C. 

. Create one date table named Date. 

. Create an active relationship between the DateKey column of the Date table and the ShipDateKey column of the Sales table. 

. Create an inactive relationship between the DateKey column of the Date table and the OrderDateKey column of the Sales table. 

D. 

. Create two date tables, one named Order Date and one named Ship Date. 

. Create an active relationship between the DateKey column of the Order Date table and the OrderDateKey column of the Sales table. 

. Create an active relationship between the DateKey column of the Ship Date table and the ShipDateKey column of the Sales table. 

View Answer