nerdexam
CompTIA

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.

Database Fundamentals

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)
  • A
    92% (24)
  • B
    4% (1)
  • D
    4% (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.

AImportCorrect

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.

BExport

Exporting data is the opposite operation, involving moving data out of a database to an external file or system, not bringing it in.

CCreate

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.

DQuery

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

#Database operations#Data import#ETL

Community Discussion

No community discussion yet for this question.

Full FC0-U61 Practice