Download Oracle.1z0-531.SelfTestEngine.2018-10-25.42q.tqb

Vendor:	Oracle
Exam Code:	1z0-531
Exam Name:	Oracle Essbase 11 Essentials
Date:	Oct 25, 2018
File Size:	1 MB

Download Exam

Demo Questions

You have the following analysis requirement. Products roll up to Product Family which rolls up to Product Category. You also need to group Products by Product

Manager. Product Managers may manage one or more Products across product families. You do not need to create reports with Product Manager by Product

Family. You need to secure products by Product Manager for planning submissions.

You consider Shared members as a solution because of which two options?

Shared members provide cross tab reporting (Product Manager in the rows and Product Family across the column)
Shared members provide additional categorization but results in a smaller database then if you were to add Product Manager as a separate dimension
You can assign security to shared members
Shared members can be assigned to sparse members only

Correct answer: BC

Explanation:

The data values associated with a shared member come from another member with the same name. The shared member stores a pointer to data contained in the other member, and the data is stored only once. To define a member as shared, an actual nonshared member of the same name must exist. Using shared members lets you use members repeatedly throughout a dimension. Essbase stores the data value only once, but it displays in multiple locations. Storing the data value only once saves space and improves processing efficiency. (B) Shared members must be in the same dimension. Data can be shared by multiple members. Incorrect answers:A: Attributes, not shared members, offers cross-tab, reportingD. Shared member can be assigned to both dense and sparse members.

Using shared members lets you use members repeatedly throughout a dimension. Essbase stores the data value only once, but it displays in multiple locations.

Storing the data value only once saves space and improves processing efficiency. (B)

Shared members must be in the same dimension. Data can be shared by multiple members.

Incorrect answers:

A: Attributes, not shared members, offers cross-tab, reporting

D. Shared member can be assigned to both dense and sparse members.

Identify four disadvantages / considerations when using a transparent partition.

Old data
Slow retrievals
Slow calculations if referencing dynamic calc members in the source
Outline sync complexities
Increased network load
Downtime required to sync data

Correct answer: BCDE

Explanation:

Disadvantages of Transparent Partitions * Outline synchronization is required (D) If you make changes to one outline, the two outlines are no longer synchronized. Although Essbase makes whatever changes it can to replicated and transparent partitions when the outlines are not synchronized, Essbase may not be able to make the data in the data source available in the data target. Essbase tracks changes that you make to block storage outlines and provides tools to keep your block storage outlines synchronized. Note:Essbase does not enable automatic synchronization of aggregate storage outlines. You must manually make the same changes to the source and target outlines. * Transparent partitions increase network activity, because Essbase transfers the data at the data source across the network to the data target. Increased network activity results in slower retrieval times for users. (E) * Because more users are accessing the data source, retrieval time may be slower. (B) * If the data source fails, users at both the data source and the data target are affected. Therefore, the network and data source must be available whenever users at the data source or data target need them. * (C) When you perform a calculation on a transparent partition, Essbase performs the calculation using the current values of the local data and transparent dependents. Essbase does not recalculate the values of transparent dependents, because the outlines for the data source and the data target may be so different that such a calculation is inaccurate. To calculate all partitions, issue a CALC ALL command for each individual partition, and then perform a CALC ALL command at the top level using the new values for each partition. * Formulas assigned to members in the data source may produce calculated results that are inconsistent with formulas or consolidations defined in the data target, and vice versa. Note: Advantages of Transparent PartitionsTransparent partitions can solve many database problems, but transparent partitions are not always the ideal partition type. * You need less disk space, because you are storing the data in one database. * The data accessed from the data target is always the latest version. (not A) * When the user updates the data at the data source, Essbase makes those changes at the data target. * Individual databases are smaller, so they can be calculated more quickly. * The distribution of the data is invisible to the end user and the end user’s tools. * You can load the data from either the data source or data target. * You can enable write-back functionality for aggregate storage databases by creating a transparent partition between an aggregate storage database as the source and a block storage database as the target.

Disadvantages of Transparent Partitions

* Outline synchronization is required (D)

If you make changes to one outline, the two outlines are no longer synchronized. Although Essbase makes whatever changes it can to replicated and transparent partitions when the outlines are not synchronized, Essbase may not be able to make the data in the data source available in the data target.

Essbase tracks changes that you make to block storage outlines and provides tools to keep your block storage outlines synchronized.

Note:

Essbase does not enable automatic synchronization of aggregate storage outlines. You must manually make the same changes to the source and target outlines.

* Transparent partitions increase network activity, because Essbase transfers the data at the data source across the network to the data target. Increased network activity results in slower retrieval times for users. (E)

* Because more users are accessing the data source, retrieval time may be slower. (B)

* If the data source fails, users at both the data source and the data target are affected. Therefore, the network and data source must be available whenever users at the data source or data target need them.

* (C) When you perform a calculation on a transparent partition, Essbase performs the calculation using the current values of the local data and transparent dependents. Essbase does not recalculate the values of transparent dependents, because the outlines for the data source and the data target may be so different that such a calculation is inaccurate. To calculate all partitions, issue a CALC ALL command for each individual partition, and then perform a CALC ALL command at the top level using the new values for each partition.

* Formulas assigned to members in the data source may produce calculated results that are inconsistent with formulas or consolidations defined in the data target, and vice versa.

Note: Advantages of Transparent Partitions

Transparent partitions can solve many database problems, but transparent partitions are not always the ideal partition type.

* You need less disk space, because you are storing the data in one database.

* The data accessed from the data target is always the latest version. (not A)

* When the user updates the data at the data source, Essbase makes those changes at the data target.

* Individual databases are smaller, so they can be calculated more quickly.

* The distribution of the data is invisible to the end user and the end user’s tools.

* You can load the data from either the data source or data target.

* You can enable write-back functionality for aggregate storage databases by creating a transparent partition between an aggregate storage database as the source and a block storage database as the target.

Assuming Sales and Year are sparse and Actual is dense, what two actions will the following calc script perform?

FIX (Actual, @CY, Sales)

DATAEXPORT "BINFILE" "data.txt";

ENDFIX

Export the data for actual, current year, sales into a text file called data.txt
Export the data for actual, current year into a text file called data.txt
Export data blocks in a compressed encrypted format
Create a text file that can be imported using the DATAIMPORTBIN calc command in another database that has different dimensionality

Correct answer: AC

Explanation:

The FIX…ENDFIX command block restricts database calculations to a subset of the database. All commands nested between the FIX and ENDFIX statements are restricted to the specified database subset. Syntax:FIX (fixMbrs) COMMANDS ; ENDFIX fixMbrs: A member name or list of members from any number of database dimensions.DATAEXPORT writes data to a text file, binary file, or as direct input to a relational file using ODBC. The data blocks will be saved in a compressed encrypted format to a text file. For a binary output file:DATAEXPORT "Binfile" "fileName" Incorrect answers:The Sales dimension is included as well. Use the DATAIMPORTBIN command to import a previously exported binary export file. However, the data cannot be imported into another database with a different dimensionality.

The FIX…ENDFIX command block restricts database calculations to a subset of the database. All commands nested between the FIX and ENDFIX statements are restricted to the specified database subset.

Syntax:

FIX (fixMbrs)

COMMANDS ;

ENDFIX

fixMbrs: A member name or list of members from any number of database dimensions.

DATAEXPORT writes data to a text file, binary file, or as direct input to a relational file using ODBC. The data blocks will be saved in a compressed encrypted format to a text file.

For a binary output file:

DATAEXPORT "Binfile" "fileName"

Incorrect answers: