52.You take care of a SQL Server Examination Solutions (SSAS) database. The database is configured by utilizing a variety of security roles.
The database is accessed by a Microsoft ASP.Web software that runs on a remote personal pc. The appliance is configured to use Windows Authentication.
It's good to be sure which the consumers with the software can successfully accessibility the SSAS database. You also have to assure that security limitations in the roles are applied.
What in case you do?
A.Configure Kerberos authentication.
B.Configure Examination Services for HTTP authentication.
Do.Set the AnonymousConnectionsEnabled policy to Real.
D.Set the SecurityRequireClientAuthentication residence to Authentic.
Reply: A
53.You maintain a SQL Server 2008 Evaluation Providers (SSAS) instance. The instance features a database.
You alter the DataDir property with the instance to a new folder.
You must guarantee which the instance usages the new folder inside minimal number of downtime.
What should you do?
A.Method the database.
B.Synchronize the database.
C.Restart the Analysis Providers company.
D.Delete the information from the original folder, and then restart the Evaluation Services services.
Reply: A
54.You retain a SQL Server 2008 Analysis Companies (SSAS) instance.
You intend to operate the Usage-Based Optimization Wizard.
It is advisable to allow question logging.
What should you do?
A.Set the LogDir server house to a legitimate path.
B.Set the QueryLogSampling server house to 10.
C.Set the AllowedBrowsingFolders server property to incorporate the folder in the LogDir environment.
D.Set the QueryLogConnectionString server home to some legitimate relationship string.
Response: D
55.You retain a SQL Server 2008 Evaluation Providers (SSAS) database.
You intend to troubleshoot query performance through the use of SQL Profiler.
It's essential to recognize the queries that have a very long time to operate.
Which trace occasion in case you use?
A.Query Cube Finish
B.Query Subcube
C.MDX Script Finish
D.Get Information from Cache
Remedy: B
56.You administer a SQL Server 2008 Analysis Providers (SSAS) instancE.You plan to troubleshoot query efficiency through the use of a Dynamic Management Look at (DMV).
You'll have to recognize query periods that execute a query for over thirty,000 ms.
Which DMV in the event you use?
A.Discover_Traces
B.Discover_Sessions
C.Discover_Commands
D.Discover_Connections
Reply: C
57.You manage a SQL Server 2008 Examination Services (SSAS) database on the default instancE.You plan to doc the Analysis Companies functionality knowledge.
It is advisable to gather tips relevant with the short term file utilization when the database is processed.
Which object in the event you use?
A.MSAS 2008: Memory
B.MSAS 2008: Cache
C.MSAS 2008: Proc Aggregations
D.MSAS 2008: Storage Engine Query
Response: Do
![[Valid RSS feed]](http://www.greatarticlesite.com/images/icon_Rss.png "XML Feed For RSS"){kind=icon}
Category Rss Feed
Print This Article
Add To Favorites
