Query limits tab can be accessed through________.

• A.Security Manager, Query tab, Application role dialog box, Permissions
• B.Security Manager, Application Roles tab, Query dialog box, Permissions
• C.Security Manager, Application Roles tab, Application role dialog box, Permissions
• D.Security Manager, Application Roles tab, Application role dialog box, Query Properties

Correct Answer: C

Explanation
Query environment can be managed by setting query limits (governors) in the Repository (RPD) for particular Application Roles. You should always set query limits for particular application roles rather than for individual users.
Steps:
1. Login to Repository using OBIEE Admin Tool
2. Navigate to Manage > Identity
3. Go to Application Role tab, choose the role and double click on it to open.
http://123obi.com/wp-content/uploads/2011/04/25-04-2011-10-25-38.png

4. Click on Permissions tab
http://123obi.com/wp-content/uploads/2011/04/25-04-2011-10-26-13.png

5. Set the Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege.
http://123obi.com/wp-content/uploads/2011/04/25-04-2011-10-26-45.png

Comment: *

Name: *

Email: *

Verification: *

The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?

• A.Start and Stop BI Services
• B.Build Aggregate Queries
• C.Create Summary Tables
• D.Manage user logins

Correct Answer: A

Explanation/Reference:
Screenshot below.

Comment: *

Name: *

Email: *

Verification: *

Which resource identifies the OBIEE Web Catalog (webcat)?

• A.instanceconfig.xml
• B.RCU Schema
• C.Identity Store
• D.nqsconfig.ini
• E.Admin Server

Comment: *

Name: *

Email: *

Verification: *

How will you model a Type II Slowly-Changing Dimension?

• A.Add an additional column to the dimension table to capture a version of change
• B.Overwrite an existing dimension table record with the changed record
• C.Add a new row to the dimension table with a new key for the changed record
• D.Do Nothing

Comment: *

Name: *

Email: *

Verification: *

Query limits tab can be accessed through________.

• A.Security Manager, Query tab, Application role dialog box, Permissions
• B.Security Manager, Application Roles tab, Query dialog box, Permissions
• C.Security Manager, Application Roles tab, Application role dialog box, Permissions
• D.Security Manager, Application Roles tab, Application role dialog box, Query Properties

Correct Answer: C

Query environment can be managed by setting query limits (governors) in the Repository (RPD) for particular Application Roles. You should always set query limits for particular application roles rather than for individual users. Steps:
1.Login to Repository using OBIEE Admin Tool
2.Navigate to Manage > Identity
3.Go to Application Role tab, choose the role and double click on it to open.
http://123obi.com/wp-content/uploads/2011/04/25-04-2011-10-25-38.png
4.Click on Permissions tab


http://123obi.com/wp-content/uploads/2011/04/25-04-2011-10-26-13.png
5. Set the Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege.

http://123obi.com/wp-content/uploads/2011/04/25-04-2011-10-26-45.png

Comment: *

Name: *

Email: *

Verification: *