PassTestからの試験合格準備の必需品1z0-591試験トレーニング問題
有効なパス率は11gの1z0-591試験問題
Oracle 1Z1-591認定を取得するには、候補者は、Oracle Bi Enterprise Editionを使用したダッシュボード、レポート、分析、Oracle BI管理ツールを使用したデータモデルの作成と構成など、さまざまな分野で習熟度を実証する必要があります。 Oracle BIの認証。この試験には、レポートの作成と配布のためのOracle BI Publisherに関する質問、リアルタイムの意思決定のためのOracleリアルタイムの決定、および多次元分析のためのOracle Essbaseも含まれています。
質問 # 58
A customer needs to do a cross database join between two tables where, one of the tables has a small number of values and the other has a large number of values. How can you optimize the way the BI Server processes the query?
- A. By specifying a one-to-many join between the tables with the small and large numbers of values
- B. By specifying a many to one join between the tables with the small and large numbers of values
- C. By specifying a driving table
- D. By creating your logical join by using the Joins Manager
- E. By creating your joins by using the Business Model Diagram
正解：C
解説：
Explanation
You can specify a Driving table parameter in a complex join.
Driving tables are for use in optimizing the manner in which the Oracle BI Server processes cross-database joins when one table is very small and the other table is very large.
The BI Server will query the driving table (the small one) and will get a list of values. The BI Server will then generate a second SQL using a parameterized IN list with the values from the first query.
Specifying driving tables leads to query optimization only when the number of rows being selected from the driving table is much smaller than the number of rows in the table to which it is being joined.
質問 # 59
Which option is used to enter the rank function when creating a new rank measure?
- A. Initialization Block
- B. Connection Pool
- C. Web Catalog
- D. Expression Builder
正解：D
解説：
Explanation
Example (see step 4 and 5 below): Getting Top-N Sales Reps for Year and Year-1
1. Under the "Business Model and Mapping" Layer, right click the "F1 Revenue" and select "New Object" ->
"Logical Column..."
2. In the "Logical Column" Window give for Name: Year Ago Revenue as seen below:
http://obiee2go.files.wordpress.com/2012/05/hfhdgjbj.png
3. Goto the "Column Source" Tab and select "Derived from existing columns using an expression" radio button then click on the "Edit Expression" icon.
4. Enter the following expression in the "Expression Builder" Window by selecting "Functions" in the
"Category:" list, "Time Series Functions" in the "Functions:" list then "Ago" "Time Series Functions:" section.
5. Select the "<<Measure>>" in the "Ago( )" function, then select "Logical Tables" in the "Category:" list,
"F1 Revenue" in the "Logical Tables:" list, then double click the "Revenue" in the "Columns:" list.
Etc.
質問 # 60
Pre Deployment sign-off is a milestone for a OBIEE implementation and is based on successful completion of certain tasks. Which option is not one of them?
- A. Performance Tuning
- B. Data Validation / Verification
- C. System Testing
- D. Test Environment
- E. Projectinitiation and resourcing
正解：E
質問 # 61
Which OBIEE capability enables developers to build Aggregate tables?
- A. Aggregate Persistence Wizard
- B. Table Builder
- C. Expression Builder
- D. Query Analyzer
正解：A
解説：
Aggregate Persistence Wizard automates the creation and initial population of aggregates, persists them in a back-end database and configures the BI Server metadata layer so that they're used when appropriate.
質問 # 62
When creating a query. Subject areas can be combined via point and click as long as____.
- A. the subject areas share objects of the same name
- B. the subject areas are both from the same physical source, though they may be in separate business layers
- C. two or more subject areas cannot be joined together without manually mapping the contents
- D. the subject areas both share the same model in the business model and mapping layer
正解：D
解説：
Explanation
Users in Oracle BI Answers can create queries that span multiple subject areas, as long as the subject areas correspond to the same business model.
質問 # 63
When creating a query. Subject areas can be combined via point and click as long as____.
- A. the subject areas share objects of the same name
- B. the subject areas are both from the same physical source, though they may be in separate business layers
- C. two or more subject areas cannot be joined together without manually mapping the contents
- D. the subject areas both share the same model in the business model and mapping layer
正解：D
解説：
Explanation/Reference:
Users in Oracle BI Answers can create queries that span multiple subject areas, as long as the subject areas correspond to the same business model.
Incorrect answers:
D: "How do I combine data from two different subject areas into one report?" Although there are a couple of very limited options for doing so within Answers - Union queries and Sub-queries, the real solution is that the Subject Areas themselves were probably not designed properly.
Note: Although each subject area must be populated with contents from a single business model, you can create multiple subject areas for one business model. For very large business models, you may want to do this to help users work with the content.
質問 # 64
Identify the reason why Oracle OLAP provides a favorable aggregation strategy.
- A. OLAP cubes can be easily transported from database to database.
- B. OLAP cubes eliminate the need for a large number of aggregate tables.
- C. OLAP cubes are stored outside of the database in highly optimized file structures.
- D. OLAP cubes can be queried by using SQL.
正解：D
解説：
All metadata for cubes and dimensions is stored in the Oracle database and revealed in the data dictionary views, so that you can query the entire business model in SQL.
質問 # 65
An organization has re-implemented one of its systems but has not moved history. One database has data for all years up to 2010 and the other has data for years from 2011 to the present. The organization needs data from the years 2010 and 2011 on a single report. How can you model this in the RPD?
- A. By creating two Logical Fact Tables for each database
- B. By creating joins in the physical model so it looks like a single table
- C. By creating two logical table sources, that specify in Content tab using the Fragmentation content areas to specify the years for each source
- D. By creating two logical table sources and checking the "This Source should be combined with other sources at this level" box leaving the Fragmentation content area blank.
- E. By creating one logical table sources and checking the "This Source should be combined with other sources at this level" box
正解：C
解説：
Explanation/Reference:
Note: This source should be combined with other sources at this level (check box) Description: Check this box when data sources at the same level of aggregation do not contain overlapping information. In this situation, all sources must be combined to get a complete picture of information at this level of aggregation.
Note 2: To use a source correctly, the Analytics Server has to know what each source contains in terms of the business model. Therefore, you need to define aggregation content for each logical table source of a fact table.
The aggregation content rule defines at what level of granularity the data is stored in this fact table.
Use the Content tab of the Logical Table Source dialog box to define any aggregate table content definitions, fragmented table definitions for the source, and Where clauses (if you want to limit the number of rows returned).
Reference: Siebel Business Analytics Server Administration Guide > Creating and Administering the Business Model and Mapping Layer in a Repository > Creating and Administering Logical Table Sources (Mappings) > Defining Content of Logical Table Sources
質問 # 66
Why is it necessary to join multiple source tables to a single dimension?
- A. Because a single source table often contains all the dimensions needed
- B. Because the dimensions tables are built in the transactional systems
- C. Because transactional source systems are often denormalized
- D. Because transactional source systems are often normalized
正解：D
解説：
Explanation
Explanation/Reference:
Denormalized data in the transactional system could be divided into different tables to increase performance.
質問 # 67
What would you use to customize the text elements that appear on BI Analysis, Delivers and Dashboard pages?
- A. BI Presentation services web template
- B. DHMLMessage files
- C. Cascading Style Sheets
- D. XMLMessage Files
正解：C
解説：
You can control the way that the interface for Oracle BI EE is displayed to users by creating skins and styles.
While skins and styles are typically used to customize the look and feel of analyses and dashboards by providing logos, color schemes, fonts, table borders, and other elements, they can also be used to control the position and justification of various elements by including specialized style tags in the relevant style sheet (.css) file.
You can check the directory skin location with a right click on a OBIEE dashboard page, select show source code and search "custom.css".
質問 # 68
What are the two types of Session Variables?
- A. Static
- B. System
- C. Dynamic
- D. Non System
正解：B、D
解説：
There are two types of session variables:
System - A session variable that the Oracle BI Server and Oracle BI Presentation Services use
for specific purposes.
System session variables have reserved names that cannot be used for other kinds of variables
(such as static or dynamic repository variables and non-system session variables).
Non-system - A system variable that the administrator creates and names. For example, the
administrator might create a SalesRegion non-system variable that initializes the name of a user's
sales region.
The administrator creates non-system session variables using the Oracle BI Administration Tool.
Note: Session Variables
A session variable is a variable that is initialized at login time for each user. When a user begins a
session, the Oracle BI Server creates a new instance of a session variable and initializes it.
There are as many instances of a session variable as there are active sessions on the Oracle BI
Server. Each instance of a session variable could be initialized to a different value.
質問 # 69
The highest sales amount for this year is $10,000. If you create a rank measure for sales this year and display it on a report, the value will be________.
- A. Year
- B. 0
- C. 1
- D. $10,000
正解：B
解説：
Explanation/Reference:
The rank measure is numbered from 1. The highest sales amount will be ranked 1.
質問 # 70
What is an example of a Session Variable?
- A. User Organization
- B. ETL Load Date
- C. Top Customers by Revenue
- D. OLAP DSN
正解：A
解説：
Explanation/Reference:
Note 1: There are four types of variables that you can use:
Session
Repository
Presentation
Request
Note 2: Session Variables
A session variable is a variable that is initialized at login time for each user. When a user begins a session, the Oracle BI Server creates a new instance of a session variable and initializes it.
There are as many instances of a session variable as there are active sessions on the Oracle BI Server. Each instance of a session variable could be initialized to a different value.
There are two types of session variables:
System - A session variable that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes.
System session variables have reserved names that cannot be used for other kinds of variables (such as static or dynamic repository variables and non-system session variables).
Non-system - A system variable that the administrator creates and names. For example, the administrator might create a SalesRegion non-system variable that initializes the name of a user's sales region.
The administrator creates non-system session variables using the Oracle BI Administration Tool.
Incorrect answers:
A: ETL Load Date is a DAC Source System Parameter.
C: OLAP DSN is a Repository variable.
質問 # 71
When creating a query. Subject areas can be combined via point and click as long as____.
- A. the subject areas share objects of the same name
- B. the subject areas are both from the same physical source, though they may be in separate business layers
- C. two or more subject areas cannot be joined together without manually mapping the contents
- D. the subject areas both share the same model in the business model and mapping layer
正解：D
解説：
Users in Oracle BI Answers can create queries that span multiple subject areas, as long as the subject areas correspond to the same business model.
質問 # 72
Identify the two Object level security functions that are done on the repository by using the BI Admin tool.
- A. Assign users to a web catalog group
- B. Create a new repository group
- C. Create a new user in the repository
- D. Create a web catalog group
- E. Define permissions for Dashboard
正解：B、C
解説：
The Oracle Business Intelligence (BI) Administration Tool can be used to build, modify, enhance, and manage an Oracle BI repository.
C: To add a new user to a repository
1 Open a repository in the Administration Tool.
2 Display the security manager by selecting Manage > Security.
3 Select Action > New > User to open the User dialog box.
4 Type a name and password for the user.
5 If you want to log queries for this user in the query log, change the query logging level to 1 or 2.
6 Click OK.
This creates a new user with default rights granted to it.
Note: What is Oracle BI Admin Tool/Oracle Business Intelligence Administration Tool?
Oracle Business Intelligence Administration Tool is Used to manage OBIEE server Available only for Windows operating systems.
A Windows application that allows the BI Server administrator to create & edit repositories.
Can edit repositories in either online or offline mode.
Having a session manager and a cache manager in online mode.
質問 # 73
......
全問1z0-591問題集とOracle Business Intelligence Foundation Suite 11g Essentialsトレーニングコース：https://www.passtest.jp/Oracle/1z0-591-shiken.html
無料テストエンジンOracle Business Intelligence Foundation Suite 11g Essentials認定試験：https://drive.google.com/open?id=1pleRXRmgcemxjNnJ42f2PnGhynSMrCFk