IT Specialist : Data Analytics Practice Exam 1. What is an example of data cleaning? A. Removing non-printable characters from a comma-delimited file. B. Adding quotation marks to the beginning and end of a tab-delimited file. C. Arranging Excel data rows in an order that is easy for a user to read D. Ensuring that the data in a Word table uses a consistent font 2. What is one goal of data privacy and protection laws such as GDPR, FERPA, and HIPAA? A. To hold violators accountable for mishandling data B. To tax companies that use private data C. To ensure that companies openly share industry data D. To protect companies from liability related to private data 3. You want to show a friend your monthly budget breakdown to prove that most of your expenditure is food costs. You create a table that shows the flow of money as it moves one budget category to the next. Which visualization type should you use to display your analysis based on the table shown? A. Sankey diagram B. Correlation matrix C. Time series chart D. Classification tree 4. You have a comma-delimited file with 100,000 rows and 200 columns of phone sales data One column represents the phone manufacturer. You need to analyze all sales data for a specific manufacturer. Which technique should you use? A. Deleting B. Filtering C. Truncating D. Transposing 5. You work for a recreational sports company. The table shows the company's recreational vehicle sales. You need to show how each vehicle type contributes to the company's total sales. Which visualization should you use? Select the correct visualization in the answer area. A. Line Chart B. Scatter Chart C. Pie Chart D. Bar Chart 6. Which data structure describes the following data? ["Aabid", "Jesenia", "Mark"] A. Multi-dimensional array B. List C. Table D. Graph 7. You have a small dataset that contains personally identifiable information (PII). You need to provide the data to an outside source for additional processing. What could you do to protect them back after the new dataset is retrieved? 8. You have a small dataset that contains personally identifiable information (PII). You need to provide the data to an outside source for additional processing. What could you do to protect the PII but still allow you to eventually relate the additional analysis to your original data? A. Retain every text-based Pll in the original dataset but convert them to numberbased features in the new dataset. B. Remove every instance of Pll in the original dataset and add them back after the new dataset is retrieved C. Employ pseudonymization on the PII and use the pseudonym as the key between the new and original datasets D. Randomly shuffle the original dataset so that each given piece of Pil is no longer associated with a particular user 9. A popular social media site records and counts clicks, likes, and dislikes, and other user interactions. 10. What type of data is collected? A. Qualitative data B. Imputed data C. Continuous data D. Big data