Microsoft Recertification for MCSE Business Intelligence

Question - 15 Maximum mark : - 29

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

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 many-to-many dimensional relationship. Create partitions in SQL Server Management Studio
(SSMS). ✘ Create a multidimensional project and define measures and a reference relationship. Create partitions in SQL Server Data Tools (SSDT). ✘ Create a tabular project and define measures. Create partitions in SQL Server Data Tools (SSDT). ✘ Create a tabular project and define calculated columns. Create partitions in SQL Server Management Studio (SSMS). ✔

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 that will load multiple Online Transactional Processing (OLTP) data sources into a SQL Server data mart. You have the following requirements:

Use a Data Profiling task. Use a Data Flow task to extract the XML output of the Data Profiling task into a SQL Server table. Query the table to view the exceptions. ✘ Use Data Flow tasks to process the clean data. ✘ Use a Data Profiling task. Read the exceptions in Data Profile Viewer. ✘ Design a stored procedure that examines data for common dirty data patterns. Use an Execute SQL task. ✔

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. ✘ Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments. ✘ Use a package 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 project deployment model. Modify connection manager properties to use package parameters. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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

Migrate SSRS content to a separate instance of SSRS 2012 on the same server. ✘ Perform an in-place upgrade of the SSRS environment. ✘ Migrate SSRS content to new servers that run SSRS 2012. ✘ Install SSRS 2012 on a new SharePoint farm and migrate content to the new farm. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are redesigning a SQL Server Analysis Services (SSAS) database that contains a cube named Sales. Before the initial deployment of the cube, partition design was optimized for processing time. The cube currently includes five partitions named FactSalesl through FactSales5. Each partition contains from 1 million to 2 million rows.

Use the Usage-Based Optimization Wizard to create aggregations for the current partitions. ✘ Use the Aggregation Design Wizard to create aggregations for the current partitions. ✘ Combine all the partitions into a single partition. Use the Usage-Based Optimization Wizard to create aggregations. ✘ Combine all the partitions into a single partition. Use the Aggregation Design Wizard to create aggregations. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

group of report writers develop reports. The report writers currently use Report Builder 1.0 and report models. The report writers are not trained on SQL Server query writing. Their report assignments come from various departments within the organization. The company is upgrading to SQL Server 2012 with SQL Server Reporting Services (SSRS) in native mode. After the upgrade, reports will retrieve data from a large new data warehouse that will reside on an instance of the SQL Server 2012 Database Engine. Reports for each department will retrieve data from only a subset of the data warehouse tables. You are designing the data access strategy. You have the following requirements:

Create report models by using SQL Server Data Tools (SSDT). Include data sources and data source views for each department's data requirements. Configure each data source to use integrated security. ✘ Create one shared data source that uses integrated security. Create an embedded dataset for each report. ✘ Create one shared data source that uses integrated security. Create one shared dataset that includes all tables required by the report writers. ✘ Create one shared data source that uses integrated security. Create a shared dataset for each department's data requirements. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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

Create a shared schedule. Configure the datasets to expire on the shared schedule. ✘ 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. ✘ 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 ReportServerTempDBdatabase. Schedule the job to run every day after the purge process completes. ✘ Republish the cached datasets by using SQL Server Data Tools. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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:

Retrieve all customers and use drilldown groupings to show or hide hierarchy levels. ✘ Add a report part for each hierarchy level. ✘ Add a subreport for each hierarchy level. ✘ Display only the children of the current hierarchy level and drill through to the selected member. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You deploy a PowerPivot workbook to a PowerPivot Gallery in a Microsoft SharePoint site. Workbook data comes from two different sources: Source A and Source B. The workbook contains five tables with a total of 20 million rows from Source A, and three small lookup tables from Source B. Data from Source A is updated throughout the day. Data from Source B is updated at 3:00 P.M.

Power View ✘ Report Designer ✘ Report Builder ✘ PerformancePoint Services ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

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 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. Save each SSIS package to a file share that can be accessed from all environments. ✘ Use a project deployment model. Modify connection manager properties to use project parameters. Ensure that the SSISDB database is created. ✔

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

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