You are measuring how much a child has grown over the past year and would like to express that using a percentage. What calculation is most appropriate?
Correct Answer: A
Question 57
Which of the following would a data analyst look for first if 100% participation is needed on survey results?
Correct Answer: A
Missing data is a type of data quality issue that occurs when some values in a data set are not recorded or available. Missing data can affect the validity and reliability of survey results, especially if the missing values are not random or ignorable. Missing data can also reduce the sample size and the statistical power of the analysis12 If 100% participation is needed on survey results, a data analyst would look for missing data first, because missing data would indicate that some participants did not complete or submit the survey, or that some responses were not recorded or transmitted correctly. A data analyst would need to identify the causes and patterns of missing data, and apply appropriate methods to handle or prevent missing data, such as imputation, deletion, weighting, or follow-up12
Question 58
A data analyst reviews the following data set: Which of the following is the range value?
Correct Answer: D
Question 59
Given the image below: Which of the following file formats is depicted?
Correct Answer: A
The image depicts a snippet of code in the JSON format, which stands for JavaScript Object Notation. JSON is a lightweight data-interchange format that is easy for humans to read and write and easy for machines to parse and generate. It is based on a subset of the JavaScript Programming Language and is commonly used to transmit data in web applications. * CSV, or Comma-Separated Values, is a simple file format used to store tabular data, such as a spreadsheet or database. It uses commas to separate values. * XML, or eXtensible Markup Language, is a markup language that defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. * HTML, or HyperText Markup Language, is the standard markup language for documents designed to be displayed in a web browser. References: * JSON.org - Introducing JSON1 * W3Schools - JSON Introduction2 * Mozilla Developer Network - JSON3
Question 60
Joe. an analyst. tests the loading time on a dashboard he is preparing to go live and finds it is slower than he would like. Which of the following must occur to decrease the loading time?
Correct Answer: D
Optimizing the dashboard is the process of improving its performance and reducing its loading time by applying various techniques and best practices. Some of the common ways to optimize a dashboard are: Reducing the size and complexity of the data model, such as removing unnecessary columns, aggregating data at the source, or using data compression techniques12 Leveraging caching strategies, such as setting appropriate cache refresh intervals or utilizing Power BI's built-in caching mechanisms, to minimize data retrieval delays2 Utilizing query folding, direct query, or live connection to enhance data processing efficiency and enable real-time data updates23 Optimizing DAX queries, such as avoiding nested calculations, using variables, or simplifying measures, to improve data calculation speed23 Reducing visualizations and calculations, such as using fewer or simpler charts, filters, or parameters, to speed up dashboard rendering12 Evaluating the impact of custom visuals on dashboard load time and avoiding or replacing those that are slow or inefficient2 Applying aggregation and summarization techniques, such as using extract filters, context filters, or level of detail expressions, to reduce the amount of data displayed on the dashboard1 Troubleshooting and resolving any issues that may cause slow dashboard load, such as network latency, server overload, or hardware limitations24
