Microsoft Recertification for MCSE Business Intelligence Set 1

Question - 15 Maximum mark : - 27

Home
All Exams
Microsoft Recertification for MCSE Business Intelligence Online Mock Tests
Microsoft Recertification for MCSE Business Intelligence Set 1

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

Create a standard subscription for each record in the table. ✘ Create a data-driven subscription for each record in the schedule table. ✘ Create one data-driven subscription. Schedule the subscription to frequently retrieve user preferences. ✘ Create a standard subscription for each subscription schedule. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are modifying a SQL Server Reporting Services (SSRS) report for a SQL Server Analysis Services (SSAS) cube. The report defines a report parameter of data type Date/Time with which users can filter the report by a single date. The parameter value cannot be directly used to filter the Multidimensional Expressions (MDX) query for the dataset. You need to ensure that the report displays data filtered by the user-entered value. You must achieve this goal by using the least amount of development effort. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

Edit the dataset query parameter. Change the Value property of the report parameter to an expression that uses the same format as the date dimension member key value. ✘ Edit the dataset query parameter. Change the Name property of the dataset query parameter so that it points to a name value for each date dimension member. ✘ Edit the dataset query parameter. Create a subcube subquery that uses the StrToSet MDX function and accepts the report parameter value. ✘ Change the dataset query to Transact-SQL (T-SQL). Use the OPENROWSET function to query the cube. Output the cube results to the T-SQL query and use aConvert function to change the report parameter value into the same format as the date dimension member. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You administer a SQL Server Reporting Services (SSRS) instance in native mode. You need to assign a predefined role that meets the following requirements:

the Content Manager role ✘ the Read and Process role ✘ the Publisher role ✘ the Browser role ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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:

Create a report as a template. Apply standardized formatting to the template. Store code in the Code section of the template. ✘ Build a web service that retrieves formatting properties and runs code. Call the web service through a report dataset. ✘ Store the formatting properties and code in database objects. Use stored procedures to populate a default value for report parameters and map each parameterto a corresponding formatting property. ✘ Create an assembly that contains formatting properties and code. Deploy the assembly on the Reporting Server and reference the assembly from each report. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables. You have the following requirements:

Use a project deployment model. Modify connection manager properties to use project parameters. Ensure that the SSISDB database is created. ✘ Use a project deployment model. Configure connections in an XML configuration file referenced by an environment variable that corresponds to the SQL Serverenvironment of each SSIS package. ✘ Use a package deployment model. Use a SQL Server package configuration with a common filter.Change the contents of the SSIS Configurations table at runtime. ✘ Use a package deployment model. Save each SSIS package to a file share that can be accessedfrom all environments. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are designing a partitioning strategy for a large fact table in a data warehouse. Tens of millions of new records are loaded into the data warehouse weekly, outside of business hours. Most queries are generated by reports and by cube processing. Data is frequently queried at the day level and occasionally at the month level. You need to partition the table to maximize the performance of queries. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

Partition the fact table by month, and compress each partition. ✘ Partition the fact table by week. ✘ Partition the fact table by year. ✘ Partition the fact table by day, and compress each partition. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are designing an extract, transform, load (ETL) process for loading data from a SQL Server database into a large fact table in a data warehouse each day with the prior day's sales data. The ETL process for the fact table must meet the following requirements:

Partition the destination fact table by date. Insert new data directly into the fact table and delete old data directly from the fact table. ✘ Partition the destination fact table by date. Use partition switching and staging tables both to remove old data and to load new data. ✘ Partition the destination fact table by customer. Use partition switching both to remove old data and to load new data into each partition. ✘ Partition the destination fact table by date. Use partition switching and a staging table to remove old data. Insert new data directly into the fact table. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic. You have the following requirements:

Create a multidimensional project and define measures and a reference relationship. ✘ Create a tabular project and define calculated columns. ✘ Create a multidimensional project and define measures and a many-to-many dimensional relationship. ✘ Create a tabular project and define measures. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are modifying a star schema data mart that feeds order data from a SQL Azure database into a SQL Server Analysis Services (SSAS) cube. The data mart contains two large tables that include flags and indicators for some orders. There are 100 different flag columns, each with 10 different indicator values. Some flags reuse indicators. The tables both have a granularity that matches the fact table. You have the following requirements:

Define the surrogate key as an INT data type. Combine the distinct flag/indicator combinations into a single dimension. ✘ Define the surrogate key as an INT data type. Create a single fact dimension in each table for its flags and indicators. ✘ Define the surrogate key as a BIGINT data type. Combine the distinct flag/indicator combinations into a single dimension. ✘ Define the surrogate key as a BIGINT data type. Create a single fact dimension in each table for its flags and indicators. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

An existing cube dimension that has 30 attribute hierarchies is performing very poorly. You have the following requirements:

set the AggregateFunction property to Sum on all measures. Use the SCOPE statement in a Multidimensional Expressions (MDX) calculation to tune the aggregation types. ✘ Set the AttributeHierarchyOptimizedState property to FullyOptimized on the attribute hierarchies. ✘ Create user-defined hierarchies. For the attributes sourced by the levels of the user-defined hierarchies, set the RelationshipType property to Rigid. Runincremental processing. ✘ Remove as many attribute hierarchies as possible from the dimension. Reintroduce the information in the attribute hierarchies as properties. Implement naturalhierarchies and set the AttributeHierarchyVisible property to False for attributes used as levels in the natural hierarchies. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

Microsoft Recertification for MCSE Business Intelligence Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner