[2025年06月21日] 最新11g 1z0-591日本語実際の無料試験解答 [Q31-Q53]

[2025年06月21日] 最新11g 1z0-591日本語実際の無料試験解答

11g 1z0-591日本語問題集最新の練習テスト122独特な解答

質問 # 31

A. Option C
B. Option D
C. Option B
D. Option A

正解：D

解説：

質問 # 32

A. Option A
B. Option C
C. Option D
D. Option B

正解：D

解説：

http://gerardnico.com/wiki/_media/dat/obiee/bi_server/design/fact_table/obiee_fragmentation_content_one_colu

質問 # 33

A. Option D
B. Option C
C. Option E
D. Option B
E. Option A

正解：B、D、E

解説：

質問 # 34
クエリキャッシングを実装することの2つの欠点は何ですか？

A. BIサーバの処理時間を短縮
B. キャッシュ結果が古い
C. キャッシュ格納領域
D. 増加したネットワークトラフィック
E. 多くの管理者の時間が必要

正解：B、C

解説：
B: The problem with caching of any kind is how to deal with stale data. How you decide to deal with this depends on how time critical your business intelligence queries happen to be. OBIEE provides a wide variety of mechanisms for dealing with stale data. The cache can be purged automatically at intervals. Caching can be enabled selectively for individual physical tables, so that data in a frequently updated table is never cached.
OBIEE provides a set of ODBC procedures that can be called when ETL processes complete to programmatically purge designated tables. But, by far the best way to selectively purge the cache is to use an event polling table. This table is populated by the client database whenever changes are made to any table (by an ETL process for a data warehouse or by a table-based trigger for an OLTP database). At specified intervals the BI Server polls this event polling table and deletes from its cache any query results that are dependent on the changed data.

質問 # 35
BI Serverメタデータリポジトリの3つの利点を確認します。

A. 開発から本番環境に移行するための物理層の小さな変更
B. 1つの論理オブジェクトへの連合データソースのマッピング
C. 3つの層が最高レベルのセキュリティをサポートします
D. レポートを失うことなく物理的な情報源を変更する機能

正解：A、B、C

解説：
A: OBIEE Federated Repository
Instead of moving data in to a single database, OBIEE - BI Administration can access multiple databases and create a single federated repository.OBIEE BI Answer uses this federated repository and build the ad-hoc reports and dashboards.
D: Repository Metadata Consists of 3 Layers
* The Physical Layer (Schema)
* The Business Model and Mapping Layer
* The Presentation Layer
Note:

質問 # 36
Oracle BI Serverのキャッシュ管理手法に含まれるオプションは2つありますか。

A. Excelにダウンロードする最大行数
B. キャッシュレポートを調べる
C. 主題分野へのアクセスを管理する
D. スケジュールサーバのパスワード
E. NQSConfig.iniを使用して手動でパラメータを編集する

正解：B、E

解説：
A: Much of the configuration of OBI that used to be done in the NQSConfig.ini files can now be done using this front end console, which in turns updates the NQSConfig.ini file. Things in the NQSConfig.ini file that are set by EM are noted in the file with '# This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager'. Some things that needs to be setup manually in the NQSConfig.ini file are:
1. Usage Tracking
2. Dynamic Libraries
3. Query Optimization Flags
4. MDX Member Name Cache Section (SAP BW)
5. More specific General Settings where EM doesn't contain the level of detail required D: Cache Management Techniques include
* Inspecting the cache reports
* Configuring the cache parameters
* Setting caching and cache persistence for tables
* Using the Cache Manager
* Inspecting SQL for cache entries
* Modifying the Cache Manager column display
* Purging the cache entries manually using the Cache Manager
* Purging the cache entries automatically
* Using event polling tables
* Seeding the cache

質問 # 37

A. Option A
B. Option C
C. Option D
D. Option B

正解：D

解説：

http://1.bp.blogspot.com/--vsF4VJcbss/T2H9xyA8HsI/AAAAAAAAAd4/JOFqD3KwgAE/s640/3.jpg

質問 # 38
Type IIの緩やかに変化するディメンションをどのようにモデル化しますか。

A. なにもしない
B. 変更したレコードで既存のディメンションテーブルレコードを上書きします
C. 変更されたレコードの新しいキーを使ってディメンションテーブルに新しい行を追加します
D. ディメンション表に列を追加して変更のバージョンを取得します

正解：C

