Free Oracle 1Z0-527 Exam Dumps Questions & Answers

When selecting a column to filter or sort report, which should you choose to have the LEAST impact on performance?

• A.  Fields containing CASE statements
• B.  Standard pick lists
• C.  Custom pick lists
• D.  Indexed fields
• E.  Custom fields

You were asked to create a group of five custom reports for the Midwest sales region.
First, you added a new shared folder called Midwest Sales Region. Next, you created the five custom reports, saving them In the new folder as you finished them. Who can access this new shared report Folder if there are no roles associated with it?

• A.  Only the user that created the report folder can access It.
• B.  Only users with the Administrator role can access It.
• C.  No user can access it until at least one role is associated to it.
• D.  Every user that has access to the Reports Homepage can access it.
• E.  Only users with the Access All Data in Analytics role privilege can access it.

Service managers want to see the number of open and closed service requests by product, owner, account, and industry. You determine that a dashboard would be the best option to represent this content. How would you begin creating a custom dashboard?

• A.  Click the Dashboard tab, and then select a prebuilt dashboard and click the Edit link.
• B.  Click the Reports tab, and then click the Design Analyses link and the New Dashboard button.
• C.  Click the Reports tab, and then click the Manage Dashboards link and the New Dashboard button.
• D.  Click the Reports tab, and then click the New Dashboard button.
• E.  Click the Dashboard tab, and then click the Manage Dashboards link and the New Dashboard button.

Select the true statement regarding a user's access to records.

• A.  Adding a user to a book of business can interfere with other assignments of that user to other books.
• B.  Books of business and user role settings work together to define a user's access to records.
• C.  Adding a user to a book of business negates the role settings for that user.
• D.  Assigning a user to a book of business automatically changes a user's role settings.

Select the true statement regarding Manager Visibility.

• A.  It gives managers access to the records of the users who report to them directly or indirectly. Access level to the records Is controlled by the subordinates" owner access profile.
• B.  When Manager Visibility is enabled; a manager has access to his/her subordinates passwords and security questions.
• C.  The reporting structure determines where budgets and funding records reside.
• D.  It gives managers access to the records of the users who report to them directly or indirectly. Access level to the records Is controlled by the manager's owner access profile.