Connect to the "Covid data" source. Create a line chart using continuous months and new deaths. Find the Excess Kurtosis for the sum of new deaths.
A. -0.58
B. -0.69
C. -0.56
D. -0.67
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
Connect to the "Education" data source. Create a histogram using the Total score field and having a bin size of
100. Find out in which bin the students scored the highest verbal percentage? [Note: Verbal percentage should be calculated by considering how many marks scored in the verbal out of the total marks scored.]
A. 1000
B. 1500
C. 900
D. 1600
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
Connect to the "Global Superstore" data source and use the Orders table. Create a hierarchy of Segment, Category, Region. Create a crosstab using this hierarchy and add profit, profit ratio fields. Which of the following are true from the below options?
A. The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment
B. The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment (among all the segments)
C. The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765
D. The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment (among all the segments)
正解:B,C
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
When we blend the data, sometimes a Null value appears in place of data. What could be the possible reasons for the same?
A. The data types of the fields you are blending on are different.
B. The data to combine is at different level of detail.
C. The values in the primary and secondary data sources use different casing.
D. The secondary data source does not contain values for the corresponding values in the primary data source.
正解:A,C,D
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
Groups can be used in a calculated field.
A. False
B. True
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
小林** -
きのう試験に受験して、内容が暗記したDesktop-Certified-Associate問題集の問題にそっくりの問題がいくつかあって、助かりました。