SQL has been enhanced with extensions that support online analytical processing $($OLAP$).$ These extensions support data manipulations. Identify the extensions that will generate aggregates by different dimensions when used with the GROUP BY clause.

Group of answer choices

A$.$ CUBE

B$.$ GROUP BY

C$.$ ROLLUP

D$.$ SELECT

Flag this Question

Question $621$ pts

Which one of the following is an incorrect distinctive reporting style of business intelligence?

Group of answer choices

A$.$ Advanced data analytics

B$.$ Advanced reporting

C$.$ Data Manipulation

C$.$ Data Manipulation

Flag this Question

Question $631$ pts

From the following, identify a characteristic of online analytical processing $($OLAP$).$

Group of answer choices

A$.$ Provide advanced database support

B$.$ Provide complex user interfaces

C$.$ Uses one$-$dimensional data analytical techniques

D$.$ Does not to support client$/$user architecture

Flag this Question

Question $641$ pts

Key performance indicators are used to monitor business health in different industries. Select one that is not an example of a key performance indicator.

Group of answer choices

A$.$ Assets

B$.$ Economics

C$.$ Finance

D$.$ General

Flag this Question

Question $651$ pts

Improving decision making is the main goal of business intelligence. Select another benefit of business intelligence.

Group of answer choices

A$.$ Competitive customer support

B$.$ A different user interface for data analysis

C$.$ Increased employee and customer turnover

D$.$ Varied data repository fosters multiple versions of company data

Flag this Question

Question $661$ pts

What is not a benefit of cloud computing?

Group of answer choices

A$.$ Hidden costs of implementation and operation

B$.$ High reliability and performance

C$.$ Managed infrastructure

D$.$ Support for mobile computing

Flag this Question

Question $671$ pts

Which one of the following provides a description and representation of data on the web?

Group of answer choices

A$.$ Extensible mark$-$up language $($XML$)$

B$.$ Hypertext mark$-$up language $($HTML$)$

C$.$ Hypertext processor $($PHP$)$

D$.$ MySQL

Flag this Question

Question $681$ pts

Which one of the following is an application program interface that can be used to access the database?

Group of answer choices

A$.$ Data access objects

B$.$ Database driver

C$.$ Jet engine

D$.$ Microsoft Excel

Flag this Question

Question $691$ pts

In which part of the ADO.NET framework is data in the DataSet managed using various objects?

Group of answer choices

A$.$ Dataset

B$.$ DataTable

C$.$ DataReader

D$.$ DataAdapter

Flag this Question

Question $701$ pts

Which one of the following is an extensible mark$-$up language file?

Group of answer choices

A$.$ Productlist.xml

B$.$ Productlist.html

C$.$ Productlist.xm

D$.$ Productlist.mlx