Sem AIS 1-4
All of the following are examples of an unsupervised approach to evaluation data except: A) Similarity matching B) Clustering C) Profiling D) Co-occurrence grouping
A
At which step of the ETL process should you try to answer the question "What business problem will the data address?" A) Step 1: Determine the purpose and scope of the data request. B) Step 2: Obtain the data. C) Step 3 or 4: Transformation. D) Step 5: Loading the data for data analysis.
A
At which step of the ETL process should you try to answer the question "What other information will impact the nature, timing and extent of the data analysis?" A) Step 1: Determine the purpose and scope of the data request. B) Step 2: Obtain the data. C) Step 3 or 4: Transformation. D) Step 5: Loading the data for data analysis.
A
Comparing descriptive statistics for numeric fields within the data is an example of which of the following? A) Validating the data for completeness B) Validating the data for integrity C) Cleaning the data D) Obtaining the data
A
Data profiling is used to assess data quality and internal controls. It typically involves the following steps except: A) Filter the results. B) Identify the objects or activity you want to profile. C) Determine the types of profiling you want to perform. D) Set boundaries or thresholds for the activity.
A
Polar bears, brown bears, black bears, and panda bears would be best described as an example of: A) Nominal data B) Ordinal data C) Ratio data D) Interval data
A
Red, Yellow, and Blue would be best described as an example of: A) Nominal data B) Ordinal data C) Structured data D) Test data
A
Retail stores often request customers' zip codes at the end of a sales transaction. This is an example of which data approach? A) Clustering B) Regression C) Similarity matching D) Classification
A
The following are typical examples of nominal data except: A) Grade point average B) Zip codes C) Eye color D) Gender
A
The following are typical examples of ordinal data except: A) Distance B) Position in a race C) Hardness of a mineral D) Military rank
A
The following charts are frequently considered for depicting qualitative data except: A) Line chart B) Pie chart C) Bar chart D) Stacked bar chart
A
The purpose of transforming data is: A) To validate the data for completeness and integrity B) To load the data into the appropriate tool for analysis C) To identify and obtain the data from the appropriate source D) To identify which approach to data analytics should be used
A
When considering the color theme for a visualization, which is the best color theme for a color blind audience? A) orange/blue scale B) red/green scale C) gray scale D) red/blue scale
A
Which approach to data analytics attempts to assign each unit in a population into a small set of categories? A) Classification B) Regression C) Similarity matching D) Co-occurrence grouping
A
Which approach to data analytics attempts to divide individuals into groups in a useful or meaningful way? A) Clustering B) Data reduction C) Similarity matching D) Co-occurrence grouping
A
Which of the following best describes a dependent variable? A) Output B) Input C) Application D) Operation
A
Which of the following best describes the classification approach to data analytics? A) An attempt to assign each unit (or individual) in a population into a few categories. B) An attempt to identify similar individuals based on data known about them. C) An attempt to divide individuals into groups in a useful or meaningful way. D) An attempt to discover associations between individuals based on transactions involving them.
A
Which of the following best describes the data analytics skill of data quality? A) recognize what is meant by data quality, be it completeness, reliability or validity B) perform basic analysis to understand the quality of the underlying data and its ability to address the business question C) demonstrate the ability to sort, rearrange, merge, and reconfigure data in a manner that allows enhanced analysis D) comprehend the process needed to clean and prepare the data before analysis
A
Which of the following best describes the data analytics skill of developing an analytics mindset? A) recognize when and how data analytics can address business questions B) perform basic analysis to understand the quality of the underlying data and its ability to address the business question C) recognize what is meant by data quality, be it completeness, reliability or validity D) comprehend the process needed to clean and prepare the data before analysis
A
Which of the following best describes the purpose of a primary key? A) To ensure that each row in the table is unique B) To create the relationship between two tables C) To provide business information, but are not required to build a database D) To support business processes across the organization
A
Which of the following best exemplifies a way that data will need to be cleaned after extraction and validation? A) Remove headings and subtotals B) Validate date/time fields C) Remove trailing zeroes D) Compare string limits for text fields
A
Which of the following is most likely to be the primary key in an Employee table? A) Employee ID B) Employee Social Security Number C) Employee Name D) Employee Type
A
Which type of chart is best described as useful for identifying the correlation between two variables or for identifying a trend line or line of best fit? A) Scatter plots B) Box and whisker plots C) Line chart D) Pie chart
A
________ are the product of wanting to present findings to an audience. A) Declarative visualizations B) Static visualizations C) Exploratory visualizations D) Interactive visualizations
A
1st place, 2nd place, and 3rd place would be best described as an example of: A) Nominal data B) Ordinal data C) Structured data D) Interval data
B
All of the following are examples of a supervised approach to evaluation data except: A) Causal modeling B) Data reduction C) Link prediction D) Regression
B
At which step of the ETL process should you try to answer the question "What tools will be used to perform data analytic tests or procedures and why?" A) Step 1: Determine the purpose and scope of the data request. B) Step 2: Obtain the data. C) Step 3 or 4: Transformation. D) Step 5: Loading the data for data analysis.
B
At which step of the ETL process should you try to answer the question "Where are the data located in the financial or other related systems?" A) Step 1: Determine the purpose and scope of the data request. B) Step 2: Obtain the data. C) Step 3 or 4: Transformation. D) Step 5: Loading the data for data analysis.
B
Letter grades of A, B, and C would be best described as an example of: A) Nominal data B) Ordinal data C) Ratio data D) Interval data
B
Mastering the data can also be described via the ETL process. The ETL process stands for: A) Extract, total, and load data. B) Extract, transform, and load data. C) Enter, transform, and load data. D) Enter, total, and load data.
B
The 3 V's of describing Big Data include: Volume, Velocity, and _________. A) Variability B) Variety C) Verification D) Volatility
B
The following are typical examples of ordinal data except: A) Blood type B) Political affiliation C) Education level D) Letter grade
B
The following are typical examples of ratio data except: A) Currency B) Temperature C) Length D) Interval data
B
The following are typical examples of ratio data except: A) Weight B) Birth date C) Height D) Pulse rate
B
The purpose of loading data is: A) To validate the data for completeness and integrity B) To load the data into the appropriate tool for analysis C) To identify and obtain the data from the appropriate source D) To identify which approach to data analytics should be used
B
Validating date/time fields within the data is an example of which of the following? A) Validating the data for completeness B) Validating the data for integrity C) Cleaning the data D) Obtaining the data
B
Which approach to data analytics attempts to assign each unit (or individual) in a population into a few categories? A) Similarity matching. B) Classification. C) Data reduction. D) Regression
B
Which approach to data analytics attempts to characterize the typical behavior of an individual, group or population by generating summary statistics about the data? A) Similarity matching. B) Profiling. C) Data reduction. D) Regression.
B
Which approach to data analytics attempts to predict, for each unit, the numerical value of some variable? A) Classification B) Regression C) Similarity matching D) Link prediction
B
Which of the following best describes an independent variable? A) Output B) Input C) Application D) Operation
B
Which of the following best describes the data analytics skill of descriptive data analysis? A) recognize what is meant by data quality, be it completeness, reliability or validity B) perform basic analysis to understand the quality of the underlying data and its ability to address the business question C) demonstrate ability to sort, rearrange, merge, and reconfigure data in a manner that allows enhanced analysis D) comprehend the process needed to clean and prepare the data before analysis
B
Which of the following best describes the purpose of a foreign key? A) To ensure that each row in the table is unique B) To create the relationship between two tables C) To provide business information D) To support business processes across the organization
B
Which type of chart is best described as useful for when quartiles, median, and outliers are required for analysis and insights? A) Scatter plots B) Box and whisker plots C) Line chart D) Pie chart
B
________ is data that is represented by whole numbers. A) Continuous data B) Discrete data C) Interval data D) Ordinal data
B
________ is more complex than ________. A) Qualitative data; quantitative data B) Quantitative data; qualitative data C) Training data; test data D) Test data; training data
B
After completing your data analysis, the write-up should include a discussion of which of the following: A) Only the steps of the IMPACT model you consider important B) Only the steps of the IMPACT model your client will understand C) All steps of the IMPACT model D) All steps of the IMPACT model your client will understand
C
Correcting inconsistencies across data is an example of which of the following? A) Validating the data for completeness B) Validating the data for integrity C) Cleaning the data D) Obtaining the data
C
Formatting negative numbers in the data is an example of which of the following? A) Validating the Data for Completeness B) Validating the Data for Integrity C) Cleaning the Data D) Obtaining the Data
C
Latitude and longitude would be best described as an example of: A) Nominal data B) Ordinal data C) Ratio data D) Discrete data
C
Regression analysis typically involves the following steps except: A) Identify the variables that might predict an outcome. B) Identify the parameters of the model. C) Set boundaries or thresholds. D) Determine the functional form of the relationship.
C
Removing headings or subtotals from data is an example of which of the following? A) Validating the data for completeness B) Validating the data for integrity C) Cleaning the data D) Obtaining the data
C
Removing leading zeroes and non-printable characters from the data is an example of which of the following? A) Validating the data for completeness B) Validating the data for integrity C) Cleaning the data D) Obtaining the data
C
The impact cycle includes all the following processes except: A) Communicate insights. B) Perform test plan. C) Analyze the data. D) Track outcomes
C
The purpose of extracting data is: A) To validate the data for completeness and integrity B) To load the data into the appropriate tool for analysis C) To identify and obtain the data from the appropriate source D) To identify which approach to data analytics should be used
C
When using [EmployeeID] as the unique identifier of the Employee table, [EmployeeID] is an example of which of the following: A) Foreign key B) Composite key C) Primary key D) Key attribute
C
Which approach to data analytics attempts to characterize the typical behavior of an individual, group or population by generating summary statistics about the data? A) Classification B) Regression C) Profiling D) Link prediction
C
Which approach to data analytics attempts to reduce the amount of information that needs to be considered to focus on the most critical items? A) Similarity matching. B) Profiling. C) Data reduction. D) Regression.
C
Which of the following best describes a supervised approach to the evaluation of data? A) Data exploration that is free from oversight by a superior B) Data exploration that is conducted with direct oversight by a superior C) Data exploration that examines the relationships between variables that are hypothesized to exist D) Data exploration that looks for potential patterns of interest
C
Which of the following best describes an unsupervised approach to the evaluation of data? A) Data exploration that is free from oversight by a superior B) Data exploration that examines the relationships between variables that are hypothesized to exist C) Data exploration that looks for potential patterns of interest D) Data exploration that is conducted with direct oversight by a superior
C
Which of the following best describes the clustering approach to data analytics? A) An attempt to assign each unit (or individual) in a population into a few categories. B) An attempt to identify similar individuals based on data known about them. C) An attempt to divide individuals into groups in a useful or meaningful way. D) An attempt to discover associations between individuals based on transactions involving them.
C
Which of the following best describes the data analytics skill of data analysis through data manipulation? A) recognize what is meant by data quality, be it completeness, reliability or validity B) perform basic analysis to understand the quality of the underlying data and its ability to address the business question C) demonstrate the ability to sort, rearrange, merge, and reconfigure data in a manner that allows enhanced analysis D) comprehend the process needed to clean and prepare the data before analysis
C
Which of the following is not an example of continuous data? A) Meters swam in 25 minutes B) Miles run in 25 minutes C) Free throws made in 25 minutes D) Laps biked in 25 minutes
C
Which of the following is not an example of discrete data? A) Points earned in a basketball game B) Points earned in a hockey game C) Points earned in a diving match D) Points earned in a soccer game
C
While accountants don't need to become data scientists, they must know how to do the following except? A) Clearly articulate the business problem the company is facing B) Communicate with the data scientists about specific data needs and understand the underlying quality of the data C) Build a data repository D) Comprehend the process needed to clean and prepare the data before analysis
C
With a goal of giving organizations the information they need to make sound and timely business decisions, data analytics often involves all of the following except: A) technologies. B) statistics. C) growth. D) databases.
C
________ refers to data that is stored in a database or spreadsheet that is readily searchable. A) Training data B) Unstructured data C) Structured data D) Test data
C
All of the following are benefits of using a normalized relational database except: A) Completeness. B) No redundancy. C) Business rules are enforced. D) Data is stored in one place.
D
All of the following are included in the five steps of the ETL process except: A) Determine the purpose and scope of the data request B) Obtain the data C) Validate the data for completeness and integrity D) Scrub the data
D
Results using the Fahrenheit scale would be best described as an example of: A) Nominal data B) Ordinal data C) Ratio data D) Interval data
D
The following are characteristics of interval data except: A) Measured B) Ordered C) Equidistant D) Meaningful zero
D
The following are typical examples of interval data except: A) Time B) Temperature C) Standardized exam score D) Type of car owned
D
The following are typical examples of nominal data except: A) Hair color B) Eye color C) Gender D) Height
D
The following charts are frequently considered for depicting quantitative data except: A) Scatter plots B) Box plots C) Line chart D) Pie chart
D
The impact cycle includes all the following processes except: A) Identify the questions. B) Address and refine results. C) Communicate insights. D) Continuously track.
D
The impact cycle includes all the following processes except: A) Identify the questions. B) Address and refine results. C) Track outcomes. D) Predict the results.
D
There are a variety of methods that you could take to retrieve the data, including SQL. What does SQL stand for? A) Systems Query Language. B) Systems Question Language. C) Structured Question Language. D) Structured Query Language.
D
When obtaining the data yourself, you should do all of the following before you begin except: A) Identify the tables that contain the information you need. B) Identify which attributes specifically hold the information you need in each table. C) Identify how those tables are related to each other. D) Identify any errors or issues from the extraction
D
Which approach to data analytics attempts to estimate or predict, for each unit, the numerical value of some variable using some type of statistical model? A) Similarity matching. B) Classification. C) Data reduction. D) Regression.
D
Which approach to data analytics attempts to predict a relationship between two data items? A) Similarity matching. B) Clustering. C) Co-occurrence grouping. D) Link prediction
D
Which of the following best describes the co-occurrence grouping approach to data analytics? A) An attempt to characterize the typical behavior of an individual, group or population by generating summary statistics about the data. B) An attempt to predict a relationship between two data items. C) An attempt to reduce the amount of information that needs to be considered to focus on the most critical items. D) An attempt to discover associations between individuals based on transactions involving them.
D
Which of the following best describes the data analytics skill of data scrubbing and data preparation? A) recognize what is meant by data quality, be it completeness, reliability or validity B) perform basic analysis to understand the quality of the underlying data and its ability to address the business question C) demonstrate ability to sort, rearrange, merge and reconfigure data in a manner that allows enhanced analysis D) comprehend the process needed to clean and prepare the data before analysis
D
Which of the following best describes the data analytics skill of data visualization and data reporting? A) recognize when and how data analytics can address business questions B) perform basic analysis to understand the quality of the underlying data and its ability to address the business question C) recognize what is meant by data quality, be it completeness, reliability or validity D) report results of analysis in an accessible way to each varied decision maker and their specific needs
D
Which of the following best describes the data analytics skill of defining and addressing problems through statistical data analysis? A) recognize what is meant by data quality, be it completeness, reliability or validity B) perform basic analysis to understand the quality of the underlying data and its ability to address the business question C) demonstrate ability to sort, rearrange, merge and reconfigure data in a manner that allows enhanced analysis D) identify and implement an approach that will use statistical data analysis to draw conclusions and make recommendations on a timely basis
D
Which of the following best describes the purpose of relational databases? A) To ensure that business rules are enforced B) To increase information redundancy in the organization C) To provide business information to data analysts D) To support business processes across the organization
D
Which of the following is not one of the four main questions to consider when creating your data scale and increments? A) How much data should be displayed in the visualization? B) Should outliers be displayed? C) What scale should be used to display the data? D) Which colors should be displayed?
D
A foreign key is an attribute that exists in relational databases in order to carry out the relationship between two tables. TRUE FALSE
TRUE
Auditors can use social media to hear what customers are saying about a company and compare this to inventory obsolescence and other estimates. TRUE FALSE
TRUE
Data analytics allows auditors to glean insights that are beneficial to the client, without breaching independence. TRUE FALSE
TRUE
Data analytics is the process of evaluating data with the purpose of drawing conclusions to address business questions. TRUE FALSE
TRUE
Declarative visualizations are the product of wanting to 'declare' or present your findings to an audience. TRUE FALSE
TRUE
In order to obtain the right data, it is important to have a firm grasp of what data is available and how it is stored. TRUE FALSE
TRUE