Which value should you configure?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
A server named ABC-SSAS1 runs a SQL Server Analysis Services (SSAS) instance in tabular mode.

ABC-SSAS1 is used to process tabular models that are larger than the amount of memory
installed in the server.
To prevent Out of Memory errors, you need to configure ABC-SSAS1 to allow memory paging
using the default Windows Server page file (pagefile.sys).
In SQL Server Management Studio, you connect to the SSAS instance and display the properties
window.
Which value should you configure?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
A server named ABC-SSAS1 runs a SQL Server Analysis Services (SSAS) instance in tabular mode.

ABC-SSAS1 is used to process tabular models that are larger than the amount of memory
installed in the server.
To prevent Out of Memory errors, you need to configure ABC-SSAS1 to allow memory paging
using the default Windows Server page file (pagefile.sys).
In SQL Server Management Studio, you connect to the SSAS instance and display the properties
window.
Which value should you configure?

A.
You should set the VertiPaqPagingPolicy value to 1.

B.
You should set the VertiPaqPagingPolicy value to 2.

C.
You should set the VertiPaqMemoryLimit value to 1.

D.
You should set the VertiPaqMemoryLimit value to 2.

E.
You should set the LowMemoryLimit to a higher value.

F.
You should set the TotalMemoryLimit to a lower value.

Explanation:



Leave a Reply 1

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