D075 Test Questions Answers Latest Updated

What is the purpose of a universal serial bus (USB) on a laptop or desktop computer? It provides a wired ethernet connection to the network. It serves as an internal transmission bus between components within the computer. It allows for universal data transmission to various types of wireless networks. It allows the computer to connect peripheral devices. - ANSWER-It allows the computer to connect peripheral devices. What is the name of the law that states a doctor cannot share a patients results/records? - ANSWER-Health Insurance Portability and Accountability Act: A federal law that provides data privacy and implements security provisions to safeguard an individual's medical information. A HIPAA form is signed each time you visit a new doctor so they can understand who they can share that information with. FERPA—Family Educational Rights and Privacy Act - ANSWER-FERPA—Family Educational Rights and Privacy Act: A federal law that protects the rights of students' educational records. Information about grades, attendance, disciplinary records, report cards, transcripts, and so forth cannot be given to anyone not specifically listed on a FERPA form that is signed when a student enters a school. Which part of a computer executes the computations required by the software? The central processing unit The operating system The motherboard The random-access memory - ANSWER-The central processing unit Which category of software includes programs such as word processors and PDF document readers? Utility software Application software Project software System software - ANSWER-Application software What is the major function of a computer operating system? Data management Application program management Network management Computer resource management - ANSWER-Computer resource management Within a productivity suite, which method of selecting static data from one application and copying it to another application requires the use of temporary memory? Cut and paste Object embedding Object linking File transfer - ANSWER-Cut and paste Which type of device is an ethernet card? Network server hardware Network firewall hardware Network operating system (NOS) Network interface controller (NIC) - ANSWER-Network interface controller (NIC) What is the purpose of a MAC address? To uniquely identify an internet URL To uniquely identify a computer on a network To uniquely identify a computer motherboard To uniquely identify an email client - ANSWER-To uniquely identify a computer on a network Which topology implements a network where if the central hub fails, all nodes attached to the hub will also fail? A mesh topology A linear bus topology A ring topology A star topology - ANSWER-A star topology. These are the most common. A local drafting firm has a secured local area network that uses Ethernet cables to connect to client computers. After ensuring that the computer is connected to the network, what must a user provide to in order to be authenticated? An encryption key A digital signature A MAC address A password - ANSWER-A password Many websites keep track of a user's actions and information. They store much of this information on the user's computer in a private folder on the hard drive. What are these very small files called? Tracking packages Tracking URLs Tracking data Tracking cookies - ANSWER-Tracking cookies A discussion board facilitates communication between geographically dispersed group members. What is the correct term to describe an initial post and its subsequent comments? A thread A stream Linked posts Linked comments - ANSWER-A thread How does a Gantt chart facilitate project management? It graphically shows the organization of a project team. It helps calculate the projected and actual costs of a project. It identifies and sequences the tasks of a project. It maps the flow of communication and decisions for a project - ANSWER-It identifies and sequences the tasks of a project. A business organization can increase collaboration if it has a database of its internal reports, articles, documents, policies, and decisions. Which tool helps manage this type of information? A data warehouse A knowledge management system A business information system A collaborative database - ANSWER-A knowledge management system On a day-to-day basis, what is the major focus and responsibility of a chief technology officer? Interfacing with the IT users and setting end-user policies Ensuring that the IT infrastructure is up to date Managing the IT group and designing the IT architecture Keeping the IT development projects on schedule - ANSWER-Managing the IT group and designing the IT architecture What is the title of the person within an IT department whose responsibility is to set policies for passwords, create rules for backup and recovery, and facilitate the protection of the data center and computers with the data and information? Chief cybersecurity officer Chief operating officer Chief technology officer Chief information security officer - ANSWER-Chief information security officer What is the title of the person in the organization who is directly responsible for the setup and operation of the organization's networks, including hardware and software? Network administrator Network architect Network engineer Network development - ANSWER-Network administrator What is the distinguishing feature that differentiates data from information? Data that have been recorded in a computer become information. Data that have been structured become information. Data that have been given context become information. Data that have been verified for correctness become information. - ANSWER-Data that have been given context become information. What is the purpose of a dashboard in business intelligence (BI) software? It is a visual presentation of graphs, charts, and diagrams. It is a graphical display of raw data to assist in data consolidation. It is a user tool for inputting queries into the software. It is a graphical user interface for controlling the execution of the software. - ANSWER-It is a visual presentation of graphs, charts, and diagrams. What is the standard programming language that is used to extract and update data in most relational databases? Structured Query Language (SQL) JavaScript Python Hypertext markup language (HTML) - ANSWER-Structured Query Language (SQL) When using extract, transform, and load (ETL), what is done during the "transform" step? The data are normalized and structured. The data are given context and relevance. The database is queried for relevant data. The database schema is designed and created. - ANSWER-The data are normalized and structured. When a company spends money on data management, it uses a metric to measure the benefit of this spending relative to the cost. What is this metric called? Profitability ratio Profit and loss Cost benefit analysis Return on investment - ANSWER-Return on investment One perpetual issue with corporate data is ensuring the data are accurate and valid. Procedures that apply to end users, managers, and IT personnel are often put in place to ensure good data. What is the term that describes this effort? Data governance Schema design Database management Master data management - ANSWER-Data governance What is the purpose of the primary key in a database? It is the primary encryption key for a secure database. It uniquely identifies the tables in a database. It uniquely identifies the records in a specific table. It is the record number of each record in a table. - ANSWER-It uniquely identifies the records in a specific table. What is the purpose of a foreign key in a database? It is a key that has invalid or decayed data. It is used to link multiple databases together. It is a key that connects to the wrong data. It is used to link two tables together. - ANSWER-It is used to link two tables together. A company decides to turn its networks and databases over to a third party to manage and to provide access. What term describes the specific solution used by this company? Cloud database Distributed database Managed database Relational database - ANSWER-Cloud database Endothon Company buys cabinet hardware from one manufacturer. Due to limited storage space for inventory, Endothon has partnered with the manufacturer to ship hardware just when it is needed. Which component of the IT supply chain could the company set up to efficiently communicate what it needs each week? An intranet at the manufacturer that Endothon can access An extranet that provides Endothon access to data from the manufacturer An extranet that provides the manufacturer access to data at Endothon An intranet at Endothon that the manufacturer can access - ANSWER-An extranet that provides the manufacturer access to data at Endothon The IT department of a company has been asked to provide systems for financial and investment management. Which business department has the greatest need for this type of system? Marketing Sales Operations Accounting - ANSWER-Accounting What makes IT unique compared to other departments in businesses? The IT department is funded through the budgets of the other departments. The IT department provides services and support to the other departments. The IT department is given monitoring authority over other departments. The IT department reports directly to the managers of other departments. - ANSWER-The IT department provides services and support to the other departments. Which strategy includes purchasing paid advertisements that appear at the top of results pages in a web browser? Landing page strategy Search engine marketing