1Z0-531 | What 100% Correct 1Z0-531 exam question Is?
Q31. 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
A. Export the data for actual, current year, sales into a text file called data.txt
B. Export the data for actual, current year into a text file called data.txt
C. Export data blocks in a compressed encrypted format
D. Create a text file that can be imported using the DATAIMPORTBIN calc command in another database that has different dimensionality
Answer: AC
Q32. Within which two directories can you set the location and file size in ASO?
A. Default
B. Metadata
C. Log
D. Temp
E. Bin
F. Data
Answer: AD
Q33. Identify the two true statements about compression for block storage databases.
A. Index value pair compression works well for consecutive zero values or repeating values within a database.
B. RLE compression works well for consecutive zero values or repeating values within a database.
C. Bitmap compression is the default compression method.
D. The Accounts dimension is tagged the compression dimension by default.
E. Do not set compression for a dimension that has many members.
Answer: BC
Q34. Which three statements are true about multiple hierarchies in ASO?
A. First hierarchy must be stored.
B. Multiple hierarchies must be enabled by dimension.
C. First hierarchy must be dynamic.
D. All alternate hierarchies must be dynamic.
E. Alternate hierarchies may be either dynamic or stored.
Answer: ABE
Q35. In an aggregate storage database, which two are the correct member solve orders for Profit per Unit and Variance given the following:
Profit per Unit - Accounts dimension
Variance - Scenario dimension
When we say "correct," we mean that both dynamic totals will calculate and display correctly.
A. Accounts 0, Profit Per Unit 0, Scenario 0, Variance 1
B. Accounts 0, Profit Per Unit 1, Scenario 0, Variance 0
C. Accounts 2, Profit Per Unit 0, Scenario 0, Variance 1
D. Accounts 2, Profit Per Unit 1, Scenario 1, Variance 2
Answer: CD
Q36. You have the following customer dimensions;
You need to create a % of total (by region) calculation by customer in you aggregate storage database for Net_Revenue. Select the best syntax for member formula so that the % Total calculation works at all levels of customer dimension.
A. (Net_Revenue]) / (Parent. [Net_Revenue])
B. (customer.CurrentMember, [Net_Revenue]) / (customer.CurrentMember.Parent, [Net_Revenue]);
C. (customer.CurrentMember, [Net_Revenue]) / (customer.CurrentMember,Parent, [Net_Revenue])
D. (customer.CurrentMember, [Net_Revenue]) / (customer. [Net_Revenue]);
E. (customer.CurrentMember, [Net_Revenue]) / (customer. [Net_Revenue], Products, YearTotal);
Answer: B
Q37. In Smart View, when zooming in and out of dimensions in Essbase, if you need to go back to a previous step, you can:
A. Undo one time
B. Flashback one time
C. Undo up to specified number of times
D. Use Microsoft Excel Undo
Answer: B
Q38. Given the following, what is the block size In bytes?
A. Block size = 40 * 17 * 2
B. Block size = 40 *17 * 2 * 8
C. Block size = 50 * 17 * 5
D. Block size = 50* 17*5 * 8
Answer: B
Q39. How are the ASO data files managed?
A. Page files
B. Index files
C. Table spaces
D. Bin files
Answer: C
Q40. The following objects are considered metadata in Essbase studio except for which two?
A. Dimensional element
B. Hierarchy
C. Cube Schema
D. Metaoutline
E. Essbase Model
F. Metamodel
Answer: EF