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 メンバーにのみ表示されます)
質問 2:
Connect to the "Global Superstore" data source and use the Orders table. Find out the group of states(in the US) having the highest sales in 2013?
A. North Carolina, South Carolina, Virginia
B. New York, Massachusetts, Rhode Island
C. California, Idaho, Nevada
D. Texas, New Mexico, Colorado
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
Which of the following are valid calculations?
A. SUM([Profit]) * 1000
B. MAX(SUM(Profit), (Sales))
C. SUM([Profit]) * SUM([Quantity])
D. SUM([Profit]) * [Quantity]
正解:A,C
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
You need to create a filled map using the City field, you drop the City field to your view. And you get the location error 'Ambigious', what does it mean, and how you will fix this issue?
Larger image

A. The city name must be misspelled. Correct the spelling to fix the issue.
B. Click on the Reset matches button to fix this issue.
C. More than one city has that name. Update the data type of the field to fix this issue.
D. More than one city has that name. Adjust the geographic roles to fix this issue.
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
To create a choropleth map, your data source should include the following types of information?
A. Custom Territories
B. Location names or custom polygons
C. Quantitative or qualitative values
D. Background image
正解:B,C
解説: (Pass4Test メンバーにのみ表示されます)
秋山** -
聞いただけで諦めたくなっている方も,階段を一段一段上がるような感覚で理解できるようになりました。しっかり網羅しているので、Desktop-Certified-Associate初学者も再挑戦者も効率的に学習を進められます!