Question 1.
You are using SQL Server Management Studio (SSMS) to configure the backup. You need to meet the technical requirements.

Which two backup options should you configure? (Choose two).

A. Enable encryption of the backup file.
B. Enable compression of the backup file.
C. Disable encryption of the backup file.
D. Disable compression of the backup file.

Answer: B, C

Explanation:

Question 2.
You need to convert the Production, Sales, Customers and Human Resources databases to tabular BI Semantic Models (BISMs).

Which two of the following actions should you perform? (Choose two)

A. You should select the tabular mode option when upgrading the databases using the Database Synchronization Wizard.
B. You should select the tabular mode destination option when copying the databases using SQL Server Integration Services (SSIS).
C. You should select the tabular mode option during the installation of SQL Server Analysis Services.
D. You should redevelop the projects and deploy them using SQL Server Data Tools (SSDT).

Answer: A, D

Explanation:

Question 3.
Users have advised that they are not receiving report subscriptions from SQLReporting01. You confirm that the report subscriptions are not being delivered.

Which of the following actions should you perform to resolve the issue?

A. You should run the SQL Server 2012 Setup executable on SQLReporting01 to generate a configuration file.
B. You should reset the password of the SQL Server Service account.
C. You should manually fail over the SSAS cluster.
D. You should restore the ReportServer database on SQLReporting01.

Answer: C

Explanation:

Question 4.
Users have advised that they are not receiving report subscriptions from SQLReporting01. You confirm that the report subscriptions are not being delivered.

Which of the following actions should you perform to resolve the issue?

A. You should run the SQL Server 2012 Upgrade Wizard to upgrade the active node of the SSAS cluster.
B. You should start the SQL Server Agent on the active node of the SSAS cluster.
C. You should restore the ReportServerTempDB database on SQLReporting01.
D. You should start the SQL Server Agent on SQLReporting01.

Answer: D

Explanation:

Question 5.
You need to make the SSAS databases available on SSAS2012 to enable testing from client applications. Your solution must minimize server downtime and maximize database availability. 

What should you do?

A. You should detach the databases from the SSAS cluster by using SQL Server Management Studio (SSMS) then attach the databases on SSAS2012.
B. You should copy the database files from the SSAS cluster to SSAS2012.
C. You should export the databases from the SSAS cluster by using SQL Server Management Studio (SSMS) then import the databases on SSAS2012.
D. You should restore a copy of the databases from the most recent backup.

Answer: D

Explanation:

Question 6.
You need to create a BISM to meet the Reporting and Analysis requirements.

Which of the following should you include in your solution? (Choose all that apply)

A. Create a multidimensional project.
B. Create a tabular project.
C. Use the use hybrid OLAP (HOLAP) storage mode for the cube.
D. Set the model DirectQuery mode to Off.
E. Set the model DirectQuery mode to On.
F. Select DirectQuery for the project query mode.
G. Select In-Memory with DirectQuery for the project query mode.

Answer: B, E, G

Explanation:

Question 7.
You need to configure the servers to meet the security requirements for SQLReporting01 connections to the SSAS cluster. Downtime must be minimized during the configuration. 

Which three of the following actions should you perform? (Choose three).

A. Set the authentication type option to Custom on SQLReporting01.
B. Restart the SQL Server service on SQLReporting01.
C. Restart the IIS Server service on SQLReporting01.
D. Register a service principle name (SPN) with Active Directory for the Reports Server service.
E. Set the authentication type option to Negotiate on SQLReporting01.
F. Register a service principle name (SPN) with Active Directory for the Analysis Services service.

Answer: C, E, F

Explanation:

Question 8.
You modify the ReportingServicesService.exe.config file on the reporting servers to enable logging.

Which log contains the ClientIP and ServerPort fields to determine which IP address and port numbers are used to connect to the reports server?

A. The Windows System Application log.
B. The Report Server HTTP log.
C. The Report Server Service Trace Log.
D. The Report Server Execution Log.

Answer: B

Explanation:

Question 9.
One of the cube requirements states that the cube should include aggregation designs. 

How should you meet this requirement?

A. By using the CREATE MINING MODEL statement.
B. By dividing the cube into monthly partitions.
C. By using the Aggregation Design Wizard.
D. By using the CREATE SET statement.
E. By running the Usage-Based Optimization Wizard.

Answer: C

Explanation:

Question 10.
You need to configure the cube partitioning to manage the expected increase in size. 

How should you configure the partitioning?

A. You should configure remote monthly partitioning.
B. You should configure all local partitions to use HOLAP (Hybrid OLAP).
C. You should configure local daily partitioning.
D. You should configure all local partitions to use MOLAP (Multidimensional OLAP).

Answer: A

Explanation:

	Web www.certsbraindumps.com