QUESTION: 229

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

Whether or not it is also a secure view
How often the underlying base table is queried
How often the base table changes
Whether the materialized view has a cluster key defined
How often the materialized view is queried

Answer(s): C,D

Reveal Solution Next Question

QUESTION: 230

What COPY INTO SQL command should be used to unload data into multiple files?

SINGLE=TRUE
MULTIPLE=TRUE
MULTIPLE=FALSE
SINGLE=FALSE

Answer(s): D

Reveal Solution Next Question

QUESTION: 231

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

The cloned views and the stored procedures will reference the cloned tables in the cloned database.
An error will occur, as views with qualified references cannot be cloned.
An error will occur, as stored objects cannot be cloned.
The stored procedures and views will refer to tables in the source database.

Answer(s): D

Reveal Solution Next Question