Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Aug Microsoft Official New Released 70-470
100% Free Download! 100% Pass Guaranteed!

Recertification for MCSE: Business Intelligence

Question No: 121 DRAG DROP – (Topic 9)

You are administering a SQL Server Analysts Services (SSAS) database on a server. The database hosts a financial cube based on a SQL Azure database.

You need to grant write access to the financial cube for all users in the group USA\PowerUsers.

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

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Explanation:

Box 1: In the SQL Management Studio (SSMS), connect to the SSAS instance on the server.

Box 2: Create a new role for the database.

Box 3: Add the USA\PowerUsers group to the role. Set the cube access for the role to Read and Process.

Note:

* A member of the server role for Microsoft SQL Server Analysis Services, or a member of a database role that has Full Control (Administrator) permissions in a particular database,

can create a database role that only has permission to process specified objects within the database. Giving a database role permission to process a database object lets an administrator delegate the task of processing certain objects, without also granting extraneous permissions to the user who is performing the processing.

->In SQL Server Management Studio, connect to the instance of Analysis Services,

expandRolesfor the appropriate database in Object Explorer, and then double-click a database role (or right-click Rolesand selectNew Roleto create a new database role). If this is a new role, make sure that you enter a name for the role in theRole namebox.

->ClickCubesin theSelect a Pagepane, locate the cube in theCubelist, and then

select theProcesscheck box for the cube.

->Click theOKbutton.

  • To give a database role permission to process a cube

  • There is no write permissions on a cube.

Question No: 122 HOTSPOT – (Topic 9)

You are designing a SQL Server Integration Services (SSIS) package configuration strategy.

The package configuration must meet the following requirements:

->Include multiple properties in a configuration.

->Force packages to load all settings in the configuration.

->Support Encrypting File System (EFS) formats.

You need to select the appropriate configuration. Which configuration type should you use?

To answer, select the appropriate option from the drop-down list in the dialog box.

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Explanation:

Dumps4Cert 2018 PDF and VCE

Note:

Package Configuration Types

The following table describes the package configuration types.

  • SQL Server table

    A table in a SQL Server database contains the configuration. The table can include multiple configurations.

  • XML configuration file

    An XML file contains the configurations. The XML file can include multiple configurations.

  • Environment variable

    An environment variable contains the configuration.

  • Registry entry

    A Registry entry contains the configuration.

  • Parent package variable

A variable in the package contains the configuration. This configuration type is typically used to update properties in child packages.

Question No: 123 – (Topic 9)

You are designing a reporting solution that uses SQL Server Reporting Services (SSRS) in

SharePoint integrated mode.

The reporting solution must meet the following requirements:

->Allow report writers to reuse content between different reports.

->Allow report writers to modify reusable content in SharePoint.

->Retain version history for report content.

You need to choose a reporting method that meets the requirements.

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

  1. drillthrough reports

  2. linked reports

  3. subreports

  4. report parts

Answer: D

Question No: 124 – (Topic 9)

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

  1. Create a report as a template. Apply standardized formatting to the template. Store code in the Code section of the template.

  2. Build a web service that retrieves formatting properties and runs code. Call the web service through a report dataset.

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

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

Question No: 125 – (Topic 9)

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

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

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

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

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

Answer: C

Question No: 126 – (Topic 9)

You need to design a data warehouse schema to support a multidimensional cube. The fact table will contain multiple columns representing order dates, shipping dates, and billing dates. The cube will contain a measure group based on the fact table.

What is the best design to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.

  1. In the database, create a time table for each date column in the fact table.

    From the data source view, join each date column in the fact table to the corresponding time table.

    Create dimensions for each time table.

  2. In the database, create a time table containing a column that corresponds to each date column in the fact table.

    From the data source view, join each date column in the fact table to the corresponding column in the time table.

    Create a dimension for the time table.

  3. In the database, create a time table that uses an integer primary key and a datetime column.

    Create a dimension based on the time table.

    From the Cube Designer, use the Dimension Usage tab to define a relationship between the measure group date columns and the datetime column of the time dimension.

  4. In the database, create a time table that uses an integer primary key and a datetime column.

Create a dimension based on the time table.

From the Cube Designer, use the Dimension Usage tab to define a relationship between the measure group date columns and the key column of the time dimension.

Answer: B

Question No: 127 – (Topic 9)

A company has a relational data warehouse, a SQL Server Analysis Services (SSAS) database, and a SQL Server Reporting Services (SSRS) instance. The SSAS database contains a cube named Sales. Shared data sources exist in SSRS for the relational and SSAS databases. Each company department has its own report writers.

Report writers in the Marketing department want to create new reports by using Report Builder. Many reports will include data generated by a custom formula that references data stored either in a data warehouse table or in the Sales cube. The custom formula will compare time periods across multiple products, categories, and regions.

You have the following requirements:

->Ensure that only Marketing department report writers can access the custom formula.

->Implement only one dataset.

->Ensure that the dataset references the data source that will provide the fastest data retrieval.

You need to meet the requirements to support the Marketing department report writers.

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

  1. Create, deploy, and secure a shared dataset that references the SSAS database shared data source and includes a calculated member for the custom formula.

  2. Create a calculated member in the Sales cube. Create, deploy, and secure a shared dataset that references the SSAS database shared data source and includes the calculated member from the cube.

  3. Create and secure in the data warehouse a stored procedure that implements the custom formula. Create and deploy a shared dataset that references the data warehouse shared data source.

  4. Create, deploy, and secure a shared dataset that references the data warehouse shared data source and includes custom Transact-SQL (T-SQL) code for the custom formula.

Answer: B

Question No: 128 HOTSPOT – (Topic 9)

You are designing aggregations for a SQL Server Analysis Services (SSAS) cube. You need to ensure that every aggregation includes the Category attribute.

Which option should you select? To answer, select the appropriate option button in the answer area.

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Question No: 129 – (Topic 9)

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:

->Ensure that the deployment model supports changing the content of connection

strings by using parameters at execution time.

->Ensure that the deployment model automatically starts from calls to the catalog.start_execution stored procedure in the SSISDB database.

->Maximize performance at execution time.

->Minimize development effort.

You need to design a solution that meets the requirements.

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

  1. Use a project deployment model. Modify connection manager properties to use project parameters. Ensure that the SSISDB database is created.

  2. Use a project deployment model. Configure connections in an XML configuration file referenced by an environment variable that corresponds to the SQL Server environment of each SSIS package.

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

  4. Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments.

Answer: A

Question No: 130 DRAG DROP – (Topic 9)

You have a business intelligence (BI) solution that uses SQL Server Integration Services (SSIS). The BI solution includes an extract transformation, and load (ETL) system.

You are designing a logging and auditing strategy for the ETL system.

You need to ensure that an ETL administrator can view the row counts of any data flow path for each package execution.

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.

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

100% Dumps4cert Free Download!
70-470 PDF
100% Dumps4cert Pass Guaranteed!
70-470 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.