Combo D075 IT Tests & Pre-
Assessment Questions and All Correct
Answers.
Media Access Control address (MAC) - Answer Each computer attached to the internet or a
corporate network is uniquely identified so that it can be sent the information directed to it.
What is this unique identifier known as?
Business and leadership experience - Answer What is the most important qualification that a
Chief Information Officer (CIO) must possess?
Information security analyst - Answer A company has recently discovered that unauthorized
users have accessed data on the company intranet.
Which IT professional should investigate this concern?
The same graphical user interface - Answer What do all the applications in a productivity
software suite have in common?
To direct data to the intended target location. - Answer What is the purpose of a network
switch?
Network Administrator - Answer Policies must be enacted and enforced to protect corporate
assets. These policies include strong passwords, safe web browsing protocols, firewall
implementations, and malware protection.
Who is the IT professional responsible for enacting these policies?
Mainframes - Answer What is the term used to refer to a massive, room-sized computer that
processes and stores enormous amounts of bulk data and information?
Star - Answer In which network topology is each client computer connected directly to the
hub?
Clients - Answer What is the term used to refer to end-user computers on a network?
, IT Manager - Answer A company is planning several IT projects including a major software
development project. The software development project will be organized using the software
development life cycle (SDLC) methodology.
Which IT professional should be called upon to create a detailed project plan for this effort?
Velocity - Answer A data analyst is working with a very large set of data and trying to
calculate the amount of data processing that needs to be completed each week.
Which attribute of big data is this analyst addressing?
Hadoop - Answer Which tool allows large data sets to be stored and processed across
multiple servers?
Data scrubbing - Answer Which term is used to refer to the process of combining structured,
unstructured, and semistructured data into a data warehouse structure?
Segmentation - Answer Which technique is used to ensure data accuracy for a mailing
campaign?
SQL - Answer An analyst at a furniture company wants to use the company's relational
database to find out which customers have made purchases in the past six months.
What is an appropriate tool for the data analyst to use to find this information?
Data that have become outdated - Answer Which type of data are referred to as "decayed"?
Business intelligence software - Answer An analyst uses software to analyze data in the
company's data warehouse and produce information to guide the organization. The information
is presented in clearly understandable charts and graphs on a dashboard and is used to inform
decisions in the organization. Which type of software is this analyst using?
Foreign key - Answer A database manager is setting up a relational database. The manager
creates a field in a table that links to the primary key in a different table in the database. What is
this field called?
System-level security - Answer Which level of security is required to protect the hardware
and communications equipment that support a database?
Assessment Questions and All Correct
Answers.
Media Access Control address (MAC) - Answer Each computer attached to the internet or a
corporate network is uniquely identified so that it can be sent the information directed to it.
What is this unique identifier known as?
Business and leadership experience - Answer What is the most important qualification that a
Chief Information Officer (CIO) must possess?
Information security analyst - Answer A company has recently discovered that unauthorized
users have accessed data on the company intranet.
Which IT professional should investigate this concern?
The same graphical user interface - Answer What do all the applications in a productivity
software suite have in common?
To direct data to the intended target location. - Answer What is the purpose of a network
switch?
Network Administrator - Answer Policies must be enacted and enforced to protect corporate
assets. These policies include strong passwords, safe web browsing protocols, firewall
implementations, and malware protection.
Who is the IT professional responsible for enacting these policies?
Mainframes - Answer What is the term used to refer to a massive, room-sized computer that
processes and stores enormous amounts of bulk data and information?
Star - Answer In which network topology is each client computer connected directly to the
hub?
Clients - Answer What is the term used to refer to end-user computers on a network?
, IT Manager - Answer A company is planning several IT projects including a major software
development project. The software development project will be organized using the software
development life cycle (SDLC) methodology.
Which IT professional should be called upon to create a detailed project plan for this effort?
Velocity - Answer A data analyst is working with a very large set of data and trying to
calculate the amount of data processing that needs to be completed each week.
Which attribute of big data is this analyst addressing?
Hadoop - Answer Which tool allows large data sets to be stored and processed across
multiple servers?
Data scrubbing - Answer Which term is used to refer to the process of combining structured,
unstructured, and semistructured data into a data warehouse structure?
Segmentation - Answer Which technique is used to ensure data accuracy for a mailing
campaign?
SQL - Answer An analyst at a furniture company wants to use the company's relational
database to find out which customers have made purchases in the past six months.
What is an appropriate tool for the data analyst to use to find this information?
Data that have become outdated - Answer Which type of data are referred to as "decayed"?
Business intelligence software - Answer An analyst uses software to analyze data in the
company's data warehouse and produce information to guide the organization. The information
is presented in clearly understandable charts and graphs on a dashboard and is used to inform
decisions in the organization. Which type of software is this analyst using?
Foreign key - Answer A database manager is setting up a relational database. The manager
creates a field in a table that links to the primary key in a different table in the database. What is
this field called?
System-level security - Answer Which level of security is required to protect the hardware
and communications equipment that support a database?
