SQL Data Pipeline DDL Flashcards

1
Q

ALTER STREAM

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

ALTER TASK

A

Modifies the properties for an existing task.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

CREATE STREAM

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

CREATE TASK

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

DESCRIBE STREAM

A

Describes the columns in a stream.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

DESCRIBE TASK

A

Describes the columns in a task.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

DROP STREAM

A

Removes a stream from the current/specified schema.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

DROP TASK

A

Removes a task from the current/specified schema.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

SHOW STREAMS

A

Lists the streams for which you have access privileges.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

SHOW TASKS

A

Lists the tasks for which you have access privileges.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly