D 0 7 5 F i n a l E x a m S t u d y G u i d e - I n f o r m a t i o n T ec h n o l o g y M a n a g e m e n t
Essentials | Questions And Answers, Latest Update | 100% Correct Answers |
Graded
D075 INFORMATION TECHNOLOGY MANAGEMENT ESSENTIALS
1.- Which kind of computers are used to process credit card payments? MAINFRAIME
2.- What is a solid-state drive (SSD) used for? HARD DRIVE, SAME KIND OF MEMORY AS FLASH DRIVES
3.- What is the basic structure of a relational database? TABLES,COLUMNS,FIELS,ROWS,KEYS
4.- What does the term twisted pair refer to? CANCELS ELECTROMAGNETIC INTERFERENCE
5.- Which term refers collectively to the computer equipment, the network configuration, the software,
and the databases used in a business? IT INFRASTUCTURE
6.- A law firm is located on a single floor of an ofÏce building and is setÝng up a client/server
environment for its attorneys and their assistants.
Which type of network is most appropriate for this firm? STAR TOPOLOGY
7.- Which kind of fraudulent activity can involve emails where someone tries to obtain personal
information such as social security numbers, bank account numbers, or credit card details from the
recipient? PHISHING
8.- What is installed short-term working memory in a computer usually called? RAM
9.- What must IT managers frequently update to protect a company’s IT infrastructure from virus
attacks? FIREWALL
10.- What are examples of hardware that need to be requested for a new employee? LAPTOP,
KEYBOARD, USB STICK,PHONE,INTERNET CONNECTION
11.- An employee has been tasked with copying spreadsheets from an individual network drive to a
shared network drive. Which components of the IT infrastructure will this employee need to access to
accomplish this task? HARDWARE SOFTWARE, DATA, NETWORK
12.- An employee has been tasked with sharing sales data from spreadsheet reports at a meeting and
needs to summarize the data into easy-to-view charts. BUISNESS INTELLIGENCE
Which additional software category will this employee need access to display the charts in the meeting?
13.- What should be the primary consideration for IT managers when making software and hardware
purchases to support IT infrastructure? compatibility
14.- How can identifying project milestones using project management software help with project
success? Establishes a way to estimate the timr to complete a project
15.- What is the primary responsibility of a database administrator? Responsible for categorizing data
requirements and creating the database entities and models that ensure accurate and smooth-flowing
information throughout a business.
16.- Who does the chief information ofÏcer generally report to? A board-level head of an information
technology department within a business organization. CEO
, 17.- Who does the chief technology ofÏcer normally report to? Person that manages the organization's
IT engineering group and serves as the company's top technology architect. CIO
18.- What is the defining characteristic that differentiates structured data from unstructured data?
Structured data is clearly defined, Unstructured data requires more work to understand
19.- What is the purpose of a data warehouse? Perform analytic processes from many data bases.
20.- Which concepts comprise the process of data governance? Data policies, data procedures and
standards to secure data.
21.- What is a database management system (DBMS)? Program controlling the structure of a database.
22.- What is the term used to describe the policies and procedures to protect hardware, communication
equipment, and software from unauthorized intrusion and malware? Cybersecurity, firewall
23.- What is the process of consistent data hygiene? Replace, modify, delete dirty coarse unusable data
24.- Why does the ETL (extract, transform, load) process require careful planning? Eats bandwidth and
storage at an alarming rate
25.- Why do managers use SQL (Structured Query Language) to produce data output? Allows managers
to write queries and generate reports
26.- An IT professional applies statistics and logic techniques to define, illustrate, and evaluate data.
The purpose of this process is to turn the data into useful information.
What is this process called? Data analysis
27.- What are the two main types of research that the Research and Development department does?
Basic research, applied research
28.- The owners of a family-owned supermarket have decided to implement a computerized checkout
and reporting system. Which type of system is most appropriate for this purpose? DSS- point of sale
(POS)
29.- An executive for a large shipping company asks the IT department to investigate and recommend a
decision support system (DSS) that will help the company use quarterly and annual data to formulate
long-term plans. Which types of decisions must this DSS primarily support? strategic
30.- According to the National Science Foundation (NSF), what are the 3 types of research and
development collaboration? Basic, applied, development
31.- A business analyst is using business intelligence (BI) software to determine how effective the social
media promotions of a new product have been. The goal is to adjust the strategy for these promotions
based on the information. Which department within the company will be responsible for tactical
decisions based on this business intelligence? Data analytics
32.- Jack has done a web search to find a company that sells cake pans, and the first items on the search
results page are paid advertisements from a large online retail company and a restaurant supply store.
Which strategy was employed to get those advertisements to the top of the page? (SEO) search eng opt.
Essentials | Questions And Answers, Latest Update | 100% Correct Answers |
Graded
D075 INFORMATION TECHNOLOGY MANAGEMENT ESSENTIALS
1.- Which kind of computers are used to process credit card payments? MAINFRAIME
2.- What is a solid-state drive (SSD) used for? HARD DRIVE, SAME KIND OF MEMORY AS FLASH DRIVES
3.- What is the basic structure of a relational database? TABLES,COLUMNS,FIELS,ROWS,KEYS
4.- What does the term twisted pair refer to? CANCELS ELECTROMAGNETIC INTERFERENCE
5.- Which term refers collectively to the computer equipment, the network configuration, the software,
and the databases used in a business? IT INFRASTUCTURE
6.- A law firm is located on a single floor of an ofÏce building and is setÝng up a client/server
environment for its attorneys and their assistants.
Which type of network is most appropriate for this firm? STAR TOPOLOGY
7.- Which kind of fraudulent activity can involve emails where someone tries to obtain personal
information such as social security numbers, bank account numbers, or credit card details from the
recipient? PHISHING
8.- What is installed short-term working memory in a computer usually called? RAM
9.- What must IT managers frequently update to protect a company’s IT infrastructure from virus
attacks? FIREWALL
10.- What are examples of hardware that need to be requested for a new employee? LAPTOP,
KEYBOARD, USB STICK,PHONE,INTERNET CONNECTION
11.- An employee has been tasked with copying spreadsheets from an individual network drive to a
shared network drive. Which components of the IT infrastructure will this employee need to access to
accomplish this task? HARDWARE SOFTWARE, DATA, NETWORK
12.- An employee has been tasked with sharing sales data from spreadsheet reports at a meeting and
needs to summarize the data into easy-to-view charts. BUISNESS INTELLIGENCE
Which additional software category will this employee need access to display the charts in the meeting?
13.- What should be the primary consideration for IT managers when making software and hardware
purchases to support IT infrastructure? compatibility
14.- How can identifying project milestones using project management software help with project
success? Establishes a way to estimate the timr to complete a project
15.- What is the primary responsibility of a database administrator? Responsible for categorizing data
requirements and creating the database entities and models that ensure accurate and smooth-flowing
information throughout a business.
16.- Who does the chief information ofÏcer generally report to? A board-level head of an information
technology department within a business organization. CEO
, 17.- Who does the chief technology ofÏcer normally report to? Person that manages the organization's
IT engineering group and serves as the company's top technology architect. CIO
18.- What is the defining characteristic that differentiates structured data from unstructured data?
Structured data is clearly defined, Unstructured data requires more work to understand
19.- What is the purpose of a data warehouse? Perform analytic processes from many data bases.
20.- Which concepts comprise the process of data governance? Data policies, data procedures and
standards to secure data.
21.- What is a database management system (DBMS)? Program controlling the structure of a database.
22.- What is the term used to describe the policies and procedures to protect hardware, communication
equipment, and software from unauthorized intrusion and malware? Cybersecurity, firewall
23.- What is the process of consistent data hygiene? Replace, modify, delete dirty coarse unusable data
24.- Why does the ETL (extract, transform, load) process require careful planning? Eats bandwidth and
storage at an alarming rate
25.- Why do managers use SQL (Structured Query Language) to produce data output? Allows managers
to write queries and generate reports
26.- An IT professional applies statistics and logic techniques to define, illustrate, and evaluate data.
The purpose of this process is to turn the data into useful information.
What is this process called? Data analysis
27.- What are the two main types of research that the Research and Development department does?
Basic research, applied research
28.- The owners of a family-owned supermarket have decided to implement a computerized checkout
and reporting system. Which type of system is most appropriate for this purpose? DSS- point of sale
(POS)
29.- An executive for a large shipping company asks the IT department to investigate and recommend a
decision support system (DSS) that will help the company use quarterly and annual data to formulate
long-term plans. Which types of decisions must this DSS primarily support? strategic
30.- According to the National Science Foundation (NSF), what are the 3 types of research and
development collaboration? Basic, applied, development
31.- A business analyst is using business intelligence (BI) software to determine how effective the social
media promotions of a new product have been. The goal is to adjust the strategy for these promotions
based on the information. Which department within the company will be responsible for tactical
decisions based on this business intelligence? Data analytics
32.- Jack has done a web search to find a company that sells cake pans, and the first items on the search
results page are paid advertisements from a large online retail company and a restaurant supply store.
Which strategy was employed to get those advertisements to the top of the page? (SEO) search eng opt.
