Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

1) A common feature of a decision support system (DSS) is to perform _______ to

ID: 3590162 • Letter: 1

Question

1)

A common feature of a decision support system (DSS) is to perform _______ to examine alternative problem solutions.           

                correlation analysis

                association discovery

                what-if analysis

                competitive intelligence

                Web content mining

2)

Using a decision support system to determine market share is a(n) ____________ function.         

                production

                marketing

                human resources

                finance

                accounting

3)

To stay ahead of the competition, organizations have turned to _____________, using information systems to gather and analyze data and information from internal and external sources in order to make better business decisions.

                business applications

                transaction processing

                Web sites

                business intelligence

                e-commerce

4)

An example of a type of unstructured data is:     

                transaction data.

                sensor readings.

                customer comments posted on a social media site.

                clickstream data from a website.

                spreadsheets.

5)

A ______ is a software application with which you create, store, organize, and retrieve data from a single database or several databases.          

                transaction

                file

                network

                database management system

                application program

6)

The purpose of a key indicator report is to:          

                provide answers to unplanned questions.

                provide access to greater levels of detail.

                provide routine information at predefined intervals.

                provide a summary of critical information on a regular schedule.

                highlight situations that fall outside the expected normal range of values.

7)

A(n) ______ system uses reasoning methods based on knowledge about a specific problem domain in order to provide advice.

                OLAP

                expert

                competitive intelligence

                data mining

                decision support

8)

If your data needs exceed traditional RDBMSs and requires NoSQL, _______________ is considered a popular option.               

                DB2

                MySQL

                Oracle

                Hadoop

                SQL Server

9)

The type of data mining that is used to identify items that are frequently purchased together is called _________________ discovery.

                predictive

                intersection

                sequence

                class

                association

10)

Which of the following is NOT a key purpose of business analytics?           

                Understand the data.

                Predict business outcomes.

                Build explanatory models.

                Provide a detailed picture of the current state of a business.

                Identify trends

11)

The purpose of online analytical processing (OLAP) is to provide:

                expert decision making.

                complex multidimensional data analyses.

                predictive forecasts.

                simple data summaries.

                rapid posting of transaction data.

12)

A(n) _____________ is also known as an entity instance.              

                table

                cell

                record

                attribute

                column

13)

A key challenge of knowledge management systems is to identify and manage ______ knowledge assets and make them available to organization members.            

                explicit

                private

                tacit

                textual

                archival

14)

A key function of RDMBS is the ____________, which enables users to retrieve data from the database to answer questions.          

                data dictionary

                question

                table

                query

                form

15)

Today, organizations require a(n) _________ in order to monitor and analyze data and business processes, adjust business processes, and update organizational plans.      

                separate company

                budget plan

                random planning cycle

                annual strategic plan

                continuous planning process

16)

A(n) ______ is something you collect data about.             

                row

                entity

                table

                record

                column

17)

Which of the following statements about data marts is NOT true?             

                Data marts are considerably more expensive to develop than data warehouses.

                Data marts can be targeted to a specific group of end users.

                Data marts are often found in small and medium-sized businesses.

                A data mart is a smaller-scope data warehouse.

                Data marts can be implemented on simpler and less expensive hardware compared to data warehouses.

18)

_______ typically provide(s) push reporting, exception reporting, and pull reporting.       

                OLAP

                Intelligent agents

                Digital dashboards

                Web crawlers

                Neural networks

19)

The ________ database management system is capable of handling large volumes of unstructured data.

                MySQL

                NoSQL

                file-based

                client-based

                RDBMS

20)

The purpose of an OLAP cube is to:         

                allow data to be analyzed by multiple dimensions.

                record a sales transaction.

                facilitate e-commerce.

                analyze an expert's judgment.

                allow data to be analyzed on a single dimension.

21)

________________ algorithms search for hidden patterns in large volumes of data in order to develop predictive models.

                E-commerce

                RDBMS

                Data mining

                OLTP

                OLAP

22)

Which of the following is a limitation of relational database management systems (RDBMS)?       

                RDBMS data are stored in tables.

                RDBMS are not easily scalable in response to demand variations.

                RDBMS allows for inserting data.

                RDBMS support business processes.

                RDBMS allow for different data types.

23)

The purpose of a(n) ________ is to store and distribute valuable data from an organization's internal information systems and external sources for analysis and querying.

                data dictionary

                operational system

                transaction processing system

                data warehouse

                master file

24)

Which of the following is NOT a common purpose of a geographic information system?

                Locate target customers.

                Perform competitor analysis.

                Identify optimal product mixes at specific locations.

                Replicate an expert's judgment.

                Find optimal site locations.

25)

A key consideration related to business intelligence (BI) is that it focuses on ___________ data to aid in decision making.

                past

                redundant

                future

                aligned

                predictive

Explanation / Answer

1) what-if analysis

Explanation:A Decision support system possesses an interactive interface which makes it easier to use and provides real-time response to user queries and to perform what-if analysis

2)Marketing

Explanation:Marketing Decision Support Systems to determine market share is function.

3) Business Intelligence

Explanation:Using information systems to gather and analyze information from internal and external sources in order to make better business decisions.

4)spread sheets

Explanation:Examples of unstructured data include spreadsheet files, word processor documents, digital media files (such as audio and video)

5)Database management system

Explanation:A software application with which you create, store, organize, and retrieve data from a single database or several databases. Can manage hundreds or even thousands of tables simultaneously by linking the tables as a part of a single system.

6)provide a summary of critical information on a regular schedule.

Explanation:key indicator reports summarize the performance of critical activities.

7)Expert

Explanation:it uses reasoning methods based on knowledge about a specific problem domain in order to provide advice

9)association

Explanation:Associations are used in retail sales to identify patterns that are frequently purchased together.