解説：
Dimensional Modeling - Slowly Changing Dimensions
* Type 1 - Overwrite Original Value
A change does not require tracking
* Type 2 - Add a new record
With Type II SCD, a new version of the dimension record (row) is created, and the existing version is marked as history.
Each row does not correspond to a different instance of an entity but a different "state", a "snapshot" of the instance at a point in time.
Note: Tracking changes in dimension is referred in datawarehousing as slowly changing dimensions.
In the source system a lot of changes are daily made :
new customers are added,
addresses are modified,
new regional hierarchies are implemented,
or simply the product descriptions and packaging change.
These sorts of changes need to be reflected in the dimension tables and in several cases, the history of the changes also needs to be tracked.
By remembering history, we are then able to look at historical data and compare it to their current situation.

質問 # 39

A. Option A
B. Option C
C. Option D
D. Option B

正解：D

質問 # 40
ケースステートメントロジックのポイントアンドクリックによる生成は、どのオプションからアクセスできますか。

A. 列式 - > [ビン]タブ
B. 列のプロパティ - >条件付き書式タブ
C. 複合レイアウト
D. 詳細タブ
E. 主題分野の指標

正解：A

解説：
The "Edit Column Formula" dialog box has a second,
very tiny tab called, "Bins." You can use this tab to have OBIEE
build a CASE statement for you in a formula (you can also create
a CASE statement yourself by using one of the functions that
appears under "Expressions" if you want). A CASE statement is a
lot like an IF-THEN-ELSE statement, except that it's a little easier
to read when you have multiple options. Basically, it puts values
in different buckets that you define.
Note:
Figure:

質問 # 41

A. Option A
B. Option C
C. Option D
D. Option B

正解：D

解説：

質問 # 42

A. Navteq
B. TeleAtlas
C. ESRI
D. Google

正解：A

質問 # 43

A. Option A
B. Option C
C. Option D
D. Option B

正解：D

質問 # 44

A. Option C
B. Option D
C. Option B
D. Option A

正解：D

解説：

質問 # 45
Oracle Business Intelligence 11gインストーラを実行する前に何をしなければなりませんか。

A. インストールコンポーネントを選択します - OBIEE、BIP、RTD
B. BIインストールメディアを入手
C. WLS管理サーバーをインストールします
D. システムがFusingミドルウェア、Oracle Business Intelligence、およびANDリポジトリ作成ユーティリティのインストール要件を満たしていることを確認します。
E. データベースに必要なOracle Business Intelligenceスキーマを作成します

正解：B、D、E

解説：
Before you can run Oracle Business Intelligence 11g Installer, you must first create required Oracle Business Intelligence schemas in an unhardened database. You use a tool called the Repository Creation Utility (RCU) to create these schemas with the appropriate permissions and data.

質問 # 46
派生指標は_________には使用されません。

A. シェアメジャーを計算する
B. 入力データ
C. 2つの論理列をまとめて追加
D. 2つのメジャー間の差異を計算
E. ランク次元値を計算します

正解：B

質問 # 47
管理ツールは、リポジトリファイルに対する開発者のインタフェースです。それはメタデータリポジトリファイルの開発と変更を可能にします。どちらが正しいですか？

A. リポジトリへの変更はオフラインモードでのみ実行できます。
B. セキュリティのあらゆる面がリポジトリファイルに保持されています。
C. 複数の開発者が同時に1つのリポジトリに取り組むことができます。結果は後でマージすることができます。
D. オンラインモードでrpd.fileを開くと、アプリケーションユーザーにとってパフォーマンスの問題が発生します。

正解：C

解説：
The Oracle BI repository development process adheres to the classic Software Configuration Management (SCM)process, which utilizes a three-way merge to manage concurrent development.
The merge process involves three repositories:
* The (Original|Received|Master|Parent) repository. The repository that you received before changed.
You must keep it preciously unchanged.
* The Modified repository. The repository that contains the customizations you made to the original repository.
* The Current repository. Generally, the repository that is in production and where some customisations could have been performed by other people.
In a multiuser environment (MUDE), Developers check out the file and make changes locally. Then, these changes are automatically reconciled and merged into the master repository.

質問 # 48

A. Option C
B. Option D
C. Option B
D. Option A

正解：D

解説：

質問 # 49
Oracleが推奨する2つの主要な設計ソリューションのうち、パフォーマンスのために使用するものは何ですか？

A. ダッシュボード内にビッグデータセットを返さないようにする
B. 複合クエリを使用する設計要求
C. データセットが大きい場合を除き、ガイドナビゲーションの使用を避けます
D. キャッシュを使用

正解：A、D

解説：
C: OBIEE Caching and Cache Seeding
Cache is a component that improves performance by transparently storing data such that future requests for the same criteria can be served much faster. Like other application cache is not virtual memory in OBIEE. In OBIEE cache will be stored as files on the Hard Disk of the OBIEE Server in the form of files. By Default caching is enabled in the OBIEE server configuration.
For time-consuming Dashboard Pages, we can use the concept of cache seeding in OBIEE, this can be configured as a scheduled job that will ensure that the data is cached and readily available as and when the user runs the dashboard.

