Exporting Data to an External Table - DP-203 Exam

Correct Answer: B

The export command references the external table by name.

You can't override the external table properties with the help of the export command.

For example, data in the Parquet form can't be exported to the external table having CSV data format as CSV.

To know more about exporting data to an external table, please visit the below-given link:

In Azure, an external table is a read-only table that references data stored outside of the database. The external table definition includes information about the data's location, format, and access method.

When exporting data to an external table, the external table definition is created first, and then the data is written to the external data source. If the external table already exists, the export operation will overwrite the data stored in the external data source with the new data.

It is not possible to directly override the properties of an external table during the export operation. The external table properties are defined during the creation of the external table, and any changes to the properties require the external table to be dropped and recreated with the new properties.

However, it is possible to specify export options that affect the behavior of the export operation. For example, you can specify the file format, field delimiter, and compression options for the exported data. These options do not modify the properties of the external table, but they can affect how the data is stored in the external data source.

In summary, while it is not possible to directly override the properties of an external table during the export operation, you can specify export options that affect the behavior of the export operation. Any changes to the external table properties require the external table to be dropped and recreated with the new properties. Therefore, the correct answer to the question is B. No.