BCS Tools Practice Paper

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Specimen paper only 20 multiple-choice questions – 1 mark awarded to each
question.

Mark only one answer to each question. There are no trick questions.

A number of possible answers are given for each question, indicated by either A. B. C. or
D.

Your answers should be clearly indicated on the answer sheet.

Pass mark is 13/20.

1. In a distribution that is positively skewed, which of the following is typically TRUE?

1 point

The standard deviation is greater than the range.

The median is greater than the mean.

The median and mean are equal.

The mean is greater than the median.

Clear selection

2. R can easily be extended via what?

1 point

Models

Slides

Packages

Pockets

Clear selection

3. What is the median in this set of data (1, 2, 2, 3, 5, 6, 9)?

1 point

Clear selection

4. What measure will always change if a single value in a dataset changes?

1 point

Median.

Mode.

Mean.

All of these.

Clear selection

5. What type of join is used to combine the result-set of two or more SELECT statements?

1 point

Full.

Outer.

Union.

Inner.

Clear selection

6. What will be reduced if multiple disparate datasets are integrated?

1 point

Data availability.

Data collaboration.

Data complexity.

Data integrity.

Clear selection

7. When preparing data for analysis to improve accuracy, quality and usefulness, which of the following are NOT suitable ways to respond to an error?

A) Accept; B) Correct Error; C) Ignore; D) Create null value

1 point

a and b only

b and c only

a and d only

c and d only

Clear selection

8. Which of the following describes managing an organisation’s critical data, providing a single point of reference?

1 point

Important Data Management

Master Data Management

Vital Data Management

Essential Data Management

Clear selection

9. Which command is used to select only one copy of each set of duplicate rows in SQL?

1 point

SELECT DIFFERENT

SELECT NONE

SELECT DISTINCT

SELECT ALL

Clear selection

10. Which of the following are data quality dimensions?

a) Uniqueness; b) Timeliness; c) Consistency; d) Cleanliness

1 point

a and b only

c and d only

a, b and c only

b, c and d only

Clear selection

11. Which of the following are user interfaces?

a) Data dashboard; b) Performance scoreboard; c) Data transparency; d) Dynamic charts

1 point

a and b only

c and d only

b, c and d only

a, b and d only

Clear selection

12. Which of the following is a monthly report, which uses dynamic charts and tables to summarise a company's sales turnover?

1 point

Dashboard.

Graph.

Screen.

Data.

Clear selection

13. Dates in a column of a spreadsheet are an example of which type of data?

1 point

Unstructured.

Semi-structured.

Structured.

Multi-structured.

Clear selection

14. Which of the following is NOT a core data type in Python?

1 point

Class.

Lists.

Dictionary.

Tuples.

Clear selection

15. Which of the following is NOT a reason for developing appropriate testing strategies? To ensure that unified data sets are...

1 point

Correct.

Complete.

Legal.

Up to date.

Clear selection

16. Which of the following is NOT a type of join?

1 point

Left.

Right.

Select into.

Insert into.

Clear selection

17. Which of the following is NOT an option to accomplish data migration?

1 point

Merge two systems into a brand new one.

Merge one system into another.

Remove one of two merged systems from another, without further action.

Create a common view on top of two separate systems.

Clear selection

18. Which SQL statement is often used with aggregate functions to assemble theresult-set by one or more columns?

1 point

Count

Order by

Group by

Round

Clear selection

19. Which technique can be used to unveil the content and structure of a data set?

1 point

Data modelling.

Data profiling.

Data processing.

Data describing.

Clear selection

20. Which testing process is used to validate the resource usage, scalability, and reliability of a product?

1 point

Owner acceptance testing.

Technical acceptance testing.

User acceptance testing.

Performance stress testing.

Clear selection

Submit

Clear form

Forms

This form was created inside of Multiverse.