Online Access Free 1Z0-531 Exam Questions

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].Children, [Units_Sold]);
• C.Avg(Customer.CurrentMember.Children, [Units_Sold])
• D.Avg(Customer.Children, [Units.Sold]);
• E.Avg(Customer.CurrentMember.Children, [Units_Sold]);

Identify the four true statements about attribute dimensions

• A.Even though ASO databases allow many dimensions, attribute dimensions are still available and used in aggregate storage option databases
• B.Attributes are assigned to dense dimensions
• C.Attributes allow cross tab reports with other dims
• D.Attributes are stored
• E.Security can be assigned by attribute dimension
• F.Attributes are dynamically calculated

Which two options would provide a better design for the following accounts and metrics?

• A.If there are a small number of accounts that require FTE and Expense dollars, split Accounts and Metrics into 2 dimensions
• B.If block size is large, then keep Accounts and Metrics as one dimension with a dense dimension
• C.If there are a large number of accounts that require FTE and Expense dollars, split Accounts and Metrics into 2 dimensions
• D.If reporting dictates FTE and dollars in the columns and accounts in the rows, split Accounts and Metrics into 2 dimensions

You are creating a MaxL script to log into the database, update a dimension, load data, and run a calculation. Identify the two true statements about creating this MaxL script.

• A.Variables for objects like server names, application names and database names can be used in a MaxL script to help with maintenance
• B.The password must be hardcoded into the script when logging in.
• C.A separate MaxL script is required for each step
• D.IFERROR can be used in MaxL to handle errors after each statement, when triggered will skip to a subsequent statement

Identify the two true statements about compression for block storage databases.

• A.Do not set compression for a dimension that has many members.
• B.RLE compression works well for consecutive zero values or repeating values within a database.
• C.Bitmap compression is the default compression method.
• D.Index value pair compression works well for consecutive zero values or repeating values within a database.
• E.The Accounts dimension is tagged the compression dimension by default.