2018 Jan Oracle Official New Released 1z0-526
100% Free Download! 100% Pass Guaranteed!

Oracle Business Intelligence Foundation 10.1.3 Essentials

Question No: 41

Which two of the following are true about session variables and repository variables?

  1. Sessions variables are created and assigned a value when a user logs in

  2. sessions variables can be used in queries but repository variable cannot

  3. repository variables have a single value for all users at any point in time

  4. repository variable cannot be modified except by restating the server

  5. BI server substitutes the values of the session variable for the variable contained in the analytics repository

Answer: A,C

Question No: 42

The BI server architect has created two more logical columns in the business models and mapping layer

and dragged then to the presentation layer. She saved the

repository and restarted BI server and web service. When she opens the web catalog, she does not see

the new columns that she created in the repository. Which two of the following could she do?

  1. In analytics web, click the “reload server metadata” Link

  2. Open the analytics administration tool and save the repository again

  3. Open the analytics administration tool and check in all objects

  4. Restart the oracle BI presentation services service

Answer: A,D

Question No: 43

Which two of the following variables persist only while a user’s session is active?

  1. System session variables

  2. Non-system session variables

  3. Static repository variables

  4. Dynamics repository variables

Answer: A,B

Question No: 44

Which three of the following are true of a cache hit? (Choose Three)

  1. when caching is enabled, each query is evaluated to see if it qualifies for a cache hit

  2. A cache hit means that the server went to the database because the conditions were not met

  3. If the metadata shows a cache hit, the results are retuned by the server without accessing the database

  4. The cache file produced the same results even when the underlying database tables are updated with new values

  5. A cache hit occurs when the query is at the same or lover level than the cache

Answer: A,C,D

Question No: 45

Which two can be used to customize the user interface in Oracle BI Presentation services?

  1. Dashboard editor

  2. Styles and skins

  3. XML message files

  4. scripts in installation folder

  5. Javascripts

Answer: B,C

Question No: 46

Select three items that may be displayed in dashboards.

  1. documents

  2. Alert from oracle BI delivers

  3. web sites

  4. Images, Charts, tables, text, folders

  5. Saved analytics requests

Answer: B,D,E

Question No: 47

You have imported the sales aggregate table that is aggregated by period with the lowest granularity of month. After saving the repository and then restarting the appropriate server, you can the queries in BI answers to see the total sales figure for each product line by month. Then you saw that the query was run against the sales aggregate table and not the sales details table. Then you ran the queries to see the total sales figure for each product line by day. What would you see in the log for the latest query?

  1. The query uses the sales detail table

  2. The query still uses the sales aggregate table

  3. The “select” statement is identical to the one from the previous run

  4. The query has not completed successfully

Answer: A

Question No: 48

ABC would like to see salesperson revenue by regional revenue to calculate the regional revenue each salesperson generates. Which of the following will ABC use to calculate that?

  1. Rank measure

  2. Percentage measure

  3. Share measure

  4. Grand total measure

Answer: C

Question No: 49

Your customer has indicated that the data displayed on a particular dashboard is not refreshed at a sufficient rate. You know that some(but not all) of the data in the underlying data warehouse is updated hourly the rest of the data is updated daily.

  1. Turn off caching on the hourly updated physical tables.

  2. Turn off caching on the hourly updated logical tables.

  3. Reduce cache expiration time on all physical tables to reflect the data update frequency

  4. Employ use of an event polling table to force a cache refresh of the hourly updated data

  5. Restructure the logical business model such that physical sources with different refresh rates are not associated within a logical join

  6. refer to NQQuery.log to determine the location of the cache-data files(s) and write a script to periodically remove these cache files

Answer: D

Question No: 50

Which three statements are true about cache manager?

  1. It can be used to view the contents of cache entries.

  2. It is active in online and offline mode.

  3. It can be used to purge entries by user.

  4. It can be used to purge entries by physical table.

  5. Can be used to specify maximum cache size.

  6. Can be used to specify location of cache files.

Answer: A,C,D

100% Free Download!
Download Free Demo:1z0-526 Demo PDF
100% Pass Guaranteed!
Download 2018 EnsurePass 1z0-526 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 EnsurePass IT Certification PDF and VCE