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 Pawer 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 [ 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
Qutcomes
2. Apply predictive and prescriptive modeling to guide business planning and measure operational performance against established benchmarks
, v Correct
Wison is a database manager. He is working on a Power Bl report. He wantsto combine the queries by adding rows from the second query after the first. Which of the following
options will e use to complete the task?
B O ReduceRows
C O SplitColumn
D O Merge
Explanation
Answer As 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 first.
Columns from each query will be preserved. Any duplicate data will need to be manually removed.
Answer C is incorrect, The Spiit Column option splits column by delimiter or character.
Answer D is incorrect. The Merge option requires a matching field between the queries, similarto a key field in a relationship.
Answer 8 s 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 2pply.
¢ (A st
Webtrends Analytics
D O IsON
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 Dis incorrect. JSON is the example of the file connection type.
Analyzing Data with Self-Service BI, Connecting to Data Sources, and Managing Data
Topic C: Create Data Connections
, nje $53USNQ Ppe 12U SUOISI3P YU O P3SN 3q UEd 18U EIep SZUBUANG '€
spioquseq pue suoday aseys 13 2oL
spizoquseq pue sHoday
5dn016 G9g YOSOIIN pu ‘isy uonnguIsIp ‘sdnoib
fauinyss Buisn Aq 121000 g 1amog 13ys Beue 0} suoezIueBiO SIGeus 0} PAUBISaP S 12y} 32edSHIOM P3IEYS © O SI3ja1 3IRASHIOM MAU Y "PRLIOII S| 3 JSMSUY
“2dedspiom ajis-mau e of ajy ot Bunysiand uauy pue doptsaq I J2mod Ut 3l XIad © Bunea.n Aq syeseaep nok o) sseade el Ued s5esN PRLODU! 51§ JANSUY
“PRUSIGNd U35q Sey Y 20U 19SE1EP 34} 35N PuE 553008 UED 3DESHIOM U J0 ISGUIBU € 51 Ol 135N Aue YNEJ3D A BBS 18 J3MOd U UK WOl S3j0s
21 0 1351 GuuBisse s pue ‘doBSA |3 JAMOG LI WO [3pOu 1EP € 0 S3jns pu S3j01 Aanoas Buippe Aq (STH) ANDas [213}-wo1 uawaIdul ued siasn
3102 34 Q pue ¥ SIBNSUY
uoneue|dx
“dopfsaq (g J2MOg UILM WO [3POL B3eP & O} S3jn PUE S3(02 N33 PPY.
sdnoib G9¢ YosOLI pue ‘Sist vognquasip sdnosb fumssasn 0| D
doppsaq i femog Ui A XigA R AL (] 8
“23(A13§ |§ 22O 343 UILAIM WO SR(0J U 03 SI3SN UBISSY.
fidde 1oy 12 35003 "uoRn|0S 3y} §0 ed @ sjussaIdas JaMSUR PO Y23
2159 34 usiduios>e oy pauioyiad 2q pinous sdts Bumolfoy
20310 U1 13O E12p im0k 03 UN3as [343}-Mo1 JuWaIAuL 3 e RO "EIep AASUSS UIEIUO S0l 3U) SY0GaI O BUIITIUO (3pOLI |3 5aMOg 24 uLsaIdu! RO
o) A
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 Pawer 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 [ 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
Qutcomes
2. Apply predictive and prescriptive modeling to guide business planning and measure operational performance against established benchmarks
, v Correct
Wison is a database manager. He is working on a Power Bl report. He wantsto combine the queries by adding rows from the second query after the first. Which of the following
options will e use to complete the task?
B O ReduceRows
C O SplitColumn
D O Merge
Explanation
Answer As 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 first.
Columns from each query will be preserved. Any duplicate data will need to be manually removed.
Answer C is incorrect, The Spiit Column option splits column by delimiter or character.
Answer D is incorrect. The Merge option requires a matching field between the queries, similarto a key field in a relationship.
Answer 8 s 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 2pply.
¢ (A st
Webtrends Analytics
D O IsON
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 Dis incorrect. JSON is the example of the file connection type.
Analyzing Data with Self-Service BI, Connecting to Data Sources, and Managing Data
Topic C: Create Data Connections
, nje $53USNQ Ppe 12U SUOISI3P YU O P3SN 3q UEd 18U EIep SZUBUANG '€
spioquseq pue suoday aseys 13 2oL
spizoquseq pue sHoday
5dn016 G9g YOSOIIN pu ‘isy uonnguIsIp ‘sdnoib
fauinyss Buisn Aq 121000 g 1amog 13ys Beue 0} suoezIueBiO SIGeus 0} PAUBISaP S 12y} 32edSHIOM P3IEYS © O SI3ja1 3IRASHIOM MAU Y "PRLIOII S| 3 JSMSUY
“2dedspiom ajis-mau e of ajy ot Bunysiand uauy pue doptsaq I J2mod Ut 3l XIad © Bunea.n Aq syeseaep nok o) sseade el Ued s5esN PRLODU! 51§ JANSUY
“PRUSIGNd U35q Sey Y 20U 19SE1EP 34} 35N PuE 553008 UED 3DESHIOM U J0 ISGUIBU € 51 Ol 135N Aue YNEJ3D A BBS 18 J3MOd U UK WOl S3j0s
21 0 1351 GuuBisse s pue ‘doBSA |3 JAMOG LI WO [3pOu 1EP € 0 S3jns pu S3j01 Aanoas Buippe Aq (STH) ANDas [213}-wo1 uawaIdul ued siasn
3102 34 Q pue ¥ SIBNSUY
uoneue|dx
“dopfsaq (g J2MOg UILM WO [3POL B3eP & O} S3jn PUE S3(02 N33 PPY.
sdnoib G9¢ YosOLI pue ‘Sist vognquasip sdnosb fumssasn 0| D
doppsaq i femog Ui A XigA R AL (] 8
“23(A13§ |§ 22O 343 UILAIM WO SR(0J U 03 SI3SN UBISSY.
fidde 1oy 12 35003 "uoRn|0S 3y} §0 ed @ sjussaIdas JaMSUR PO Y23
2159 34 usiduios>e oy pauioyiad 2q pinous sdts Bumolfoy
20310 U1 13O E12p im0k 03 UN3as [343}-Mo1 JuWaIAuL 3 e RO "EIep AASUSS UIEIUO S0l 3U) SY0GaI O BUIITIUO (3pOLI |3 5aMOg 24 uLsaIdu! RO
o) A
