Week 1 Pre Test DSC 570
v Correct
You are creating a Power Bl Desktop report that has several bar charts and a date slicer. You need to create a slide show of the visuals that can be viewed from the Power Bl
Service. Each slide must display the visuals filtered by a date slicer for various years. After creating a slide show, the time intelligence functions failed to perform accurately,
resulting in visuals with incorrect data. Some requirements to use time intelligence functions were not followed. Which of the following are those requirements?
Each correct answer represents a complete solution. Choose all that apply.
v A The date column must be complete.
B [0 The date column must contain unique values and BLANKs.
v C The date table must have a date column.
v D The date column must span full years.
Explanation
Answers A, C, and D are correct.
The following requirements are needed to use time intelligence functions:
# The date table must have a date column.
# The date column must be complete.
# The date column must span full years.
# The date table must be marked as a date table.
# The date column must contain unique values and cannot contain BLANKS,
Lesson
Modeling Data with Calculations
Topic B: Create Calculated Measures and Conditional Columns
Course Learning
Outcomes
2. Apply predictive and prescriptive modeling to guide business planning and measure operational performance against established benchmarks
, v Correct
Wilson is a database manager. He is working on a Power BI report. He wants to combine the queries by adding rows from the second query after the first. Which of the following
options will he use to complete the task?
Reduce Rows
¢ O spitcotumn
D O Mege
Explanation
Answer Als correct.
Wilson will use the Append option to complete the task. This option can be used to combine the queries by adding rows from the second query after the firs
Columns from each query will be preserved. Any duplicate data will need to be manually removed.
Answer Ci incorrect, The Spiit Column option splits column by delimiter or character
Answer D s incorrect. The Merge option requires a matching field between the queries, similar to a key feld in a relationship.
Answer B i incorrect, The Reduce Rows option is used to select rows of data to keep or remove.
Analyzing Data with Self-Service BI, Connectingto Data Sources, and Managing Data
Topic F: Clean, Transform, and Load Data with the Query Editor
1. Use complex event processing (CEP) to extract meaningful business data from event streams in real time:
, Correct
Which of the following are the examples of the online services connection type?
Each correct answer represents a complete solution. Choose allthat apply.
Smartsheet
Webtrends Analytics
Dynamics 365 Business Central
D O ION
Explanation
Answers A, 8, and C are correct.
Here are the examples of the online services connection type:
» Smartsheet
» Webtrends Analytics
» Dynamics 365 Business Central
Answer D s incorrect. JSON is the example of the file connection type.
Analyzing Data with Self-Service BI, Connectingto Data Sources, and Managing Data
Topic C: Create Data Connections
, 2njeA $53UNQ PPe 163 SUCISI3P YL 03 P3SN 3q UED 18U EIEP SZUBWING '€
spaoquseq pue suioday aseys 3 doL
spieoquseq pue s1odsy
54016 SE YosOII pue ‘i1 vornquisip ‘sdnoi6
faunoas Buisn Aq 1u21u03 18 jamg 12y) 3Beuetw o) SUOEZEGIO 21Geud o) PaUBISID 51 1ew) 32edSHIOM PRIEYS € O} I2}2) 2DEASYIOM MBU ¥/ DRLIODUI S| 3 JONSUY
“adedsyiom ajkis-Mau € o} 3l ays Buiysiand uauy pue doVSaQ 8 JaMOd Ui 3 Xigd © 6uneai Aq Siaseiep Inok 0} 553038 1UEI6 Ue SI3SN “PRLOAI 1 § JMSUY
“PauSInd Uaaq Sey U 32U 1aseleD ay) 35N Pue 55208 e 32edHOM34 JO J3GUIL € 51 O 195N AUe YNEJaP Ag BV 18 JBMOG AU LI L0 SBI0)
241 01 51950 Bunuisse uau pue opisaq 18 J9MOg UM WOL [9pOL E1EP € 0} SaJn Pue 52101 Aunas Buippe AQ (ST) Aynoas onal-moJ Juawaidiu ue> siasn
181103 316 Q pue v s1aMSUY.
uoneue|dx3
‘dopisaq I 72O UM WO [POUI @1P @ O} SIIN U 53[0 KUnds PRY
sdnosbGog yosoIyy Pue ‘Sl uoanquIsIp ‘sdnoib Qunx3s3sn | [ D
dopsaq g ;aMog Ul XIgde A (1 8
2210135 |5 J2MOg U3 UIIM WO SI(0J 343 03 5135 UBISSY
fidde 1o 10 350043 “uoun|oS 34 Jo Hed @ Sjussaidas Jamsue P03 Ye3
215 31 usidwios>e o} pausiopiad 3q pinoys sdais Bumalioy
43 10 PIUM ‘9POW E18P INOK 03 AN23 [3A31-M0J UBWSIALLL O JUBM NOK “EIEP AISUSS UIEIOD Sp0d1 3u ‘SLIOGa1 O BUILIZIUO3 [3POU |§ JaMog 24 USWBIdWI Nos
pauo) £
v Correct
You are creating a Power Bl Desktop report that has several bar charts and a date slicer. You need to create a slide show of the visuals that can be viewed from the Power Bl
Service. Each slide must display the visuals filtered by a date slicer for various years. After creating a slide show, the time intelligence functions failed to perform accurately,
resulting in visuals with incorrect data. Some requirements to use time intelligence functions were not followed. Which of the following are those requirements?
Each correct answer represents a complete solution. Choose all that apply.
v A The date column must be complete.
B [0 The date column must contain unique values and BLANKs.
v C The date table must have a date column.
v D The date column must span full years.
Explanation
Answers A, C, and D are correct.
The following requirements are needed to use time intelligence functions:
# The date table must have a date column.
# The date column must be complete.
# The date column must span full years.
# The date table must be marked as a date table.
# The date column must contain unique values and cannot contain BLANKS,
Lesson
Modeling Data with Calculations
Topic B: Create Calculated Measures and Conditional Columns
Course Learning
Outcomes
2. Apply predictive and prescriptive modeling to guide business planning and measure operational performance against established benchmarks
, v Correct
Wilson is a database manager. He is working on a Power BI report. He wants to combine the queries by adding rows from the second query after the first. Which of the following
options will he use to complete the task?
Reduce Rows
¢ O spitcotumn
D O Mege
Explanation
Answer Als correct.
Wilson will use the Append option to complete the task. This option can be used to combine the queries by adding rows from the second query after the firs
Columns from each query will be preserved. Any duplicate data will need to be manually removed.
Answer Ci incorrect, The Spiit Column option splits column by delimiter or character
Answer D s incorrect. The Merge option requires a matching field between the queries, similar to a key feld in a relationship.
Answer B i incorrect, The Reduce Rows option is used to select rows of data to keep or remove.
Analyzing Data with Self-Service BI, Connectingto Data Sources, and Managing Data
Topic F: Clean, Transform, and Load Data with the Query Editor
1. Use complex event processing (CEP) to extract meaningful business data from event streams in real time:
, Correct
Which of the following are the examples of the online services connection type?
Each correct answer represents a complete solution. Choose allthat apply.
Smartsheet
Webtrends Analytics
Dynamics 365 Business Central
D O ION
Explanation
Answers A, 8, and C are correct.
Here are the examples of the online services connection type:
» Smartsheet
» Webtrends Analytics
» Dynamics 365 Business Central
Answer D s incorrect. JSON is the example of the file connection type.
Analyzing Data with Self-Service BI, Connectingto Data Sources, and Managing Data
Topic C: Create Data Connections
, 2njeA $53UNQ PPe 163 SUCISI3P YL 03 P3SN 3q UED 18U EIEP SZUBWING '€
spaoquseq pue suioday aseys 3 doL
spieoquseq pue s1odsy
54016 SE YosOII pue ‘i1 vornquisip ‘sdnoi6
faunoas Buisn Aq 1u21u03 18 jamg 12y) 3Beuetw o) SUOEZEGIO 21Geud o) PaUBISID 51 1ew) 32edSHIOM PRIEYS € O} I2}2) 2DEASYIOM MBU ¥/ DRLIODUI S| 3 JONSUY
“adedsyiom ajkis-Mau € o} 3l ays Buiysiand uauy pue doVSaQ 8 JaMOd Ui 3 Xigd © 6uneai Aq Siaseiep Inok 0} 553038 1UEI6 Ue SI3SN “PRLOAI 1 § JMSUY
“PauSInd Uaaq Sey U 32U 1aseleD ay) 35N Pue 55208 e 32edHOM34 JO J3GUIL € 51 O 195N AUe YNEJaP Ag BV 18 JBMOG AU LI L0 SBI0)
241 01 51950 Bunuisse uau pue opisaq 18 J9MOg UM WOL [9pOL E1EP € 0} SaJn Pue 52101 Aunas Buippe AQ (ST) Aynoas onal-moJ Juawaidiu ue> siasn
181103 316 Q pue v s1aMSUY.
uoneue|dx3
‘dopisaq I 72O UM WO [POUI @1P @ O} SIIN U 53[0 KUnds PRY
sdnosbGog yosoIyy Pue ‘Sl uoanquIsIp ‘sdnoib Qunx3s3sn | [ D
dopsaq g ;aMog Ul XIgde A (1 8
2210135 |5 J2MOg U3 UIIM WO SI(0J 343 03 5135 UBISSY
fidde 1o 10 350043 “uoun|oS 34 Jo Hed @ Sjussaidas Jamsue P03 Ye3
215 31 usidwios>e o} pausiopiad 3q pinoys sdais Bumalioy
43 10 PIUM ‘9POW E18P INOK 03 AN23 [3A31-M0J UBWSIALLL O JUBM NOK “EIEP AISUSS UIEIOD Sp0d1 3u ‘SLIOGa1 O BUILIZIUO3 [3POU |§ JaMog 24 USWBIdWI Nos
pauo) £
