Valid 1Z0-531 Dumps shared by ExamDiscuss.com for Helping Passing 1Z0-531 Exam! ExamDiscuss.com now offer the newest 1Z0-531 exam dumps, the ExamDiscuss.com 1Z0-531 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1Z0-531 dumps with Test Engine here:
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
Correct Answer: A,C
Explanation/Reference: 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.