Ask for behaviour if multiple rows of data has been ingested at the same time

I am currently adding a new SQL in our custom SQL query extension.

The SQL will return data like the following:

Currency Count
AUD 10
MYR 6
NZD 12

What will be the behaviour when the data being ingested. Will each row being regarded as 3 individual metrics data with 2 dimensions, like:

Metrics 1 - AUD, 10

Metrics 2 - MYR, 6

Metrics 3 - NZD, 12

or it will include all rows into a single metrics?

Depends on how you configure it.  If you configure the currency as dimension, you will get 1 metric with 3 dimensions in it.