Database - Database Processing for BIS MCQs Part

1. A BI reporting system does not ________ .

A.
create meaningful information
B.
deliver information to users on a timely basis
C.
use statistical procedures to predict future events
D.
use disparate data sources

 Answer Option C

2. Which of the following are not done by Business Intelligence (BI) systems?

A.
Analyze past and current activities only
B.
Process and record transactions only
C.
Both of the above are correct.
D.
Neither of the above is correct.

 Answer Option B

3. Business Intelligence (BI) systems do not obtain their data by which of the following means?

A.
Read and process data from an operational database
B.
Process transactions
C.
Process extracts from operational databases
D.
Process data purchased from data vendors

 Answer Option B

4. The "curse of dimensionality" relates to which problem of using operational data for BI reporting?

A.
Dirty data
B.
Inconsistent data
C.
Too much data
D.
Non-integrated data

 Answer Option C

5. A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?

A.
Push
B.
Pull
C.
RFM
D.
OLAP

 Answer Option B

6. RFM analysis uses customers' purchasing patterns to ________ .

A. record transactions
B. analyze and rank customers
C. predict future sales using regression techniques
D. perform OLAP

 Answer Option B

7. The "F" in RFM analysis stands for ________ .

A. frequently
B. freshness
C. fast food
D. fantasy

 Answer Option A

8. We have Market Basket data for 1,000 rental transactions at a Video Store. There are for videos for rent -- Video A, Video B, Video C and Video D. The probability that both Video C and Video D are rented at the same time is known as ________ .

A. the basic probability
B. support
C. lift
D. confidence

 Answer Option B

9. Business Intelligence (BI) reporting systems cannot do which of the following operations?

A. Filter data
B. Group data
C. Modify data
D. Both filter and group data

 Answer Option C

10. Which of the following is not a component of a data warehouse?

A. Data extraction/cleaning/preparation programs
B. Data warehouse data
C. Data metadata
D. None of the above are data warehouse components.

 Answer Option C

11. Business Intelligence (BI) reporting analyses can be performed using ________ .

A. standard SQL only
B. extensions to SQL only
C. OLAP only
D. both standard SQL and extensions to SQL

 Answer Option A

12. We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .

A. dirty data
B. inconsistent data
C. non-integrated data
D. a "wrong format" problem

 Answer Option C

13. The reports generated by a reporting system are usually not delivered in which of the following media?

A. Web portal
B. Commercial courier service
C. Digital dashboard
D. E-Mail

 Answer Option B

14. Data mining applications are used accomplish which of the following tasks?

A. Process transactions only
B. Do RFM analysis only
C. Do what-if analysis only
D. Do both RFM and what-if analysis

 Answer Option C

15. Which of the following is an unsupervised data mining technique?

A. Cluster analysis only
B. Regression Analysis only
C. RFM Analysis only
D. Both Regression Analysis and RFM Analysis

 Answer Option A

16. In OLAP, we are interested in ________ .

A. levels only
B. dimensions only
C. measures only
D. measures and dimensions

 Answer Option D

17. Which of the following is not a reason that operational data are difficult to read?

A. Non-duplicated data
B. Dirty data
C. Missing values
D. Non-integrated data

 Answer Option A

18. We have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent -- Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ .

A. the basic probability
B. support
C. lift
D. confidence

 Answer Option D

19. One popular classification technique in Business Intelligence (BI) reporting is ________ .

A. cluster analysis only
B. regression analysis only
C. RFM analysis only
D. both cluster analysis and regression analysis

 Answer Option C

20. We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .

A. Has ordered recently, orders frequently, and places a large order when she orders.
B. Hasn't ordered recently, orders infrequently, but places a large order when she orders.
C. Has ordered recently, orders frequently, but doesn't place a large order when she orders
D. Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders.

 Answer Option C

6. RFM analysis uses customers' purchasing patterns to ________ .

A. record transactions
B. analyze and rank customers
C. predict future sales using regression techniques
D. perform OLAP

 Answer Option B

7. The "F" in RFM analysis stands for ________ .

A. frequently
B. freshness
C. fast food
D. fantasy

 Answer Option A

8. We have Market Basket data for 1,000 rental transactions at a Video Store. There are for videos for rent -- Video A, Video B, Video C and Video D. The probability that both Video C and Video D are rented at the same time is known as ________ .

A. the basic probability
B. support
C. lift
D. confidence

 Answer Option B

9. Business Intelligence (BI) reporting systems cannot do which of the following operations?

A. Filter data
B. Group data
C. Modify data
D. Both filter and group data

 Answer Option C

10. Which of the following is not a component of a data warehouse?

A. Data extraction/cleaning/preparation programs
B. Data warehouse data
C. Data metadata
D. None of the above are data warehouse components.

 Answer Option C

Comments

Post a Comment

Most Popular

Remove Unicode Zero Width Space PHP

✔ Recommended Answer This: $newBody = str_replace("​", "", $newBody); presumes the text is HTML entity encoded. This: $newBody = str_replace("\xE2\x80\x8C", "", $newBody); should work if the offending characters are not encoded, but matches the wrong character (0xe2808c). To match the same character as #8203; you need 0xe2808b: $newBody = str_replace("\xE2\x80\x8B", "", $newBody); Source: stackoverflow.com Answered By: Jef Method #2 To remove Unicode zero width space (ZWSP) from a string in PHP, you can use the str_replace() function to replace the ZWSP character with an empty string. Here's an example: php $str = "Hello​ World" ; // Contains ZWSP after "Hello" // Replace ZWSP with an empty string $str = str_replace ( "\u{200B}" , "" , $str ); echo $str ; // Outputs "Hello World" without ZWSP In this example, the str_replace() functi
Read more

PhpStorm, return value is expected to be 'A', 'object' returned

Image
✔ Recommended Answer Has to be because object can be ANY class instance, even B etc. You can annotate the create() method with generics PHPDoc to tell that the return type will be the same as the input parameter class string. It gives more context info to the IDE. /** * @template T * * @param string $class * @return T */ private function create(string $class) : object { return new $class(); } P.S. Instead of create('B'); better use create(B::class) . This way the IDE can track the usages of that class for refactoring/search purposes etc. Source: stackoverflow.com Answered By: LazyOne Method #2 This error message suggests that your code is expecting a value of type 'A' to be returned, but instead, the code is returning an object. This error can occur in PhpStorm, or any other PHP development environment. To resolve this error, you should check the function or method that is returning the object and ensure that it is returning
Read more

Laravel file upload returns forbidden 403, file permission is 700 not 755

✔ Recommended Answer The issue you are facing could be due to incorrect file permissions for the storage folder. Here are some steps to fix the problem: SSH into your cPanel server. Change the permission of the storage folder to 755: chmod -R 755 storage/ This command will change the permission of the storage folder and all its contents to 755, which should give the web server permission to read and write to the folder. Check the ownership of the storage folder. Ensure that the owner of the folder is the same as the user running the web server (typically www-data on Apache): ls -l This command will list the files and folders in the current directory along with their ownership and permission details. Make sure that the owner of the storage folder is the same as the user running the web server. If the ownership is incorrect, you can change it using the following command: chown -R www-data:www-data storage/ This command will change the ownership of the storage folder and all its conten
Read more