Test Questions for Data Analysis (1).pdf

Test Questions for Data Analysis General Questions 1. One of the following is not part of aggregate functions: a. Sum b. Count c. Min d. Date 2. The primary goal of a data analyst is a. Design database b. Gathering dataset c....

Test Questions for Data Analysis General Questions 1. One of the following is not part of aggregate functions: a. Sum b. Count c. Min d. Date 2. The primary goal of a data analyst is a. Design database b. Gathering dataset c. Management of dataset d. Summarizing and interpreting data 3. the representation of data through the use of common graphics, such as charts, plots, infographics, and even animations is called a. Prediction b. Data visualization c. Data cleaning d. Data mining 4. the process of fixing or removing incorrect, corrupted, incorrectly formatted, duplicate, or incomplete data within a dataset is called a. Data cleaning b. Data mining c. Data visualization d. Data sourcing 5. Which of the following is quantitative data a. First name b. Surname c. Age d. Country 6. Microsoft products or software specifically meant for data cleaning are called a. Microsoft PowerPoint b. Power Query editor c. Microsoft Publisher d. Microsoft Project 7. Which of the following is not part of the measure of central tendency a. Standard deviation  b. Mean c. Median d. Mode 8. a branch of advanced analytics that makes predictions about future outcomes using historical data combined with statistical modeling, data mining techniques, and machine learning is called a. Descriptive analytics b. Prescriptive analytics c. Predictive Analytics d. Process Analytics 9. The following software is used in data analysis except a. Microsoft PowerBI b. Tableau c. Microsoft Excel d. Microsoft Word 10. What is the first step for a data analysis a. Gather data b. Conclude findings c. Preprocess and clean data d. Understand Problem Microsoft Excel 11. The intersection of row and column in Excel is called a. Sum b. Chart c. Worksheet d. Cell 12. A group of cells is called a. Cell range b. Cell cluster c. Cell chart d. Multicell 13. All formulas in Excel begin with the following symbol. a. = b. – c. +  d. * 14. Which of the below will add the value of B2 to the value of C3 a. =B+C b. =2B+3C c. =B2+C3 d. =B3+C2 Microsoft PowerBI 15. Which of the following is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data? a. Power query editor b. Pivot table c. Linear Regression d. Histogram 16. In Power BI, the BI is an acronym for: a. Business insight b. Business Investment c. Business Investigation d. Business Intelligence 17. The developers of Power BI is a. Salesforce b. Amazon c. Google d. Microsoft 18. In Power BI, DAX stands for a. Data analysis expression b. Data analysis expiration c. Data analysis extension d. Data analysis examination 19. In power BI, calculated fields are usually obtained from a. Data modeling b. Transpose c. Measure d. Visuals 20. Calculated fields are best represented in which of the chart? a. Bar chart b. Card  c. Table d. Pie chart Tableau 21. Tableau can be connected with the following a. Excel b. CSV file c. SQL file d. All of the above 22. Tableau data fields can be divided into two namely: a. Measure and dimension b. Dimension and ordinate c. Measure and a new measure d. Numeric and quantitative 23. In tableau, _______________ is a sequence of visualizations that work together to convey information a. Dashboard b. Story c. Chart d. Worksheet 24. _____________ is the parent organization that manages Tableau a. Microsoft b. Amazon c. Salesforce d. Alibaba 25. How many charts are in Tableau? a. 10 b. 20 c. 24 d. 30 SQL 26. What is the full meaning of SQL? a. Structured quarrel Language b. Strict Query Language c. Structured Query Learning d. Structured Query Language 27. The Database Management Systems are listed below except  a. Microsoft Excel b. MySQL c. Oracle Database d. SQL Server 28. …………………. is a prepared SQL code that you can save, so the code can be reused over and over again. a. Calculated field b. Call procedure c. Table d. Database 29. The SQL statement used for retrieving records from a database is a. SELECT b. DELETE c. OBTAIN d. UPDATE 30. What is used to uniquely identify a record in a table? a. Foreign key b. Primary Key c. Identifier d. Accumulator