IT Exam Items Repository What is used to show how the tables in a database are related to one another?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhich SQL statement is used to filter data in a database?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhich commonly used SQL statement is necessary to retrieve data from one or more tables in a database?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhat is a flat file database?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsA data analyst wants to display outliers in the data set. Which type of visual representation would best suit this task?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsA data analyst wants to display the various segments of a country’s energy sources (e.g., oil, coal, gas, solar, wind) contributing to 100% of its energy sources in a visual format. What type of chart would be best used to accomplish this?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhy is regression analytics used in the inferential and machine learning analyses of big data?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhich type of inferential and machine learning analysis is used to find groups of observations that are similar to each other?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhy are different sampling techniques used to gather inferential statistical data?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsA data analyst wants to find data point values that are significantly different from others in a data set. What are these values called?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhich three key pieces of information are required to perform a VLOOKUP function in Microsoft Excel? (Choose three.)ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhat can a data analyst do if they wanted to remove duplicate values in a Microsoft Excel spreadsheet?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsHow is the Microsoft Excel VLOOKUP tool used in data analysis?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhat are inferential data sets?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsIn Microsoft Excel, what is a characteristic of an "absolute reference"?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics Essentials