[Free] 2018(June) Dumps4cert Microsoft 70-470 Dumps with VCE and PDF Download 51-60

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

Recertification for MCSE: Business Intelligence

Question No: 51 – (Topic 5)

You need to identify changes in the financial database. What should you do?

  1. Add SQL Server log shipping to each table.

  2. Add SQL Server mirroring to each table.

  3. Perform a full extract of each table.

  4. Enable change data capture on each table.

  5. Create an AlwaysOn Availability Group that includes all the tables.

Answer: D

Question No: 52 – (Topic 5)

You need to identify changes in the financial database. What should you do?

  1. Add SQL Server replication to each table.

  2. Extract data from the current partition of each table.

  3. Add a timestamp column to each table.

  4. Perform a full extract of each table.

  5. Enable change data capture on each table.

Answer: E

Question No: 53 – (Topic 5)

You need to design a cube partitioning strategy to be implemented as the cube size increases.

What should you do?

  1. Use relational OLAP (ROLAP) on all local partitions.

  2. Implement monthly remote partitions.

  3. Use multidimensional OLAP (MOLAP) on all local partitions.

  4. Implement monthly local partitions.

Answer: B

Question No: 54 – (Topic 5)

You need to implement the aggregation designs for the cube. What should you do?

  1. Use the Usage-Based Optimization Wizard.

  2. Use the Aggregation Design Wizard.

  3. Partition the cube by month.

  4. Implement cache warming in SSAS via an SSIS package.

Answer: B

Question No: 55 – (Topic 5)

You need to select the appropriate storage settings for the cube.

Which settings should you choose?

  1. Relational OLAP (ROLAP) with proactive caching enabled

  2. Multidimensional OLAP (MOLAP) with proactive caching enabled and a rebuild interval of 24 hours

  3. Hybrid OLAP (HOLAP) with proactive caching disabled

  4. Hybrid OLAP (HOLAP) with proactive caching enabled

Answer: C

Question No: 56 – (Topic 5)

You need to configure a parameter for the database connection string. What should you do?

  1. Use a required package parameter.

  2. Use a required project parameter.

  3. Use a package configuration.

  4. Use a global variable.

Answer: B

Question No: 57 – (Topic 5)

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

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

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

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

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

Answer: C

Question No: 58 – (Topic 5)

You need to create the Package Activity report. What should you do?

  1. Create a log table and use SSIS event handlers to write to the log table. Then create an SSRS report that uses the log table.

  2. Use the SSIS log provider for SQL Server. Then create an SSRS report that uses the sysssislog table.

  3. Create a log table and build a custom log provider to write to the log table. Then create an SSRS report that uses the log table.

  4. Create an SSRS report that uses thecatalog.executions and catalog.execution_data_statistics views.

Answer: D

Question No: 59 – (Topic 5)

You need to implement security in the cube to limit the sites visible to each user. What should you do?

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

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

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

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

Answer: C

Question No: 60 – (Topic 5)

You need to scale out SSAS. What should you do?

  1. Back up the cube on ServerB and restore it on ServerC each day.

  2. Create an empty cube on ServerC and link to the objects in the cube on ServerB.

  3. Process the cube on both ServerB and ServerC each day.

  4. Synchronize the cube from ServerB to ServerC each day.

Answer: D

100% Dumps4cert Free Download!
Download Free Demo:70-470 Demo 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 *