Oracle 1Z0-531 Online Practice Questions and Exam Preparation

Oracle 1Z0-531 Online Questions & Answers

• Question 61:

  Given the following information, what is the block size?

  

  A. 400 KB
  B. 400 Bytes
  C. 1056 KB
  D. 50 Bytes
  E. 1056 Bytes
  F. 50 KB
  G. 70 KB
  B. 400 Bytes

  ---

  We need to multiple the stored (not the total) members of the dense dimensions (here Accounts: 10, Time:5) with 8 to calculate the block size. Block size: 10 x 5 x 8 = 400

  Note: Data block size is determined by the amount of data in particular combination of dense dimensions. For ex: when you change the dense or sparse configuration of one or more dimensions in the database, the data block size changes. Data block size is 8n bytes, where n is the number of cells that exist (ie. Stored, not total) for that combination of dense dimensions.Note: Optimal range is 8 to 100 kb

• Question 62:

  You are trying to create a multidimensional model for Essbase and learn that your user wants to track commission for his sales persons, in addition to tracking sale by regions. When designing a multidimensional model, which two elements will serve as facts (measures)?

  A. Sales person
  B. Commission
  C. New York
  D. Sales
  E. Year to Date
  D. Sales
  E. Year to Date

  ---

  Dimensions, hierarchies, members, levels, and attributes form the structure of a cube. The data comes from measures.

  Measures represent business data that is important for analysis, such as sales and cost of goods sold. Measure values are the data that fills the intersections in a cube. To be meaningful, a value must be defined in terms of all dimensions in

  the cube.

• Question 63:

  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?

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

  ---

  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.

• Question 64:

  You need to calculate average units sold by the customer dimension within an ASO database. The member formula should calculate correctly regardless of level within the customer dimension. Identify the correct syntax for the member formula.

  A. @AVG (SKIPBOTH, "Units_Sold");
  B. Avg(Customer.CurrentMember.Children, [Units_Sold])
  C. Avg([Customer].Children, [Units_Sold]);
  D. Avg(Customer.CurrentMember.Children, [Units_Sold]);
  E. Avg(Customer.Children, [Units.Sold]);
  B. Avg(Customer.CurrentMember.Children, [Units_Sold])

  ---

  A custom rollup technique, custom rollup formulas, lets the cube builder define an MDX formula for each dimension level. Analysis Services uses this formula to determine the value of the dimension level's members. For example, you could use an AVERAGE function rather than a summation to determine all members in one dimension level. If you use the AVERAGE function, the MDX formula for a dimension called Customers would be Avg ( Customers.CurrentMember.Children ). Note: The MultiDimensional eXpressions (MDX) language provides a specialized syntax for querying and manipulating the multidimensional data stored in OLAP cubes. While it is possible to translate some of these into traditional SQL, it would frequently require the synthesis of clumsy SQL expressions even for very simple MDX expressions. MDX has been embraced by a wide majority of OLAP vendors and has become the standard for OLAP systems.

• Question 65:

  Which files will get restructured in a full BSO restructure?

  A. Data file only
  B. Index file only
  C. Data and index file
  D. No file
  C. Data and index file

  ---

  There are two types of restructures of Essbase BSO databases.

  Full/dense restructure recreates the index file (Ess*.IND) and the data file (Ess*.PAG).

  A sparse restructure recreates the index file (Ess*.IND) only.

• Question 66:

  Identify the two true statements about data loads to ASO and BSO databases.

  A. Data can only be loaded to level 0 members in ASO database where BSO allows data loads to upper level members.
  B. Cells at all levels can be loaded (except Dynamic Calc members) for both ASO and BSO.
  C. After an ASO data load, no further calculation is required.
  D. Concurrent loads are supported for both ASO and BSO
  A. Data can only be loaded to level 0 members in ASO database where BSO allows data loads to upper level members.
  C. After an ASO data load, no further calculation is required.

  ---

  A: ASO targets can be partitioned only along level 0

• Question 67:

  During a multidimensional analysis getting data from a supplemental data source is an example of________.

  A. Drill across
  B. Drill Through
  C. Trending
  D. Pivoting
  A. Drill across

• Question 68:

  You are performing incremental loads to an ASO database during the day, providing near real time data to the SaleDtl ASO database. Before the incremental load, you need to clear a specific set of data in the fastest amount of time possible.

  What is the best solution?

  A. Partial clears are supported for ASO
  B. Perform a logical clear, using MDX to specify the region to be cleared
  C. Perform a physical clear, using MDX to specify the region to be cleared
  D. Run a calc script containing the CLEARDATA command and a set of FIX statements that isolate the desired data set
  E. Run a calc script containing the CLEARBLOCK command and a set of FIX statements that isolate the desired data set
  A. Partial clears are supported for ASO
  B. Perform a logical clear, using MDX to specify the region to be cleared

  ---

  Within ASO partial clear are supported. Logical clear is faster than physical clear.

• Question 69:

  Which two valid field headers could be assigned to the 5th column in this data file?

  Duplicate Member Names is not enabled.

  

  A. Alias
  B. Attribute
  C. Generation-4
  D. UDA
  E. Property
  A. Alias
  C. Generation-4

  ---

  A: Regarding Table Aliases: You can assign one or more alternate names, or aliases, to Planning Account, Currency, Entity, Scenario, Period, Version, Year, and user-defined dimension members. Aliases provide the ability to create unique sets of identifiers when working with dimensions and members. Planning allows up to 10 aliases per dimension member, including the default alias.

  C: The terms "generation" and "level" denote the distance from either the "root" or the "leaves" of the dimension. Thus, you can determine the location of any member within a database tree. You can also specify relationships between groups of related members. Generations specify the distance of members from the root of their dimension. All members in a database that are the same number of branches from their root have the same generation number. The dimension is generation 1, its children are generation 2, and so on. Levels measure the number of branches between a member and the lowest member below it, that is, the number of branches between a member and the "leaf" of its hierarchy within the database structure. Level 0 specifies the bottom-most members of a dimension and thus provides ready access to the raw data stored in a database. Leaf members are level 0, then their parents are level 1, and so on up the hierarchy. You might note that when all sibling members have the same generation number but not necessarily the same level number. For example, the members in this hierarchy: Dim1 m11 m111 m112 m12 m121 m122 m13

  have the following generation and level numbers: Dim1 Gen 1, Level 2 m11 Gen 2, Level 1 m111 Gen 3, Level 0 m112 Gen 3, Level 0 m12 Gen 2, Level 1 m121 Gen 3, Level 0 m122 Gen 3, Level 0 m13 Gen 2, Level 0

  Incorrect answer:

  B: Attributes let you add another level of granularity to your data. You create attributes for a dimension when you want to group its members according to the same criterion. You then create attribute values for each attribute, which are assigned to dimension members.

  D: You can use user-defined attributes (UDAs)--words or phrases describing a particular characteristic of members--within calc scripts, member formulas, and reports so that they return lists of members associated with the specified UDA. For example, say you have a Product dimension with various product members. s. You could create a UDA called New Products and base certain calculations only on new products.