Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Hot Area / Sentence Completion
Select the appropriate option to complete the statement. Click Check Answer below to see the marked solution.
Hotspot Solution:
GenerateSeries uses 3 arguments, lower value, upper value, step (from -100 to 100 increment by 1) Generate(table1, table2) creates a new table with cartesian products (for each row in table 2 add all rows from table1) If table1 has 2 records and table 2 has 3 records, new table will have 2X3=6records BY RECORD ORDER OF TABLE 1 t1 t2 1 1 2 1 1 2 2 2 1 3 2 3 GenerateAll(table1, table2) creates a new table with cartesian products (for each row in table 1 add all rows from table2) If table1 has 2 records and table 2 has 3 records, new table will have 2X3=6records BY RECORD ORDER OF TABLE 2 t1 t2 1 1 1 2 1 3 2 1 2 2 2 3 Generate and GenerateAll use the same principle as multidimension arrays
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
* Answer: - Function: GENERATESERIES - Parameters: (-100, 100, 1) * Explanation: GENERATESERIES is designed to create a single-column table of numbers. Syntax: - StartValue = -100 - EndValue = 100 - IncrementValue = 1 (so it includes every integer in between). * Why not the others: - GENERATE / GENERATEALL → These are table-combination functions, not for number sequences. - Parameter sets like (100, 1, 200) or (-1, -100, 100) don’t match the requirement.
GENERATESERIES is the only function in the list accepting 3 parameters. GENERATE (<Table1>, <Table2 Expression>] would crete a virtual table pairing rows of 2 tables where the second table depends on the current row of first table GENERATEALL(<table1>, <table2 expression>) similar to GENERATE but it will include rows even when first table is empty GENERATESERIES(<start>, <end>, [<step>] creates a single-column table of values within a numeric range
The answer is correct!