SQL Data Pipeline DDL

Question 1

ALTER STREAM

Answer 1

Modifies the properties, columns, or constraints for an existingstream.

Question 2

ALTER TASK

Answer 2

Modifies the properties for an existing task.

Question 3

CREATE STREAM

Answer 3

Creates a new stream in the current/specified schema or replaces an existingstream.

Question 4

CREATE TASK

Answer 4

Creates a new task in the current/specified schema or replaces an existing task.

Question 5

DESCRIBE STREAM

Answer 5

Describes the columns in a stream.

Question 6

DESCRIBE TASK

Answer 6

Describes the columns in a task.

Question 7

DROP STREAM

Answer 7

Removes a stream from the current/specified schema.

Question 8

DROP TASK

Answer 8

Removes a task from the current/specified schema.

Question 9

SHOW STREAMS

Answer 9

Lists the streams for which you have access privileges.

Question 10

SHOW TASKS

Answer 10

Lists the tasks for which you have access privileges.