Q&A Hero

Design

Q: Microsoft Access database objects are displayed in the ________. A) Navigation Pane B) Browser Pane C) Object Browser Pane D) Gallery Pane
Q: In addition to the standard Ribbon command tabs, Microsoft Access 2013 also includes ________. A) optional command tabs B) contextual command tabs C) quick access tabs D) gallery tabs
Q: The Microsoft Access 2013 Ribbon contains all of the following command tabs except ________. A) HOME B) SQL C) EXTERNAL DATA D) DATABASE TOOLS
Q: To start Microsoft Access 2013 in Windows 8, use the command ________. A) Start | Microsoft Access 2013 B) Start | Microsoft Office | Microsoft Access 2013 C) Start | All Programs | Microsoft Access 2013 D) No commanduse the Microsoft Access 2013 app tile
Q: The Microsoft Access data type of AutoNumber is used when there is a specific need for a ________. A) foreign key B) primary key C) surrogate key D) secondary key
Q: Microsoft Access 2013 database files are stored using the file extension of ________. A) .adb B) .asp C) .accdb D) .mdb
Q: The Microsoft Access application generator is not responsible for ________. A) creating forms B) creating reports C) creating queries D) creating tables
Q: Microsoft Access is a personal database system, and a personal database system is characterized by ________. A) the DBMS removing the metadata from the database B) the DBMS product taking the role of the DBMS and the database application generator C) the DBMS not supporting indexes D) the DBMS product being limited to a maximum of ten tables in any given database
Q: Microsoft Access wizards allow easy building of forms and reports.
Q: In Microsoft Access, the primary key must be set as a field property while the table is in Design View.
Q: To open a new Microsoft Access Query window, click the Query Design button on the Create command.
Q: Microsoft Access can run QBE queries, but not SQL queries.
Q: Microsoft Access SQL commands are run within the SQL View of a Query window.
Q: In Microsoft Access, a relationship is created by dragging a foreign key column and dropping it on top of the corresponding primary key.
Q: In Microsoft Access, foreign keys are designated by using the Foreign Key button in the toolbar.
Q: In Microsoft Access, relationships between tables are created in the Relationships window.
Q: The Microsoft Access window Close button is actually a close-and-exit button.
Q: Microsoft Access database objects are displayed in the Browser Pane.
Q: Microsoft uses the term object as a general name for various parts of a Microsoft Access 2013 database.
Q: In addition to the basic command tabs, Microsoft Access 2013 also has additional contextual command tabs.
Q: The default Microsoft Access 2013 command tabs are HOME, CREATE, INTERNAL DATA and DATABASE TOOLS.
Q: Each Microsoft Access 2013 command tab contains a set of tools grouped into sets of related commands.
Q: The Microsoft Access 2013 tabbed Ribbon contains a set of control tabs.
Q: Most Microsoft Access 2013 commands and tools are available on the tabbed Ribbon.
Q: Microsoft Access 2013 uses the Microsoft Office Fluent User Interface.
Q: To start Microsoft Access 2013 in Windows 8, use the Start | All Programs | Microsoft Office | Microsoft Access 2013 command.
Q: Microsoft Access uses the AutoNumber data type to create surrogate keys.
Q: Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format for database files.
Q: Microsoft Access 2013 databases are stored using the file extension .accdb.
Q: The Microsoft Access application generator provides the ability to create and store forms, reports, and queries.
Q: Microsoft Access is a personal database that combines a DBMS with an application generator.
Q: ____ can serve as a test vehicle for companies exploring the potential benefits of data warehouses.a. Data networks b. Data marts c. Data cubesd. OLAPs
Q: Data ____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.a. volatility b. time-variation c. subject-orientationd. integration
Q: In 2008, Wal-Mart, the world's largest company, had over four ____ of data in its data warehouses.a. megabytes b. gigabytes c. terabytesd. petabytes
Q: A characteristic of operational data is ____.a. summarized data b. hundreds of gigabytes c. high normalizationd. historic data
Q: A characteristic of decision support data is ____.a. high query activity b. high update volumes c. highly normalizedd. low aggregation level
Q: From the data analyst's point of view, decision support data differ from operational data in three main areas: time span, granularity, and ____.a. usability b. dimensionality c. transaction processingd. sparsity
Q: ____ systems provided no data extraction/integration process. a. Third-generation Mobile BI and cloud-based b. First-generation BI c. First-generation departmental decision support d. Traditional mainframe-based online transaction processing
Q: Had ____ been as pivotal to business operations a few years back, crises precipitated by the likes of Enron, WorldCom, and Arthur Andersen might have been avoided.a. OLAP b. data mining c. governanced. networking
Q: BusinessObjects is a(n) ____ tool.a. OLAP b. data visualization c. data miningd. data warehouse
Q: Data is captured from the OLTP system and placed on the ____ on a near-real time basis.a. decision support system b. portal c. data warehoused. dashboard
Q: ____provide a unified, single point of entry for information distribution.a. Decision support systems b. Portals c. Data warehousesd. Dashboards
Q: ____ are in charge of presenting the data to the end user in a variety of ways.a. Data stores b. ETL tools c. Data visualization toolsd. Data analysis tools
Q: The ____ contains business data extracted from the operational database and from external data sources.a. data store b. ETL tools c. data visualization toold. data analysis tool
Q: ____'s main goal is to provide a comprehensive and consistent definition of all data within an organization.a. DBMS b. OLAP c. Data warehousingd. MDM
Q: A data mart is part of the "____" section of the business intelligence framework.a. People b. Management c. Processesd. Governance
Q: Data mining is part of the "____" section of the business intelligence framework.a. People b. Management c. Processesd. Governance
Q: Analyzing decision support data to generate information is part of ____.a. data warehousing b. very large database systems c. business intelligenced. distributed processing
Q: Implementing BI in an organization involves capturing not only business data (internal and external) but also the ____.a. metadatab. facts c. informationd. rules
Q: ROLAP and MOLAP vendors are working toward the integration of their respective solutions within a unified decision support framework.
Q: Because a data cube's dimensions are predefined, all cells are populated.
Q: MOLAP is a logical choice for companies that already use relational databases for their operational data.
Q: The star schema is designed to optimize data query operations rather than data update operations.
Q: To provide better performance, some OLAP systems merge the data warehouse and data mart approaches by storing small extracts of the data warehouse at end-user workstations.
Q: In most implementations, the data warehouse and OLAP are stand-alone, independent environments.
Q: The mainframe environment enables an OLAP system to be divided into several components that define its architecture.
Q: Multidimensional data analysis techniques include advanced computational functions.
Q: In the prognosis phase, the data-mining findings are used to predict future behavior and forecast business outcomes.
Q: It is a relatively easy task to provide a precise list of characteristics of data-mining tools.
Q: Periodicity, usually expressed as current year only, previous years, or all years, provides information about the time span of the data stored in the table.
Q: Normalizing fact tables improves data access performance and saves data storage space.
Q: Data warehouses usually have one fact table.
Q: The data warehouse designer must define common business dimensions that will be used by the data analyst to narrow a search, group information, or describe attributes.
Q: Facts can be computed or derived at run time.
Q: The data warehouse development life cycle differs from classical systems development.
Q: Creating a data warehouse is a simple exercise that takes little time, money, or effort.
Q: Once data enter the data warehouse, they are never removed.
Q: Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.
Q: The decision support database query optimizer must be enhanced to support non-normalized structures.
Q: Queries against operational data typically are broad in scope and high in complexity.
Q: Decision support data are a snapshot of the operational data at a given point in time.
Q: Operational data and decision support data serve the same purpose.
Q: To tie a KPI to the strategic master plan of an organization, a KPI will be compared to a desired goal within a specific time frame.
Q: SAP is a portal vendor.
Q: MDM's main goal is to provide a partial and segmented definition of all data within an organization.
Q: A data store is used by the data analyst to create the queries that access the database.
Q: The BI architecture is composed of data, people, processes, technology, and the management of such components.
Q: Monitoring results to evaluate outcomes of the business decisions is outside the scope of BI.
Q: BI is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom.
Q: What is the ROLLUP extension to the GROUP BY clause? Provide the syntax for this extension.
1 2 3 … 68

Subjects

Accounting Anthropology Archaeology Art History Banking Biology & Life Science Business Business Communication Business Development Business Ethics Business Law Chemistry Communication Computer Science Counseling Criminal Law Curriculum & Instruction Design Earth Science Economic Education Engineering Finance History & Theory Humanities Human Resource International Business Investments & Securities Journalism Law Management Marketing Medicine Medicine & Health Science Nursing Philosophy Physic Psychology Real Estate Science Social Science Sociology Special Education Speech Visual Arts