FC0-U61 · Question #465
A database administrator has placed data from another source into a database. Which of the following did the database administrator perform?
The correct answer is A. Import. When a database administrator moves data from an external source into a database, this action is known as an import. This process integrates external data into the database's existing structure.
Question
A database administrator has placed data from another source into a database. Which of the following did the database administrator perform?
Options
- AImport
- BExport
- CCreate
- DQuery
How the community answered
(26 responses)- A92% (24)
- B4% (1)
- D4% (1)
Why each option
When a database administrator moves data from an external source into a database, this action is known as an import. This process integrates external data into the database's existing structure.
Importing data refers to the process of bringing data from an external source, such as a file, another database, or an application, into a target database. This operation is crucial for populating a database with initial data or updating it from various sources.
Exporting data is the opposite operation, involving moving data out of a database to an external file or system, not bringing it in.
Creating refers to building a new database object, such as a table, index, or the database itself, not specifically populating it with data from an external source.
Querying involves retrieving, filtering, or manipulating existing data within the database based on specific criteria, not adding new data from an outside source.
Concept tested: Database data transfer operations
Source: https://learn.microsoft.com/en-us/sql/relational-databases/import-export/data-import-and-export-wizard?view=sql-server-ver16
Topics
Community Discussion
No community discussion yet for this question.