A database administrator needs to ensure that a newly installed corporate business intelligence application can access the company's transactional data. Which of the following tasks should the administrator perform first?

• A.Create a new service account exclusively for the business intelligence application.
• B.Build a separate data warehouse customized to the business intelligence application's specifications.
• C.Set up a nightly FTP data transfer from the database server to the business intelligence application server.
• D.Send the business intelligence administrator the approved TNS names file to configure the data mapping.
• E.Open a new port on the database server exclusively for the business intelligence application.

Comment: *

Name: *

Email: *

Verification: *

A group of developers needs access to a database in a development environment, but the database contains sensitive dat a. Which of the following should the database administrator do before giving the developers access to the environment?

• A.Audit access to tables with sensitive data.
• B.Remove sensitive data from tables
• C.Mask the sensitive data.
• D.Encrypt connections to the development environment.

Comment: *

Name: *

Email: *

Verification: *

A database administrator needs to ensure continuous availability of a database in case the server fails. Which of the following should the administrator implement to ensure high availability of the database?

• A.ETL
• B.Replication
• C.Database dumping
• D.Backup and restore

Comment: *

Name: *

Email: *

Verification: *

A database analyst notices a query statement is running slowly. Which of the following should the analyst review first?

• A.Missing indexes
• B.Code
• C.Table integrity
• D.Database patches

Comment: *

Name: *

Email: *

Verification: *

Which of the following tools is used for natively running a Linux system in Windows?

• A.WSL
• B.[Remote Desktop Protocol
• C.SSH
• D.ITelnet

Comment: *

Name: *

Email: *

Verification: *