Database Management – Week 7

Database Management, Information Technology
Average Rating
0 out of 5 stars. 0 votes.

Question 1

Which of the following is a legacy data integration tool with a graphical designer that had a limited range of functionality?

  • Selected: DTSThis answer is correct.
  • ETL
  • SSIS
  • FTP

Correct! DTS is a legacy data integration tool with a graphical designer that had a limited range of functionality.

1/1

Question 2

Which of the following is true about the factors that should be considered when evaluating database business requirements and the associated risk assessments?

  • Mission-critical systems provide administrators with a large time window for performing maintenance.
  • For best performance, backups should be done when the system is under peak load.
  • Selected: Databases that have a high change rate require more frequent backups.This answer is correct.
  • A single, large database is usually easier to maintain than several smaller databases.

Correct! Databases that have a high change rate require more frequent backups.

1/1

Question 3

Which of the following is true about packages created with SQL Server Data Tools?

  • You need to manually create a folder named “SSIS packages.”
  • Selected: Projects can contain multiple Integration Services packages.This answer is correct.
  • The default package name is default.dtsx.
  • The user interface is a command prompt.

Correct! Projects can contain multiple Integration Services packages.

1/1

Question 4

Which category of risk has the highest probability of occurrence?

  • Selected: user errorThis answer is correct.
  • system software failure
  • hardware failure
  • environmental events

Correct! User error has the highest probability of occurrence.

1/1

Question 5

If you experience database corruption, what should you do before performing a restore operation?

  • Selected: back up the transaction log tailThis answer is correct.
  • perform a fresh, full backup
  • restore the head of the transaction log
  • check the physical integrity of the database

Correct!  If you experience database corruption, you should back up the transaction log tail
before performing a restore operation.

1/1

Question 6

Aside from extracting and loading data, the process of data integration involves which of the following?

  • deleting data
  • summarizing data
  • Selected: transforming dataThis answer is correct.
  • selecting data

Correct! The process of data integration involves Extracting, Transforming, and Loading (ETL) data.

1/1

Question 7

An incompatibility between SQL Server and Windows would fall into which risk category?

  • user error
  • Selected: system software failureThis answer is correct.
  • hardware failure
  • environmental events

Correct! An incompatibility between SQL Server and Windows is considered a system software failure risk.

1/1

Question 8

How are full and differential database backups used?

  • A differential backup is followed by one or more full backups.
  • Selected: Differential backups are usually performed more often than full backups.This answer is correct.
  • Full backups copy data that has changed since the last differential backup.
  • Differential backups are more resource-intensive than full backups.

Correct! Differential backups are usually performed more often than full backups.

0/1

Question 9

What kind of task should be added to an SSIS package if you want to download a data file from an FTP site?

  • Selected: data flowThis answer is incorrect.
  • workflow
  • data preparation
  • SQL Server

Actually, look again. If you want to download a data file from an FTP site, the data preparation task should be added to an SSIS package. Review Module 7 again, and specifically, page 321 in Chapter 9 of the textbook.

1/1

Question 10

Which of the following is NOT a method that can be used to execute an Integration Services package?

  • dtexec.exe
  • SQL Server Agent job
  • dtexecui.exe
  • Selected: Windows task schedulerThis answer is correct.

Correct! Windows task scheduler is not a method that can be used to execute an Integration Services package.

Bottom of Form

Back to assessments                                         Bottom of Form

Back to assessments

Top of Form

Question 1

Which of the following is true about the factors that should be considered when evaluating database business requirements and the associated risk assessments?

  • Mission-critical systems provide administrators with a large time window for performing maintenance.
  • For best performance, backups should be done when the system is under peak load.
  • Selected: Databases that have a high change rate require more frequent backups.This answer is correct.
  • A single, large database is usually easier to maintain than several smaller databases.

Correct! Databases that have a high change rate require more frequent backups.

1/1

Question 2

If you experience database corruption, what should you do before performing a restore operation?

  • Selected: back up the transaction log tailThis answer is correct.
  • perform a fresh, full backup
  • restore the head of the transaction log
  • check the physical integrity of the database

Correct!  If you experience database corruption, you should back up the transaction log tail
before performing a restore operation.

0/1

Question 3

What type of component should you use if you need to convert numeric data to string data as the data flows between the source and destination?

  • script
  • Selected: data flowThis answer is incorrect.
  • file system task
  • transformation

Actually, look again. You should use transformation if you need to convert numeric data to string data as the data flows between the source and destination. Review Module 7 again, and specifically, page 322 in Chapter 9 of the textbook.

1/1

Question 4

What should you use when running the bcp utility if you want to import only certain columns and run the command interactively?

  • copy exclusion
  • schema view
  • import filter
  • Selected: format fileThis answer is correct.

Correct! When running the bcp utility, you should use a format file if you want to import only certain columns and run the command interactively.

1/1

Question 5

Which of the following is a legacy data integration tool with a graphical designer that had a limited range of functionality?

  • Selected: DTSThis answer is correct.
  • ETL
  • SSIS
  • FTP

Correct! DTS is a legacy data integration tool with a graphical designer that had a limited range of functionality.

1/1

Question 6

Which type of task should you add to an SSIS package if you need to perform operations on schema objects?

  • Selected: SQL ServerThis answer is correct.
  • maintenance
  • workflow
  • data preparation

Correct! You should add SQL Server if you need to perform operations on schema objects.

1/1

Question 7

Which category of risk has the highest probability of occurrence?

  • Selected: user errorThis answer is correct.
  • system software failure
  • hardware failure
  • environmental events

Correct! User error has the highest probability of occurrence.

1/1

Question 8

Which of the following are the basic building blocks of an SSIS package?

  • processes
  • functions
  • flows
  • Selected: tasksThis answer is correct.

Correct! The basic building blocks of an SSIS package are tasks.

1/1

Question 9

An incompatibility between SQL Server and Windows would fall into which risk category?

  • user error
  • Selected: system software failureThis answer is correct.
  • hardware failure
  • environmental events

Correct! An incompatibility between SQL Server and Windows is considered a system software failure risk.

1/1

Question 10

Which of the following is true about packages created with SQL Server Data Tools?

  • You need to manually create a folder named “SSIS packages.”
  • Selected: Projects can contain multiple Integration Services packages.This answer is correct.
  • The default package name is default.dtsx.
  • The user interface is a command prompt.

Correct! Projects can contain multiple Integration Services packages.

Bottom of Form

Back to assessments

Top of Form


Question 1

Which of the following is NOT a method that can be used to execute an Integration Services package?

  • dtexec.exe
  • SQL Server Agent job
  • dtexecui.exe
  • Selected: Windows task schedulerThis answer is correct.

Correct! Windows task scheduler is not a method that can be used to execute an Integration Services package.

0/1

Question 2

Which backup scheme reduces the amount of downtime to perform a restore, but creates additional IT management and physical resource overhead?

  • full database backup, plus differential database backup, plus multiple transaction log
    backups
  • Selected: full database backup plus multiple transaction log backupsThis answer is incorrect.
  • single transaction log backup plus full database backup
  • single transaction log backup plus simple recovery model

Actually, look again. A full database backup, plus differential database backup, plus multiple transaction log backups reduce the amount of downtime to perform a restore, but create additional IT management and physical resource overhead. Review Module 7 again, and specifically, page 294 in Chapter 8 of the textbook..

1/1

Question 3

What kind of task should be added to an SSIS package if you want to download a data file from an FTP site?

  • data flow
  • workflow
  • Selected: data preparationThis answer is correct.
  • SQL Server

Correct! If you want to download a data file from an FTP site, the data preparation task should be added to an SSIS package.

1/1

Question 4

Which of the following are the basic building blocks of an SSIS package?

  • processes
  • functions
  • flows
  • Selected: tasksThis answer is correct.

Correct! The basic building blocks of an SSIS package are tasks.

1/1

Question 5

What should you use when running the bcp utility if you want to import only certain columns and run the command interactively?

  • copy exclusion
  • schema view
  • import filter
  • Selected: format fileThis answer is correct.

Correct! When running the bcp utility, you should use a format file if you want to import only certain columns and run the command interactively.

1/1

Question 6

An incompatibility between SQL Server and Windows would fall into which risk category?

  • user error
  • Selected: system software failureThis answer is correct.
  • hardware failure
  • environmental events

Correct! An incompatibility between SQL Server and Windows is considered a system software failure risk.

1/1

Question 7

Which type of SSIS package task permits the package to interact with other applications?

  • data flow
  • Selected: workflowThis answer is correct.
  • scripting
  • maintenance

Correct! Workflow permits the package to interact with other applications.

1/1

Question 8

Which type of task should you add to an SSIS package if you need to perform operations on schema objects?

  • Selected: SQL ServerThis answer is correct.
  • maintenance
  • workflow
  • data preparation

Correct! You should add SQL Server if you need to perform operations on schema objects.

1/1

Question 9

How are full and differential database backups used?

  • A differential backup is followed by one or more full backups.
  • Selected: Differential backups are usually performed more often than full backups.This answer is correct.
  • Full backups copy data that has changed since the last differential backup.
  • Differential backups are more resource-intensive than full backups.

Correct! Differential backups are usually performed more often than full backups.

1/1

Question 10

Which category of risk has the highest probability of occurrence?

  • Selected: user errorThis answer is correct.
  • system software failure
  • hardware failure
  • environmental events

Correct! User error has the highest probability of occurrence.

Bottom of Form

Back to assessments

Top of Form

Question 1

Which category of risk has the highest probability of occurrence?

  • Selected: user errorThis answer is correct.
  • system software failure
  • hardware failure
  • environmental events

Correct! User error has the highest probability of occurrence.

1/1

Question 2

Which type of task should you add to an SSIS package if you need to perform operations on schema objects?

  • Selected: SQL ServerThis answer is correct.
  • maintenance
  • workflow
  • data preparation

Correct! You should add SQL Server if you need to perform operations on schema objects.

1/1

Question 3

What type of component should you use if you need to convert numeric data to string data as the data flows between the source and destination?

  • script
  • data flow
  • file system task
  • Selected: transformationThis answer is correct.

Correct! You should use transformation if you need to convert numeric data to string data as the data flows between the source and destination.

1/1

Question 4

Which of the following can be used for bidirectional data transfers and is a stand-alone application that is run from a command prompt?

  • BULK INSERT SQL
  • SSIS
  • Selected: bcp utilityThis answer is correct.
  • ETL

Correct! bcp utility can be used for bidirectional data transfers and is a stand-alone application that is run from a command prompt.

1/1

Question 5

An incompatibility between SQL Server and Windows would fall into which risk category?

  • user error
  • Selected: system software failureThis answer is correct.
  • hardware failure
  • environmental events

Correct! An incompatibility between SQL Server and Windows is considered a system software failure risk.

1/1

Question 6

What should you use when running the bcp utility if you want to import only certain columns and run the command interactively?

  • copy exclusion
  • schema view
  • import filter
  • Selected: format fileThis answer is correct.

Correct! When running the bcp utility, you should use a format file if you want to import only certain columns and run the command interactively.

1/1

Question 7

Which of the following is NOT among the three primary factors that should be considered for each risk scenario identified?

  • probability of occurrence
  • magnitude of the impact
  • Selected: personnel involved in the scenarioThis answer is correct.
  • difficulty of timely detectionÂ

Correct! For each potential risk identified, the assessment should consider three primary factors: the probability of occurrence, the magnitude of the impact, and the difficulty of timely detection.

1/1

Question 8

Which of the following is a legacy data integration tool with a graphical designer that had a limited range of functionality?

  • Selected: DTSThis answer is correct.
  • ETL
  • SSIS
  • FTP

Correct! DTS is a legacy data integration tool with a graphical designer that had a limited range of functionality.

1/1

Question 9

If you experience database corruption, what should you do before performing a restore operation?

  • Selected: back up the transaction log tailThis answer is correct.
  • perform a fresh, full backup
  • restore the head of the transaction log
  • check the physical integrity of the database

Correct!  If you experience database corruption, you should back up the transaction log tail
before performing a restore operation.

1/1

Question 10

Which of the following is true about packages created with SQL Server Data Tools?

  • You need to manually create a folder named “SSIS packages.”
  • Selected: Projects can contain multiple Integration Services packages.This answer is correct.
  • The default package name is default.dtsx.
  • The user interface is a command prompt.

Correct! Projects can contain multiple Integration Services packages.

Bottom of Form

Back to assessments

 

1/1

Question 1

Which type of task should you add to an SSIS package if you need to perform operations on schema objects?

  • Selected: SQL ServerThis answer is correct.
  • maintenance
  • workflow
  • data preparation

Correct! You should add SQL Server if you need to perform operations on schema objects.

1/1

Question 2

Which basic data integration tool provides step-by-step instructions, but has a limited range of data transformation capabilities?

  • Selected: SQL Server Import and Export WizardThis answer is correct.
  • SQL Server Analysis Services
  • Integration Services Package
  • SQL Server Data Tools

Correct! The SQL Server Import and Export Wizard provides step-by-step instructions for designing a solution that meets basic data integration needs.

1/1

Question 3

Which backup scheme reduces the amount of downtime to perform a restore, but creates additional IT management and physical resource overhead?

  • Selected: full database backup, plus differential database backup, plus multiple transaction log
    backupsThis answer is correct.
  • full database backup plus multiple transaction log backups
  • single transaction log backup plus full database backup
  • single transaction log backup plus simple recovery model

Correct! A full database backup, plus differential database backup, plus multiple transaction log backups reduce the amount of downtime to perform a restore, but create additional IT management and physical resource overhead.

1/1

Question 4

If you experience database corruption, what should you do before performing a restore operation?

  • Selected: back up the transaction log tailThis answer is correct.
  • perform a fresh, full backup
  • restore the head of the transaction log
  • check the physical integrity of the database

Correct!  If you experience database corruption, you should back up the transaction log tail
before performing a restore operation.

1/1

Question 5

How are full and differential database backups used?

  • A differential backup is followed by one or more full backups.
  • Selected: Differential backups are usually performed more often than full backups.This answer is correct.
  • Full backups copy data that has changed since the last differential backup.
  • Differential backups are more resource-intensive than full backups.

Correct! Differential backups are usually performed more often than full backups.

1/1

Question 6

Which of the following is NOT among the three primary factors that should be considered for each risk scenario identified?

  • probability of occurrence
  • magnitude of the impact
  • Selected: personnel involved in the scenarioThis answer is correct.
  • difficulty of timely detectionÂ

Correct! For each potential risk identified, the assessment should consider three primary factors: the probability of occurrence, the magnitude of the impact, and the difficulty of timely detection.

1/1

Question 7

An incompatibility between SQL Server and Windows would fall into which risk category?

  • user error
  • Selected: system software failureThis answer is correct.
  • hardware failure
  • environmental events

Correct! An incompatibility between SQL Server and Windows is considered a system software failure risk.

1/1

Question 8

Which of the following is a legacy data integration tool with a graphical designer that had a limited range of functionality?

  • Selected: DTSThis answer is correct.
  • ETL
  • SSIS
  • FTP

Correct! DTS is a legacy data integration tool with a graphical designer that had a limited range of functionality.

1/1

Question 9

Which category of risk has the highest probability of occurrence?

  • Selected: user errorThis answer is correct.
  • system software failure
  • hardware failure
  • environmental events

Correct! User error has the highest probability of occurrence.

1/1

Question 10

Which of the following are the basic building blocks of an SSIS package?

  • processes
  • functions
  • flows
  • Selected: tasksThis answer is correct.

Correct! The basic building blocks of an SSIS package are tasks.

Leave a Reply

Your email address will not be published. Required fields are marked *