An external table has been registered using this DQL statement:
REGISTER TABLE area_code_table (city STRING(256), area_code STRING(3))
Which DQL statement will return the area_code for New York?

A.
SELECT area_code FROM dm_area_code_table WHERE city = ‘New York’

B.
SELECT area_code FROM dm_dbo.area_code_table WHERE city = ‘New York’

C.
SELECT area_code FROM area_code_table (ALL) WHERE area_code_table.city = ‘New York’

D.
SELECT area_code_table FROM area_code WHERE city = ‘New York’

Explanation: