Which will result in support for zonemaps on the LastName column?

A.
“CREATE TABLE TableA (LastName VARCHAR(20));

B.
“CREATE TABLE TableA (LastName VARCHAR(20));
ALTER TABLE TableA ZONEMAP ON (LastName);

C.
“CREATE TABLE TableA (LastName VARCHAR(20)) DISTRIBUTE ON (LastName);

D.
“CREATE TABLE TableA (LastName VARCHAR(20));
CREATE MATERIALIZED VIEW ViewA AS SELECT * FROM TableA ORDER BY LastName;

Explanation: