Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
What is the correct output when the following set of commands is executed in Databricks?
CREATE TABLE versions (software STRING, version STRING) TBLPROPERTIES (delta.enableChangeDataFeed = true);
INSERT INTO versions VALUES (‘IDE’, ‘6.2.0’);
UPDATE versions SET version = ‘5.1.0’ WHERE software = ‘IDE’;
INSERT INTO versions VALUES (‘IDE-1’, ‘1.3.0’);
DELETE FROM versions WHERE version = ‘1.3.0’;
SELECT max(_commit_version), max(version) FROM table_changes(‘versions’, 2);
```_
CREATE TABLE versions (software STRING, version STRING) TBLPROPERTIES (delta.enableChangeDataFeed = true);
INSERT INTO versions VALUES (‘IDE’, ‘6.2.0’);
UPDATE versions SET version = ‘5.1.0’ WHERE software = ‘IDE’;
INSERT INTO versions VALUES (‘IDE-1’, ‘1.3.0’);
DELETE FROM versions WHERE version = ‘1.3.0’;
SELECT max(_commit_version), max(version) FROM table_changes(‘versions’, 2);
```_
A
+-----------------------+---------------+
| max(_commit_version) | max(version) |
+-----------------------+---------------+
| 3 | 6.2.0 |
+-----------------------+---------------+
+-----------------------+---------------+
| max(_commit_version) | max(version) |
+-----------------------+---------------+
| 3 | 6.2.0 |
+-----------------------+---------------+
B
+-----------------------+---------------+
| max(_commit_version) | max(version) |
+-----------------------+---------------+
| 4 | 6.2.0 |
+-----------------------+---------------+
+-----------------------+---------------+
| max(_commit_version) | max(version) |
+-----------------------+---------------+
| 4 | 6.2.0 |
+-----------------------+---------------+
C
+-----------------------+---------------+
| max(_commit_version) | max(version) |
+-----------------------+---------------+
| 4 | 5.1.0 |
+-----------------------+---------------+
+-----------------------+---------------+
| max(_commit_version) | max(version) |
+-----------------------+---------------+
| 4 | 5.1.0 |
+-----------------------+---------------+
D
+-----------------------+---------------+
| D91873(_commit_version) | max(version) |
+-----------------------+---------------+
| 3 | 1.3.0 |
+-----------------------+---------------+
+-----------------------+---------------+
| D91873(_commit_version) | max(version) |
+-----------------------+---------------+
| 3 | 1.3.0 |
+-----------------------+---------------+
E
+-----------------------+---------------+
| max(_commit_version) | max(version) |
+-----------------------+---------------+
| 3 | 5.1.0 |
+-----------------------+---------------+
+-----------------------+---------------+
| max(_commit_version) | max(version) |
+-----------------------+---------------+
| 3 | 5.1.0 |
+-----------------------+---------------+