16 Practice Exam One Flashcards
What does a practice exam provide?
A good idea of what material you know well and what material you may need to review.
It simulates the experience of taking the actual exam.
What is the average time per question in a 90-minute exam with 90 questions?
1 question per minute.
This requires efficient time management during the exam.
Which option would be most appropriate for delivering a dashboard only once on a specific date?
D. Scheduled delivery
A schema with denormalized tables is what type of schema?
C. Star schema
What is the result of a right join on two tables?
Includes all records from the right table and matched records from the left, filling with NULLs where no match exists.
This is typical behavior of right joins in SQL.
What represents the count of observations that falls into each category?
D. Frequency
Forecasting falls into what general type of analysis?
D. Trend analysis
Which analytical tool is considered a programming language?
B. Python
A person’s credit card information is considered what type of protected data?
C. PCI
What type of report is most appropriate to determine the relationship between an employee’s height and productivity?
D. An ad hoc report
Which of the following contains the true mean?
A. The confidence interval
When creating a new dashboard, what should be done first?
D. Create a mockup/wireframe
What visualization is appropriate for showing revenue from each division and department?
C. A stacked bar chart
What does updating a table by adding new values to the bottom exemplify?
D. Active record
What type of error does a dataset with incorrect formatting represent?
D. Invalid data
What type of visualization is best for explaining complicated relationships to a non-technical audience?
C. Infographic
What does ETL stand for?
B. Extract, transform, load
Which section of a data use agreement includes information on what happens if consent is withdrawn?
C. Data deletion
Which schema is most appropriate for a database requiring the fewest number of joins?
B. A star schema
What type of data error is characterized by having the same information recorded multiple times?
A. Duplicate data
When checking for data quality, which factor is important?
C. Data accuracy
What data validation approach should be taken to see if analysis results can be generalized?
D. Cross-validation
What type of analysis gives basic information about the shape and structure of data?
C. Exploratory data analysis
What is the alternative hypothesis when comparing two product designs?
B. There is a significant difference between Design A and Design B