BIS-310 Exam 2
12. There is no way a manufacturing firm would implement an Internet of Things because the risk of hacking is far too high. a. True b. False
False
12. Online analytical processing is another name for enterprise application. a. True b. False
False
13. Businesses and organizations that manage a local area network (LAN) connect to the Internet via a Web browser. a. True b. False
False
13. Data cubes can be created on an ad hoc basis. There is no need to create them ahead of time. a. True b. False
False
13. The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files. a. True b. False
False
14. Smart cards are less protected from misuse that conventional credit, charge, and debit cards because the smart card information is not encrypted. a. True b. False
False
14. The Internet is a hyperlink-based system that uses a client/server model. a. True b. False
False
15. In a Hypertext Markup Language (HTML), the markers are codes that tell the browser how to format the text or graphics that will be displayed. a. True b. False
False
15. In linear regression, you are to find a line that best fits the data. Sometimes the line may be curved. a. True b. False
False
15. In the context of the relational database model, selecting involves combining two or more tables. a. True b. False
False
16. A telecommunications protocol is any material substance that carries an electronic signal to support communications between a sending and receiving device. a. True b. False
False
16. If you abandon an online shopping cart, the seller does not care what you were shopping for. a. True b. False
False
17. With an online transaction processing (OLTP) system, each transaction is accumulated over a period of time and prepared for processing in a large batch of similar transactions. a. True b. False
False
17. In the regression line Y = a+ bX + e, Y is the value of the independent variable. a. True b. False
False
18. In the regression line Y = a+ bX + e, a is the slope of the regression line. a. True b. False
False
19. A personal area network (PAN) is a wireless network that connects information networking devices within a small area, such as an office, home, or several floors of a building. a. True b. False
False
20. A wide area network (WAN) is a telecommunications network that connects users and their computers in a geographical area that spans a campus or business park, but not beyond the city limits. a. True b. False
False
20. It is acceptable to for transaction processing systems to capture inaccurate data. a. True b. False
False
20. Suppose your university administrators wish to summarize student GPA on Major, Gender, High School, Home City and ZIP Code dimensions. This cannot be done with one data cube. a. True b. False
False
21. A database administrator (DBA) is an important nontechnical position responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions that apply across all the databases in an organization. a. True b. False
False
21. Small and medium size organizations do not employ enterprise systems. a. True b. False
False
22. Excel's scenario manager can be used to solve optimization-type problems. a. True b. False
False
22. Network management software is a system software that controls the computer systems and devices on a network and allows them to communicate with each other. a. True b. False
False
24. Suppose a manager wishes to analyze historical trends in sales. He would use the online transaction processing (OLTP) system. a. True b. False
False
25. Users still need help from the IT function of the organization to create customer reports using modern reporting tools. a. True b. False
False
26. A customer relationship management (CRM) system helps a company to plan, execute, and control all the activities involved in raw material sourcing and procurement, conversion of raw materials to finished products, and the warehousing and delivery of finished product to customers. a. True b. False
False
26. Data modeling usually involves setting a specific business goal and then analyzing the data and information needed to reach that goal. a. True b. False
False
26. A conversion funnel is a visual depiction of a set of words that have been grouped together because of the frequency of their occurrence. a. True b. False
False
27. Product lifecycle management (PLM) typically includes customer relationship management (CRM) software. a. True b. False
False
29. Organizations can collect many types of data from a wide variety of sources, but typically they only collect structured data that fits neatly into traditional relational database management systems. a. True b. False
False
3. A collection of data fields that are all related to one object, activity, or individual is called a file. a. True b. False
False
3. Sensors that can monitor and report on data about traffic and parking conditions are part of a network of physical objects known as the Internet of Technology. a. True b. False
False
3. The market for m-commerce in North America is maturing much earlier than in Western Europe and Japan. a. True b. False
False
3. A marketing manager who does not have deep knowledge of information systems or data science, will NOTbe able to use BI tools a. True b. False
False
31. The ability to capture and analyze all customer interactions, generate appropriate responses, and gather data to create and build effective and efficient marketing campaigns is known as contact management. a. True b. False
False
32. Using the hosted software model implies that a small business firm needs to employ a full-time IT person to maintain key business applications. a. True b. False
False
34. Legacy systems typically run on the latest hardware. a. True b. False
False
36. In terms of e-commerce infrastructure, the Web server's required amount of storage capacity and computing power depends primarily on two things: the software that must run on the server and the quantity of content on the e-commerce site. a. True b. False
False
37. When implementing a new enterprise system, keeping the scope of the project fluid and flexible will ease the transition and yield the best results. a. True b. False
False
4. An attribute is a general class of people, places, or things for which data is collected, stored, and maintained. a. True b. False
False
4. The Transmission Control Protocol (TCP) is responsible for managing IP addresses and Internet domain names. a. True b. False
False
5. A vehicle routing optimization system helps in maximizing the number of drivers being assigned. a. True b. False
False
6. Data scientists do not need much business domain knowledge. a. True b. False
False
6. Like other programs, Java software can run only on specific types of computers. a. True b. False
False
6. Two sets of fields can have a common primary key. a. True b. False
False
7. In the past, market segmentation has been easy for B2B marketers because firmographic data was easy to obtain. a. True b. False
False
8. Consortium-operated exchanges are open to any set of buyers and sellers within a given market. a. True b. False
False
8. Today, most organizations use the traditional approach to data management, where multiple information systems share a pool of related data. a. True b. False
False
9. Creative data scientists - a key component of BI efforts in an organization - are people who are primarily focused on coming up with novel ways of analyzing data. a. True b. False
False
9. DBMSs are used primarily for modeling data. a. True b. False
False
9. In spite of the recent economic downturn, Website operators have shunned the idea of bartering for goods and services. a. True b. False
False
16. Data mining is used to explore large amounts of data, looking for hidden patterns that can be used to predict future trends and behaviors. a. True b. False
True
17. One of the primary advantages of a relational database is that it allows tables to be linked to reduce data redundancy and allow data to be organized more logically. a. True b. False
True
17. The Institute of Electrical and Electronics Engineers (IEEE) is a leading standards-setting organization whose IEEE network standards are the basis for many telecommunications devices and services. a. True b. False
True
18. 4G will deliver 3 to 20 times the speed of 3G networks for mobile devices. a. True b. False
True
18. The relational database model is currently the most widely used. a. True b. False
True
18. When there is a delay between an event and the eventual processing of the data, it is called batch processing. a. True b. False
True
19. A database management system (DBMS) serves as an interface between an application program and a database. a. True b. False
True
19. The main difference between batch processing and online transaction processing is in the timely update of data. a. True b. False
True
19. Linear regression is useful when you wish to predict the value of a quantitative variable based on a another quantitative variable. a. True b. False
True
2. A field is typically a name, number, or combination of characters that describes an aspect of a business object. a. True b. False
True
2. The Asia-Pacific region has overtaken North America as the region with the largest B2C sales and now accounts for over one-third of total worldwide B2C sales. a. True b. False
True
2. The Internet is the infrastructure on which the Web exists. a. True b. False
True
2. The data for BI (business intelligence) comes from many sources. a. True b. False
True
20. Some of the key factors in database design are content, access, structure, archiving, and security. a. True b. False
True
21. A client is any computer on a network that sends messages requesting services from the servers on the network. a. True b. False
True
21. Suppose you are viewing a database of your monthly expenses, categorized under broad headings such as food, entertainment and accommodation. If you have drill down ability, you are able to view details under each category. a. True b. False
True
22. A database administrator (DBA) must have a clear understanding of the fundamental business of an organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches. a. True b. False
True
22. An enterprise system ensures that information can be shared with all authorized users in different functional areas. a. True b. False
True
23. A virtual private network (VPN) supports a secure, encrypted connection between a company's employees and remote users through a third-party service provider. a. True b. False
True
23. If an organization is using several separate systems, they can be replaced with a single integrated set of applications for the entire enterprise. a. True b. False
True
23. Power Pivot and Power Query are components of Microsoft's Power BI tool. a. True b. False
True
23. Unstructured data comes from sources such as word-processing documents and scientific research. a. True b. False
True
24. An integrated database for the entire organization makes it easier to share data among different business units. a. True b. False
True
24. To solve the product mix problem that will maximize the profits, you can use Excel's Solver add-in. a. True b. False
True
24. When you use your lab computer to access a printer, you are using the local area network (LAN). a. True b. False
True
25. For each data item, a data dictionary usually contains information such as the name of the data item, the range of values that can be used, and the amount of storage needed for the item. a. True b. False
True
25. Implementation of an enterprise resource planning (ERP) system provides an organization with an opportunity to also upgrade the information technology that it uses. a. True b. False
True
25. When you point the remote control to turn on/off the TV, the remote is using radio frequency. a. True b. False
True
27. Carlos is working with an existing database, but he wants to eliminate some of the columns in the table to create a new, more streamlined database. He will use projection to create his new database. a. True b. False
True
27. If you wish to have a visual depiction of relative frequencies of words in a document, a word cloud would be an appropriate option. a. True b. False
True
28. Customer support, sales management, and contact management are key features of a customer relationship management (CRM) system. a. True b. False
True
28. Sometimes a database can contain "bad data," meaning incomplete, incorrect, inaccurate, or irrelevant records, which can be corrected or deleted through data cleansing. a. True b. False
True
29. External users of product lifecycle management (PLM) software include design partners and raw material suppliers. a. True b. False
True
30. Organizations frequently need to customize a vendor's enterprise resource planning (ERP) software to integrate other business systems. a. True b. False
True
33. XYZ Inc. assigned a part-time mid-level manager to supervise the implementation of an enterprise resource planning (ERP) system. The project has a high risk of failure. a. True b. False
True
35. Cultural differences, language barriers, and currency variations are all challenges that e-commerce and m-commerce merchants must address when selling to a global marketplace. a. True b. False
True
4. Conversion to an e-commerce or m-commerce system enables organizations to increase the accuracy of order processing and order fulfillment. a. True b. False
True
4. Some insurance companies can detect fraudulant claims using BI software. a. True b. False
True
5. Cascading Style Sheets (CSS) use special Hypertext Markup Language (HTML) tags to globally define font characteristics for a variety of page elements as well as how those elements are laid out on a Web page. a. True b. False
True
5. If "color" is an attribute, then "green" is a data item. a. True b. False
True
5. Lack of trust in online sellers is one of the most frequently cited reasons that some consumers are not willing to purchase online. a. True b. False
True
6. An electronic exchange is an electronic forum where manufacturers, suppliers, and competitors buy and sell goods, trade market information, and run back-office operations. a. True b. False
True
7. Organizations that are concerned about the security of their data should not use public cloud computing. a. True b. False
True
7. Suppose you are good in math and statistics. Adding programming to your skill-set will be necessary if you want to be a data scientist. a. True b. False
True
7. The database approach to managing data is superior to the file-based approach. a. True b. False
True
8. For an organization to get real value from its BI efforts, it must have a solid data management program. a. True b. False
True
8. JavaScript can be used to validate data entry in a Web form. a. True b. False
True
9. Twitter is a microblogging service. a. True b. False
True
50. When you are looking for a 'hotspot', you are searching for _____. a. a wireless access point b. bluetooth signals c. free charging stations d. strong satellite signals
a. a wireless access point
49. Suppose a new tech startup wants to define the data model. They would then ____. a. collect and cleanse the data b. define user access privileges c. create the entity-relationship model d. acquire a new database management system
c. create the entity-relationship model
56. The goal of business intelligence is to _____. a. provide access to novel tools to the users b. reduce the cost of data processing c. support and improve decision making d. improve employee morale
c. support and improve decision making
53. Kyle works for National Sporting Goods, where he manages critical data elements, such as identifying and acquiring new data sources, creating consistent reference data, and analyzing data for quality. Kyle is a _______. a. data steward b. data administrator c. database administrator d. data manager
a. data steward
39. In the _____ process, all of the data from various sources is converted into a single format suitable for processing. a. extract b. transform c. load d. consolidate
a. extract
58. The world-wide-web uses _____ protocol for transmitting content. a. hyper-text transfer b. mail transfer c. uniform resource location d. domain name server
a. hyper-text transfer
11. Bartering is a technique used by advertisers to recapture shoppers who abandoned a Website without making a purchase. a. True b. False
False
12. An enterprise data model is created only for documentation, but is otherwise inconsequential. a. True b. False
False
12. Smart card use is restricted to data associated with financial transactions. a. True b. False
False
1. The United States has high Internet penetration among its population constituting the majority of people online. a. True b. False
False
1. Business analytics can be used only for forecasting future business results. a. True b. False
False
10. A podcast is a video broadcast over the Internet. a. True b. False
False
1. A business-to-business (B2B) market is considerably larger than a business-to-consumer (B2C) market. a. True b. False
True
1. A database, a database management system, and the application programs that use the data, make up a database environment. a. True b. False
True
10. A database must reflect the business processes of an organization. a. True b. False
True
10. Consumers who have enrolled in mobile banking and downloaded the mobile application to their cell phones can check their credit card balances before making major purchases. a. True b. False
True
10. Data governance involves identifying people who are responsible for fixing and preventing issues with data. a. True b. False
True
11. Two of the major challenges business users face when using big data are finding the information they need to make decisions and knowing that the data they have is valid. a. True b. False
True
11. Video content can be placed on the Internet using the same approach as a blog. a. True b. False
True
11. In OLAP data cubes, you would likely find numeric measures categorized by time and geography. a. True b. False
True
13. PayPal enables any person or business with an e-mail address to securely, easily, and quickly send and receive payments online. a. True b. False
True
14. A relational model splits the information up into many two dimensional data structures. a. True b. False
True
14. During drill-down, you go from high-level summary data to detailed levels of data. a. True b. False
True
15. Smart cards can be used for a variety of purposes, including storing a user's financial facts, health insurance data, credit card numbers, and network identification codes and passwords. They can also store monetary values for spending. a. True b. False
True
16. In the context of the relational database model, projecting involves eliminating columns in a table. a. True b. False
True
49. When you connect your computer to a printer using _____, the distance between them cannot be longer than 30 feet. a. Bluetooth b. Wi-Fi c. near field communication d. infrared
a. Bluetooth
57. _____ is a good site to develop your professional network. a. LinkedIn b. Facebook c. Google d. Twitter
a. LinkedIn
37. Which of the following will be a 'fact' measure in a data cube used at a chain retail business? a. Sales revenue b. Month name c. Product category d. City name
a. Sales revenue
30. _____ consists of server and client software, the Hypertext Transfer Protocol (HTTP), standards, and markup languages that combine to deliver information and services over the Internet. a. The Web b. A tag c. A cache d. The motherboard
a. The Web
50. Conversion to an e-commerce or m-commerce system enables organizations to _________. a. improve the level of customer service b. implement an enterprise resource planning (ERP) system c. increase the cost of doing business d. reinforce consumer-to-consumer (C2C) e-commerce
a. improve the level of customer service
47. A _____ is a telecommunications network that connects users and their computers in a geographical area that spans a campus or a city. a. metropolitan area network (MAN) b. local area network (LAN) c. wide area network (WAN) d. personal area network (PAN)
a. metropolitan area network (MAN)
29. One of the goals of business intelligence is to _________. a. present the results in an easy to understand manner b. educate the users about business statistics c. ensure the transaction data is properly stored d. use the most sophisticated techniques
a. present the results in an easy to understand manner
33. A collection of fields all related to a single object, activity, or individual is a(n) _____. a. record b. file c. attribute d. character
a. record
48. To analzye various alternative scenarios, a manager would use _______. a. the spreadsheet's 'what-if' capability b. the graphing features of spreadsheet software c. the reporting feature of a BI tool d. a data visualization tool
a. the spreadsheet's 'what-if' capability
33. Domain names must always have at least _____ parts, with each part separated by a dot (period). a. two b. three c. four d. five
a. two
44. You would use Query by Example, if _____. a. you wish to use a visual approach to query building b. you build a query from an example c. you use a template for reports d. wish teach SQL with examples
a. you wish to use a visual approach to query building
31. What is the projected shortage of data scientists in the USA, according to a McKinsey & Co. report? a. 100,000 or less b. 100,000 to 200,000 c. 200,000 to 500,000 d. more than 500,000
b. 100,000 to 200,000
55. Which of the following is a potential disadvantagewith self-service BI? a. Accelerates and improves decision making. b. Can lead to over spending on unapproved data sources and business analytics tools. c. Encourages nontechnical end users to make decisions based on facts and analyses rather than intuition. d. Gets valuable data into the hands of the people who need it the most—end users.
b. Can lead to over spending on unapproved data sources and business analytics tools.
31. Which of the following is a markup language for defining the visual design of a Web page or group of pages? a. JavaScript b. Cascading Style Sheets (CSS) c. Java d. Extensible Markup Language (XML)
b. Cascading Style Sheets (CSS)
43. Which of the following forms of e-commerce has created an opportunity for many people to make a living out of selling items on auction Websites? a. Business-to-business (B2B) e-commerce b. Consumer-to-consumer (C2C) e-commerce c. Consumer-to-business (C2B) e-commerce d. Business-to-consumer (B2C) e-commerce
b. Consumer-to-consumer (C2C) e-commerce
61. _____ involves reentering data that was not typed or scanned correctly. a. Data editing b. Data correction c. Data manipulation d. Data encryption
b. Data correction
43. _____ is used to explore large amounts of data for hidden patterns to predict future trends. a. Data governance b. Data mining c. Linear regression d. Drill down
b. Data mining
45. With _____, the database is stored on a service provider's server and accessed by the client over a network, typically the Internet. a. Internet access b. Database as a Service c. Software as a Service d. Oracle
b. Database as a Service
41. Suppose you wish to find what tables are in a database, what fields they have, and how they are related you would review the _____. a. SQL commands b. attributes c. schema d. sample data
c. schema
35. _____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization. a. Data selecting b. Enterprise data modeling c. Data cleansing d. Social graph analysis
b. Enterprise data modeling
36. _____ is a markup language designed to transport and store data on the Web. a. Standard Generalized Markup Language (SGML) b. Extensible Markup Language (XML) c. Hypertext Markup Language (HTML) d. Hypermedia/Time-based Structuring Language (HyTime)
b. Extensible Markup Language (XML)
44. Which of the following statements is true of retargeting? a. It is targeted at approximately 50% of Website visitors who shop using smartphone applications. b. It employs personalized ads to direct shoppers back to a retailer's Website they previously abandoned. c. It attempts to change buying habits of Web shoppers to get them to consider products they have never considered purchasing before. d. It attempts to change buying habits of Web shoppers by getting them to visit Websites they have not visited before.
b. It employs personalized ads to direct shoppers back to a retailer's Website they previously abandoned.
68. Which of the following statements is true of product lifecycle management (PLM) software? a. It distributes data only to the employees of an organization. b. It provides documents required for FDA and environmental compliance. c. It secures data so that changes cannot be made early in the product design process. d. It is frequently employed by non-manufacturing organizations.
b. It provides documents required for FDA and environmental compliance.
53. From which vendor is the BI product Business Objects available? a. IBM b. SAP c. Google d. Microsoft
b. SAP
41. _____ is a process for driving traffic to a Web site by using techniques that improve the site's ranking in search results. a. Web content streaming b. Search engine optimization c. Tunneling d. Internet censorship
b. Search engine optimization
54. _________ encourages nontechnical end users to make decisions based on facts and analyses rather than intuition. a. Easy access to a degree in Statistics b. Self-service analytics c. Seeking expert opinions d. Outsourcing BI tasks
b. Self-service analytics
60. A small business is currently using a paper-based system for billing, which is slow and error-prone. Which system upgrade will make the process faster and have fewer errors? a. Manual entry of data into spreadsheet system b. Source data automation c. Scanning hand-written bills d. Enterprise resource planning system
b. Source data automation
35. You are to advise XYZ so that their BI efforts are fruitful. Which among the following is the most crucial advice of all? a. You need good data management practices b. There must be strong commitment from the management c. You need good data governance practices d. You need creative data scientists
b. There must be strong commitment from the management
64. According to the classification of enterprise resource planning (ERP) vendors, _____ vendors target medium-sized firms with annual revenues in the $50 million to $1 billion range operating out of one or more locations. a. Tier III b. Tier II c. Tier IV d. Tier I
b. Tier II
40. Web client software, such as Chrome, Firefox, Internet Explorer, Safari, and Opera, that are used to view Web pages are known as _____. a. Web portals b. Web browsers c. Web analytics software d. search engines
b. Web browsers
37. _____ consist of standards and tools that streamline and simplify communication among Websites and that promise to revolutionize the way the Web is developed and used for business and personal purposes. a. Web browsers b. Web services c. Hyperlinks d. Web forms
b. Web services
48. Which of the following statements is true of network-management software? a. One of the disadvantages of network-management software is the large amount of time spent on routine tasks. b. With network-management software, a manager on a networked personal computer can scan for viruses. c. Network-management software allows software to be copied, modified, or downloaded legally or illegally. d. Network-management software complicates the process of updating files and programs on computers on the network.
b. With network-management software, a manager on a networked personal computer can scan for viruses.
50. The graphical representation that summarizes the steps a consumer takes in making the decision to buy your product and become a customer is called _____. a. a word cloud b. a conversion funnel c. a scatter diagram d. a pivot chart
b. a conversion funnel
39. The coefficient of determination, r squared, is ____. a. the same as the error term in a linear regression b. a number that indicates how well data fits the statistical model c. a number that must be close to zero to be useful d. the same as the slope of the linear regression
b. a number that indicates how well data fits the statistical model
59. As an organization's purchasing systems generate purchase orders and the items ordered are received, information is sent to the _____ system to manage the amounts owed by the organization. a. accounts receivable b. accounts payable c. invoicing d. inventory control
b. accounts payable
32. The Internet Corporation for Assigned Names and Numbers (ICANN) uses companies called _____ to handle the business of registering domain names. a. registry operators b. accredited domain name registrars c. network information centers d. independent domain name registries
b. accredited domain name registrars
28. The fiber-optic cables that span the globe over land and under sea make up the Internet _____. a. ultrastructure b. backbone c. layer d. protocol
b. backbone
43. In a _____, all network devices are connected to a common backbone that serves as a shared communications medium. a. star network b. bus network c. ring network d. mesh network
b. bus network
55. Liesel is an entrepreneur, and she'd like to publish a website for her small business. Liesel ____________. a. will need her own server and IT people to run the server b. can use hosting services c. will need to learn Java d. will need to run her own web server on leased servers
b. can use hosting services
53. Suppose a business wishes to have access to servers, and storage devices, but does not want to buy them. What is their best choice? a. Internet of Things b. cloud computing - infrastructure as a service c. cloud computing - software as a service d. cloud computing - platform as a service
b. cloud computing - infrastructure as a service
43. The position of a _____ is a non-technical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization. a. data analyst b. data administrator c. database administrator d. data owner
b. data administrator
54. At Coast-to-Coast Moving and Van Lines, Ryan is responsible for managing the flow of the company's data, from initial acquisition of new data to deletion of old, outdated data. Ryan is involved in ___________. a. data stewardship b. data lifecycle management c. database administration d. data management
b. data lifecycle management
47. Starting from monthly sales data, if you wish to get weekly sales data, use the ___ feature. a. roll up b. drill down c. slice and dice d. extract data
b. drill down
52. A(n) _____ is central to individuals and organizations of all sizes and ensures that information can be shared across all business functions and all levels of management to support the running and managing of a business. a. transaction processing system b. enterprise system c. procurement system d. batch processing system
b. enterprise system
40. Which of these analysis methods describes neural computing? a. a specialized set of algorithms sorts through data and forms statistical rules about relationships among the items b. historical data is examined for patterns that are then used to make predictions c. historical if-then-else cases are used to recognize patterns d. a mathematical procedure to predict the value of a dependent variable based on a single independent variable
b. historical data is examined for patterns that are then used to make predictions
44. The area covered by one or more interconnected wireless access points is commonly called a(n) _____. a. reception area b. hot spot c. coverage zone d. access area
b. hot spot
73. You design and make women's jewelry, which you sell through an e-commerce site. Based on feedback from potential customers, you have decided to make a few changes to your site, such as developing a loyalty program, publishing customer testimonials, and including your Better Business Bureau Online accreditation logo. These steps are designed to address potential customers' ______. a. privacy concerns b. lack of trust c. language challenges d. all of these answers
b. lack of trust
56. Social journalism or citizen journalism ________. a. is accurate most of the time b. may not be as reliable as mainstream media sources c. is where everyone gets their news feeds d. is a good source for mostly facts
b. may not be as reliable as mainstream media sources
50. After entering data into a relational database, users can make all of the following basic data manipulations except: a. projecting b. organizing c. selecting d. joining
b. organizing
55. In batch processing systems, data processing is done _______ data capture. a. immediately after b. some time later than c. immediately before d. some time before
b. some time later than
42. Data within the data cube has been ______ by specific dimensional values. a. correlated b. summarized c. regressed d. drilled into
b. summarized
26. The ancestor of the Internet was _____. a. TCP/IP b. the ARPANET c. Telnet d. Web 1.0
b. the ARPANET
48. Which of the following is NOTone of the key website performance measures commonly used by online retailers? a. response time b. total sales c. transaction success rate d. system availability
b. total sales
52. Haley's employer has asked her to review tens of thousands of social media posts about their company's products and compile this data into a database. In terms of the characteristics of big data, Haley is dealing with ________. a. volume b. variety c. velocity d. veracity
b. variety
29. The Internet is migrating to Internet Protocol version 6 (IPv6), which uses _____ addresses to provide for many more devices. a. 32-bit b. 64-bit c. 128-bit d. 256-bit
c. 128-bit
46. _____ is the term used to describe enormous and complex data collections that traditional data management software, hardware, and analysis processes are incapable of handling. a. Data warehouse b. Data mart c. Big data d. Knowledge base
c. Big data
41. Suppose management wishes to start a BI project at your new job. Which of following will you recommend as the first step? a. Understand the data b. Prepare the data c. Clarify business goals and design a project plan d. Create and apply analytical modeling techniques
c. Clarify business goals and design a project plan
52. Which of the following is IBM's BI product? a. Power BI b. Business objects c. Cognos d. Hyperion
c. Cognos
33. Suppose your employer has four manufacturing units, each with its own data operations. They are considering using BI tools. Which of the following is a valid recommendation regarding the BI initiative? a. Automate data entry at the factories for reduction in error rates b. Implement BI tools in each factory separately c. Create a data warehouse so that data from the factories are combined for BI analysis d. None of these answers
c. Create a data warehouse so that data from the factories are combined for BI analysis
69. Which of these is an advantage of the hosted software model? a. Consistent reliability b. Data security c. Faster system start-up d. Increased total cost of ownership
c. Faster system start-up
52. If your home air conditioner has an IP address, it is part of the ____. a. satellite communication network b. virtual private network c. Internet of Things d. satellite communication network
c. Internet of Things
54. You wish to learn a programming language that can be used on any computer. What language would it be? a. php b. JavaScript c. Java d. ASP.Net
c. Java
42. _____ divides the pool of potential customers into subgroups usually defined in terms of demographic characteristics. a. Disintermediation b. Social networking c. Market segmentation d. Market augmentation
c. Market segmentation
42. _____ is a very short-range wireless connectivity technology designed for consumer electronics, cell phones, and credit cards. a. Microwave transmission b. Wireless mesh c. Near field communication (NFC) d. Wi-Fi
c. Near field communication (NFC)
46. Which of the following is NOTconsidered a BI and analytics tool? a. Data visualization b. Drill-down analysis c. Online transaction processing d. Data mining
c. Online transaction processing
40. _____ is a special-purpose programming language for accessing and manipulating data stored in a relational database. a. Query by Example (QBE) b. Access c. Structured Query Language (SQL) d. Java
c. Structured Query Language (SQL)
27. _____ is a communication standard that enables computers to route communications traffic from one network to another as needed. a. The ARPANET b. A Uniform Resource Locator (URL) c. The Internet Protocol (IP) d. A Wi-Fi
c. The Internet Protocol (IP)
70. Suppose a business with annual sales revenue of $30 million wishes to use an ERP solution. Which ERP vendor will have the most appropriate solution for them? a. Tier I vendors such as SAP or Oracle. b. Tier II vendors such as Epicor or Lawson. c. Tier III vendors such as Abas or Bluebee software. d. Vendors from all three tiers would be appropriate.
c. Tier III vendors such as Abas or Bluebee software.
49. Which of the following is NOTa key capability of BI tools? a. ability to create graphs of results b. ability to zoom in to view various levels of details c. ability to provide advice to the user on which model best suits the data d. ability tolink disparate data to gain various levels of insights
c. ability to provide advice to the user on which model best suits the data
38. Java allows small programs, called _____, to be embedded with an Hypertext Markup Language (HTML) document. a. cookies b. subroutines c. applets d. packets
c. applets
62. In the context of enterprise resource planning (ERP) systems, the most efficient and effective ways to complete a business process are called _____. a. current approaches b. streamlined processes c. best practices d. process improvements
c. best practices
31. The smallest piece of data used by a computer is a(n) _____. a. entity b. byte c. bit d. character
c. bit
42. A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database. a. data dictionary b. schema c. data definition language d. data manipulation language
c. data definition language
48. A _____ is a subset of a data warehouse that is used by small- and medium-sized businesses and departments within large companies to support decision making. a. data dictionary b. data model c. data mart d. data mine
c. data mart
39. The elimination of organizations that operate between the producer and the consumer is called _____. a. market segmentation b. downsizing c. disintermediation d. personalization
c. disintermediation
67. A customer relationship management (CRM) system helps a company in managing ______. a. material sourcing and procurement b. product development and manufacturing c. distribution and accounting d. human resources and finance
c. distribution and accounting
71. Suppose a small business is using the hosted model for its enterprise software. Which of the following will not be an issue they will be worried about? a. promoting and selling their products and services b. managing the hiring processes c. employing full-time IT professionals to manage its resources d. designing of their products and services
c. employing full-time IT professionals to manage its resources
72. Tom's Art Supplies used to sell art supplies through mail order catalogs, but the company's order takers often had difficulty deciphering their customers' handwriting on the order forms. Since switching to an online e-commerce site, Tom's has been able to solve this problem, allowing the company to enjoy the advantage of: a. reaching new customers b. reducing costs c. increasing accuracy d. improving customer service
c. increasing accuracy
58. In the context of purchasing systems involved in the traditional transaction processing systems, when a(n) _____ arrives from a supplier, it is matched to the original order and the receiving report, and a check is generated if all data is complete and consistent. a. order b. pick list c. invoice d. request for quotation
c. invoice
65. A key feature of an enterprise system is that _________. a. it helps a business function isolate information other functions and other levels of management. b. It is exclusive to small and medium-sized enterprises (SMEs) c. it employs a database of key operational and planning data that can be shared by all d. it is only used by large organizations
c. it employs a database of key operational and planning data that can be shared by all
45. A _____ satellite system employs many satellites that are spaced so that, from any point on the Earth at any time, at least one satellite is on a line of sight, each in an orbit at an altitude of less than 1,000 miles. a. very small aperture terminal (VSAT) b. microwave c. low earth orbit (LEO) d. geostationary
c. low earth orbit (LEO)
34. A(n) _____ is a field or set of fields in a record that uniquely identifies the record. a. attribute b. entity c. primary key d. data item
c. primary key
34. Which of the following is NOTa core process associated with data management? a. process for obtaining data b. process for certifying it fit for use c. process for gathering BI requirements d. process for storage
c. process for gathering BI requirements
37. The action of including only some columns for output while retrieving data is known as ____. a. selecting b. joining c. projecting d. linking
c. projecting
38. Which of the following is NOTtrue about linear regression? a. both of the variables must be quantitative variables b. the line minimizes the sum of the squared errors of prediction c. the technique implies causality between the independent and the dependent variables d. consists of finding the best-fitting straight line through a set of observations
c. the technique implies causality between the independent and the dependent variables
53. The information about invoices to customers is tracked by ____ system. a. supply chain management b. product lifecycle management c. transaction processing system d. value chain system
c. transaction processing system
38. Which of the following forms of e-commerce is more likely to offer a more customized product offering? a. Business-to-government (B2G) e-commerce b. Business-to-business (B2B) e-commerce c. Consumer-to-consumer (C2C) e-commerce d. Business-to-consumer (B2C) e-commerce
d. Business-to-consumer (B2C) e-commerce
46. The ______ is a security technique associated with the use of credit cards at the time of purchase that checks additional digits printed on the back of the credit cards. a. Address Verification System b. Advanced Authorization c. Payment Card Industry security standard d. Card Verification Number
d. Card Verification Number
34. _____ refers to a computing environment where software and storage are provided as an Internet service and accessed with a Web browser. a. Grid computing b. Distributed computing c. Utility computing d. Cloud computing
d. Cloud computing
40. _____ is a subset of e-commerce that involves electronic transactions between consumers using a third party to facilitate the process. a. Business-to-business (B2B) e-commerce b. Business-to-consumer (B2C) e-commerce c. Consumer-to-business (C2B) e-commerce d. Consumer-to-consumer (C2C) e-commerce
d. Consumer-to-consumer (C2C) e-commerce
47. Suppose you have access to quantitative data on populations by ZIP code and crime rates. You wish to determine if there is a relationship between the two variables and display the results in a graph. Which BI tool will be most useful? a. Word cloud tool b. Querying tool c. Reporting tool d. Data visualization tool
d. Data visualization tool
45. ____ is the last phase of the six-phase CRISP-DM method. a. Evaluation b. Modeling c. Business understanding d. Deployment
d. Deployment
32. Mastery over which subject is NOTrequired for being a data scientist? a. Computer science b. Mathematics c. Statistics d. English
d. English
51. Which of the following systems can help identify your geolocation? a. Geographic information systems b. Extranets c. VPNs d. GPS
d. GPS
35. _____ is the standard page description language for Web pages. a. Extensible Markup Language (XML) b. JavaScript c. .NET d. Hypertext Markup Language (HTML)
d. Hypertext Markup Language (HTML)
56. Which of the following types of processing is essential for businesses that require access to current data such as airlines, ticket agencies, and stock investment firms? a. Batch processing b. Multiple unit processing c. Business intelligence processing d. Online transaction processing
d. Online transaction processing
47. _____ is a standard that spells out measures and security procedures to safeguard a card issuer, a cardholder, and a merchant. a. Secure Sockets Layer (SSL) b. Card Verification Number c. Virtual private network (VPN) d. Payment Card Industry (PCI)
d. Payment Card Industry (PCI)
57. Which of the following transactions definitely require online transaction processing and cannot work on batch processing approach? a. Payroll b. Vendor payments c. Customer billing d. Stock investments
d. Stock investments
66. _____includes the planning, executing, and controlling of all activities involved in raw material sourcing and procurement, converting raw materials to finished products, and the warehousing and delivering finished product to customers. a. Maintenance, repair and operations (MRO) b. Materials requirement planning (MRP) c. Customer relationship management (CRM) d. Supply chain management (SCM)
d. Supply chain management (SCM)
28. Which of the following is NOTconsidered business intelligence practice? a. Data extraction b. Visualization c. Analysis d. Transaction processing
d. Transaction processing
75. Which of the following is an obstacle to the successful implementation of a new enterprise system? a. cost and long time frame b. employees' fear of change and frustration with new systems c. integration with other systems d. all of these answers
d. all of these answers
51. Through e-government, _____. a. only government agencies can interact with one another b. only businesses can interact with the government c. only individual citizens can interact with the government d. any government unit, business or individual can interact with the government
d. any government unit, business or individual can interact with the government
44. During modeling of the CRISP-DM method, we would ______. a. clarify business goals for the data mining project b. select a subset of data to be used and prepare it c. assess if the model achieves business goals d. apply selected modeling techniques
d. apply selected modeling techniques
57. Which of the following is NOT a commonly used BI tool? a. data visualization b. linear regression c. drill-down analysis d. automated customer service
d. automated customer service
63. Payroll transactions and billing are typically done via _____. a. grid processing b. online transaction processing (OLTP) c. online analytical processing (OLAP) d. batch processing
d. batch processing
54. With _____, business transactions are accumulated over a period of time for processing in a single unit. a. online transaction processing systems b. real-time transaction processing systems c. on-demand processing systems d. batch processing systems
d. batch processing systems
30. Which of the following is NOT a characteristic of a data scientist? a. strong business acumen b. a deep understanding of analytics c. a healthy appreciation of the limitations of their data d. business leadership skills
d. business leadership skills
49. Authentication technologies are used by many organizations to _____. a. verify the accuracy of their product descriptions and prices b. secure sensitive data during e-commerce c. confirm the uniform resource locator (URL) of their suppliers' Websites d. confirm the identity of a user requesting access to information or assets
d. confirm the identity of a user requesting access to information or assets
51. To ensure reliability and integrity, SQL databases conform to four specific properties. Which of the following is NOTone of those four properties? a. atomicity b. durability c. isolation d. currency
d. currency
36. Each attribute in a relational database model can be constrained to a range of allowable values called a _____. a. bandwidth b. scope c. slot d. domain
d. domain
32. A database is a collection of integrated and related _____. a. fields b. attributes c. records d. files
d. files
36. Which of the following is NOT a component of a KPI (key performance indicator)? a. direction b. measure c. time frame d. format
d. format
51. What determines the size of words in a word cloud? a. length of the word or phrase b. difficulty in pronouncing the word or phrase c. whether the word is a pronoun d. frequency of occurrence of the word in source documents
d. frequency of occurrence of the word in source documents
30. Which of the following statements is true of a database? a. It is accessed primarily for use by an organization's database administrator and data administrator. b. It provides an essential foundation for an organization's knowledge management and artificial intelligence systems. c. It is a collection of unstructured data. d. It helps companies analyze information to open new market opportunities.
d. it helps companies analyze information to open new market opportunities.
38. For the ____ operation, it is required that the the two tables have a common attribute. a. delete b. select c. project d. join
d. join
41. A reason for the growth in business-to-consumer (B2C) e-commerce is that online B2C shoppers have the ability to design a _____ product. a. standardized b. universal c. generic d. personalized
d. personalized
74. You have been put in charge of implementing a new enterprise system. You should do all of the following EXCEPT: a. allow sufficient time to transition from the old way of doing things to the new system and processes. b. allocate sufficient time and money for training staff. c. define metrics that you'll use to assess project progress and identify project-related risks. d. provide access to the new system only to your immediate team to avoid conflict and confusion.
d. provide access to the new system only to your immediate team to avoid conflict and confusion.
39. A _____ is a valuable tool that enables a user to find information on the Web by specifying words or phrases known as keywords, which are related to a topic of interest. a. cookie b. server c. Web portal d. search engine
d. search engine
46. A _____ network is one in which all network devices are connected to one another through a single central device called the hub node. a. mesh b. personal c. bus d. star
d. star
45. The number of mobile Websites worldwide is expected to grow rapidly because of ______________. a. the availability of more costly handsets b. typically uniform product offerings c. advances in artificial intelligence technologies d. the development of new and useful applications
d. the development of new and useful applications
