IT Specialist : Data Analytics Practice Exam 1. Which two procedures describe best practices when minimizing the potential for misinterpretation of a data visualization? (Choose 2.) A. Significant numerical values should be explained in the footnotes rather than the data visualization or accompanying text B. Use a distinct color for each category presented in a data visualization C. Use a caption that helps to explain how to interpret the data visualization D. Size and scale should be distorted in a data visualization to support the author's perspective 2. You work for a lawn service company and are conducting a telephone survey to find out why customers no longer use the service. You are surveying a small number of customers. For each statement about small sample sizes, select Yes if it is true or No if it is false A. Small sample sizes are cost-effective. Answer:YES B. Small sample sizes result in faster delivery of results. Answer:YES C. Small sample sizes produce reliable results Answer:No 3. A website developer is creating a contact form for a local business. What type of variable should the developer use to store data entered into the name input field? A. Character B. String C. Integer D. Boolean 4. Which two types of hypotheses are considered in the statistical concept of Hypothesis Testing? A. Probable, Improbable B. Null, Alternative C. Correct, Incorrect D. Likely, Unlikely 5. Students conduct a survey about the transportation methods they use to get to school. They gather data and create a data visualization. Method of Transportation Bicycle Bus Car Walk Number of Student 99 196 27 58 Which question does this visualization answer? A. How many more students walk than drive? B. Do more students ride the bus in the fall? C. What is the distribution of students across the methods of transportation? D. Do a majority of students use one method of transportation? 6. For each statement, select Yes if it is an example of how machine learning is used in data analytics and No if it is not A. Turning off your ice maker after it produces 40 cubes of ice Answer:NO B. Declining financial purchases if unusual activity is detected Answer:YES C. Suggesting new products based on recently purchased products Answer:YES 7. What is metadata? A. Numerical facts B. Statistics C. The text content of a message D. A context that gives data meaning 8. Which data structure has multiple rows and multiple columns? A. One-dimensional array B. List C. Series D. Table 9. Which one is data granularity options? A. Years B. Months C. Weeks D. Days E. Hours 10. Each month, you need to automatically transform the data from two XML documents into a single flat file with columns and rows that Excel can open and interpret. The document names and structure remain constant. You know the relationships between the two XML documents Which two resources can you use? (Choose 2) Note. You will receive partial credit for each correct selection. A. Python B. Power Query for Excel (M) C. Microsoft Word D. JSON