質問 # 50
[地図データの管理]リンクを選択すると、次のうちどれを実行できますか。

A. 地図レイヤーをOBIEEメタデータで定義されている列に関連付けます
B. 新しい地図画層を作成する
C. 読み込んだ地図のズームレベルを設定します
D. 地図上で使用するための画像のインポート

正解：A、C、D

解説：
The Oracle BI Presentation Services Administration page provides the Manage Map Data link. This link displays the Manage Map Data page, where you can manage the logical and display versions of the data from various physical data sources. This defines the layers that content designers use when creating map views.
The data that is available for managing maps and data is stored in Oracle Database as part of MapViewer.
Using this page, you provide:
* (A) Logical names to prevent any existing BI column mappings and map analyses from breaking because of changes to the physical data or to the data source.
* Display names so that the geographic data is meaningful to end users.
Note: Administering Maps Using Administration Pages
For (C) -layers, see 3-7 below.
For (D) -import images, see 11-12 below.
To administer maps using Administration pages:
* Sign in to Oracle Business Intelligence.
* In the global header, click Administration.
* Click the Manage Map Data link to display the Manage Map Data page.
* Click the Layers tab.
* Click the Import Layers button to display the Import Layers dialog.
* In the dialog, select the connection and the layers that are needed for zooming and drilling. (This tab is not prepopulated by other selections on the Administration pages. You can use any layers or images with any map.) Click OK when you have finished selecting layers that are appropriate for the subject area with which you are working.
* Back on the Layers tab, select a layer, then click the Edit Layer button to display the Edit Layer dialog in which you associate layers with attribute columns so that you can display BI data in the map view.
Click OK when you have finished editing the layer.
You use this tab to associate layers with BI data. If you use the City column in multiple subject areas, then you must associate it with a layer for each subject area.
* Click the Background Maps tab, then click the Import Background Maps button to display the Import Background Maps dialog.
* In the dialog, select the connection and the main maps to use.
The connection that you select for the main map can be different from the connection for the layers or images.
Click OK when you have finished selecting main maps.
* Back on the Background Maps tab, select a map, then click the Edit Background Map button to display the Edit Background Map dialog in which you name the map and specify the order of layers and their zoom levels.
Click OK when you have finished editing the map.
* Optionally, click the Images tab, then click the Import Images button to display the Import Images dialog. You can import images if you plan to use them as a format on maps.
* In the dialog, select the connection and the images to use.
Click OK when you have finished selecting images.
* Click Back when you have finished working with the Administration page. Your changes are saved automatically.

質問 # 51
Enterprise Managerを通じてどの構成を変更できますか？

A. ユーザーログインを管理します
B. デフォルトのBI Serverリポジトリ
C. Excelにダウンロードする最小行数
D. BIサービスの開始と停止

正解：B

解説：
The Repository can be configured within the Enterprise Manager. See Note 1 below.
Note 1: Once you've locked the Oracle BI Domain, you would then use the same screen back in Enterprise Manager to browse and select the RPD file, and then enter the password, twice.

Once you've entered these details you would then press the Apply button, to save the changes. At this point, the RPD gets a sequence number after it, and it's displayed as the current default online repository for the Oracle BI Domain.
Note 2: An OBIEE 11g system (or "Oracle BI Domain") is generally managed through a combination of Oracle Enterprise Manager Fusion Middleware Control, part of the Enterprise Manager "family", or through WebLogic Server Scripting Tool (WLST) scripts. Each Fusion Middleware Control instance as shipped with OBIEE 11g controls a single Oracle BI Domain (DEV, or PROD for example), and is installed along with WebLogic Server Admin Console in the WebLogic Admin Server, one of the two JVMs (the other being the managed server) that gets installed by default with OBIEE 11g. The screenshot below shows Fusion Middleware Control showing the status of the BI Server, Presentation Server and other system components within the installation.

質問 # 52
物理層の物理テーブルに使用できる3種類のテーブルはどれですか。

A. Physical Table
B. Select
C. Table
D. View
E. Stored Proc

正解：A、B、E

解説：
Pull the table and column definition into the physical layer
Use the OBIEE "import metadata" wizard to pull the table and column definition into the physical layer. The wizard is used so that all of the column definitions do not need to be manually added into the physical layer.
Figure:

Note: The physical layer is the layer of the Logical Business Model where you define the physical data model of your data source. It contains information about the physical data sources.