D075 OA Questions PDF

Preview

Summary

OA Study Questions...

Description

D075 OA QUESTIONS 1. A large heating and air conditioning company provides each employee with a small computing device that the employees use to track work and accept payments. Which term refers specifically to this type of device? a. b. c. d.

Handheld computer Peripheral computer Minicomputer microcomputer

2. What is the meaning of one to many relationship in a database? One table linked a. One primary key linked to multiple foreign keys b. One record is linked to many other records c. One table contains multiple link primary keys d. One file is linked to 3. What are the basic components, in addition to computers, that are required for a local network to function? (Module 1, Lesson 3) a. Internet connection, a network operating system, and a network administrator b. Ethernet cards, a modem, a router, and a network database c. Ethernet cards, a common protocol, ethernet cables, and a hub d. Internet connection, a network interface controller, and a cabling system 4. what is the network protocol that is used for transmitting packets on the internet? a. TCP/IP (Module 1, Lesson 3) b. IPv6 c. HTML d. XML/FTP 5. Which term refers collectively to the computer equipment, the network configuration, the software, and the databases used in a business? a. Business intelligence systems b. Business network topology c. IT Platform d. IT Infrastructure 6. Which type of software suite generally includes work processing software, spreadsheet software, and presentation software? a. Utility software b. Project management software

c. Business computing software (Module 1, Lesson 2) d. Network software

7. On a day-to-day basis, what is the major focus and responsibility of a chief information officer (CIO)? Managing the IT group and designing the IT architecture 8. What kind of computers are used to process credit card payments? a. Clustered minicomputers b. Mainframe computers (Module 1, Lesson 2) c. Networked microcomputers d. Midrange computers 9. How can identifying project milestones using project management software help with project success? a. By showing when a task is completed and when a new task can start

10. What is the primary responsibility of a database administrator? a. To maintain software for the database management systems b. To ensure the security, integrity, reliability of the data in the organization 11. What 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? a. Phishing 12. What are the major benefits of using a wireless network rather than a local area network? a. Wireless networks are less expensive and more portable 13. An employee needs to send a contract electronically and ensure that it displays correctly and is not secretly modified. What type of document would be best to send? a. PDF

14. A law firm is located on a single floor of an office building and is setting up a client/server environment for its attorneys and their assistants.

What type of network is most appropriate for this firm? a. A local area network (LAN)

15. Often within an organization there is a special position to ensure that application software and even system software, is standardize across the organization. What is this position or responsibility called? Database administrator

16. What is the basic structure of a relational database? A group of linked tables

17. What is a major limitation of cloud-based services? An internet connection is needed to access cloud-based services.

18. Which type of software tools are designed to simplify and consolidate raw data and present them in graphs and charts that facilitate corporate decision-making? a. Business intelligence software

19. What is a database management software (DBMS)? A software system to store, update, and manage an organization’s data

20. An analyst at a company uses a type of data analytics to reveal future patterns in the marketplace by looking for correlations between seemingly unrelated data. Which type of process is this analyst employing? Predictive Analytics 21. What is the process of removing redundant data in a database called? Data Normalization

22. 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

23. What is the purpose of a data warehouse? To consolidate and store disparate data in a central location. 24. What is the basic unit that is used to organize data in a database management system (DBMS)? Files 25. What is it called when an organization implements security procedures to protect the hardware, network, and software from intrusion? System-level security

26. A bike company uses computerized simulations to test a product in various conditions before creating a physical prototype of the product. Which category does this process fall under? Applied Research 27. What are the two main types of research that the Research and Development department does? Basic and Applied 28. A company uses software to prepare, present, and report the company’s financial statements? Which set of standards dictates how the software should prepare, present, and report the company’s financial statements? Generally Accepted Accounting Principles (GAAP)

29. In order to control household Internet of Things devices remotely via a phone application (app), each item must be connected to the internet. Which two pieces of information are required to make these devices work? An IP address and MAC address

30. A company is working on a self-driving car that will be able to deliver prescription medications to people with limited mobility. Which technology will be essential to the correct functioning of the new car? Global Positioning system (GPS) 31. Which type of server configuration is generally used by cloud web hosting providers? A balanced cluster of servers for all clients (Module 8, Lesson 19)

32. What is a customer relationship management (CRM)? A system that manages a company’s interaction with customers (Module 7, Lesson 18) 33. The accuracy of data in a company’s database has been called into question, so an audit has been ordered. Which kind of records will usually be validated through the formal process of reconciliation? Accounting records 34. 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 decisions 35. What is the federal law that provides for data privacy for electronic medical records and requires doctors to obtain patient permission before sharing medical information about the patient? Health insurance portability and accountability act 36. Which technology enables people without computer programming skills to design and publish their own websites? a. Cloud based web hosting platforms b. Web application framework innovations c. Browser based web development tools d. Simplified web scripting languages

37. Which service allows businesses to increase their website server capacity in small increments as needed? a. Internet of Things

b. search engine optimization c. cloud web hosting d. browser based web development ] 38. A small online retailer has grown rapidly over the past year, and now during times of high activity, the retailer's web server is nearly at capacity. The retailer anticipates continued rapid growth but is concerned that this growth may stall if the economy goes into recession. What is an appropriate strategic planning decision for this retailer to make in order to ensure adequate server capacity? a. Use a cloud web hosting service b. install a load balancer on the server c. install clustered web servers d. use browser based web development 39. What type of report is summarized from transaction processing system (TPS) reports and is generally used for tactical decisions that require specific actions? a. management reports (Module 7, Lesson 18) b. supervisory reports c. transaction report's d. executive report 40. A marketing manager needs to quickly share information about a new product what can the manager use to quickly share the message to people that are part of the target market? a. Television advertisements b. social media platforms c. specialized publications d. company website 41. What is the defining characteristic of a mobile application (app) a. It tracks a devices location using GPS b. it can run on multiple devices c. it is designed to run on a smartphone d. it processes data in the cloud 42. A company is holding a customer relations training session, and the training team is deciding between holding the training as a conference or as a webinar. What is the primary reason to choose the webinar format? a. It does not require travel

43. What do most Internet of Things (Iot) devices requires in order to function? a.

44. A remote weather station since temperature, precipitation, and wind speed data to a centralized database 100 miles away in real time. Which type of technology is most likely used to record these data? a. RFID sensors b. Fiber optics c. IoT sensors d. Bluetooth connections 45. A company markets its product only on social media. Why is this marketing strategy likely to limit sales?...