BCS Data Analysis Concepts/100% ACCURATE

Document Content and Description Below

Which of the following include proprietary data? a) Internally generated documents relating to an organisation's research and development activities. b) Documents published on an organisation's we... bsite describing its product and services. c) Internally generated documents that are made freely available to the public. d) Documents an organisation wishes to keep confidential. A a and d only. B b and c only. C a, b and c only. D b, c and d only. - ANS -A Proprietary data is internally generated data or documents that contain technical or other types of information controlled by a firm to safeguard its competitive edge. It may be protected under copyright or trade secret laws. An analyst is working with data provided by their organisation's purchasing department, which contains workforce expenditure and is confidential. It has been provided so that workforce costs can be analysed. What sort of data has the analyst been provided with? A Operational. B Obsolete. C Sensory. D Public. - ANS -A Operational data includes internal control and operational environment information such as data on the company's workforce, direct competitors, creditors, suppliers and information on customers. Which of the following CORRECTLY describes open data? A Any data that is held in the public domain. B Data that can be freely used, reused and redistributed. C Data that is recorded and retained by the scientific community. D Data that is obtained from collaboration between organisations. - ANS -B Open data is information that can be freely used, reused and redistributed by anyone with no existing local, national or international legal restrictions on access or usage. Put the following steps involved in the ETL process in the CORRECT order. a) Create the mapping. b) Define the source. c) Create the session. d) Define the target. e) Create the work flow. A c, e, a, b, d. B b, d, a, c, e. C a, c, d, e, b. D d, b, a, c, e. - ANS -B This is a representation of the chronological order of the ETL (Extract, Transform and Load) process. An analyst with little or no knowledge of the industry they are working in could inadvertently lead their organisation astray. Which of the following would help the analyst avoid this? a) Questioning the source and meaning of every data item before including it. b) Employing predictive analysis tools at random stages of the analysis. c) Assuming analysis techniques used in other industries are always applicable. A a only. B b and c only. C a and c. D b only. - ANS -A Predictive tools do not provide the actual outcome and other business knowledge will not provide key relevance and therefore accuracy. Which of the following is NOT a stage of the data lifecycle? A Migrated. B Created. C Archived. D Deleted. - ANS -A Migration does not feature in the data lifecycle. What is the following an example of? Acme Inc XYZ Ltd 1234.56 GBP A Extensible Markup Language. B Data Definition Language. C Entity-Relationship Model. D Unified Modelling Language. - ANS -A Extensible Markup Language (XML) is a common source of structured data. Recognising the way XML looks as it structures data allows a data analyst to understand how that data can be queried, transported, exported and more. Which of the following is NOT a common format for structured data? A Sequential data files, e.g. .CSV B Extensible markup records, e.g. .XML C Relational database tables, e.g. .Accdb D Data compression archives, e.g. .ZIP - ANS -D Structured data refers to any data that resides in a fixed field within a record or file. This includes data contained in relational databases and spreadsheets. Unstructured data formats are often layered within other formats. For example, plain text could be stored inside a document contained within a zip file. [Show More]

Last updated: 2 years ago

Preview 1 out of 5 pages