ExamGecko
Question list
Search
Search

List of questions

Search

Question 56 - Desktop Certified Associate discussion

Report
Export

Blend the Significant Volcano Eruption dataset with the Country population dataset using year and country. Find out which country is having 4 volcano eruptions in the year 1963 and what was the population of this country in the same year?

A.
Indonesia and 95,055,669
Answers
A.
Indonesia and 95,055,669
B.
Japan and 96,812,000
Answers
B.
Japan and 96,812,000
C.
Indonesia and 9,103,406,453
Answers
C.
Indonesia and 9,103,406,453
D.
Japan and 9,103,406,453
Answers
D.
Japan and 9,103,406,453
Suggested answer: A

Explanation:

Add the Country population excel sheet as a New Data Source.

Select column 1960 to 2013, click on Pivot.

Rename the new fields as Year and population.

Go to Data ->Edit Blend Relationship

Click on Custom and Add

Ensure the blend relationship exists in Country & Country Name, and year & year between primary and secondary data sources.

Drop the year to the filters shelf and only enter 1963.

Drop Country and Number of Records / volerup(Count) field to the view.

And drop population to the view from the secondary data source. Your view will look like this:

asked 23/09/2024
Tania Trif
50 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first