Quiz Space

May 2022 term · Tools in Data Science · BSSE2002

Tools in Data Science (TDS) End Term: 7 August 2022, Set QPB1 (May 2022 term)

The IIT Madras BS Tools in Data Science (Tools in Data Science (TDS)) End Term paper sat on 7 Aug 2022, in the May 2022 term, set QPB1: 46 questions for 46 marks in 180 minutes. Every question is below with its answer. Take it as a timed mock test to be marked, or read it through first.

Questions
46
Marks
46
Duration
180 min
MCQ
45
MSQ
1
Take as mock testPractise with answers

Updated

Official paper: IIT M FOUNDATION DIPLOMA ENDTERM QPD1 07 Aug 2022 IBA NS · No negative marking.

Question 1

+1 markOne correct option

The dataset consists of geographic, demographic information about countries and their respective GDPs. You would like to visualize this data and study the relationship between the location of countries and their GDPs. You decide to use Power BI to visualize the dataset. But you would also like to generate a summary of the data. Choose the most suitable answer among the given options.

  1. A

    The summary can be generated using Quill and this is possible because Quill can be used as an extension in Power BI.

  2. B

    Quill can only be used for visualization. Therefore a summary of the dataset cannot be generated.

  3. C

    Power BI does not support generation of summary. Therefore using other visualization tools such as Tableau would work.

  4. D

    None of the options are appropriate for the generation of summary for the given question.

Show answer

Correct answer

  • D

    None of the options are appropriate for the generation of summary for the given question.

Question 1 on its own pageAlso asked in End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 2

+1 markOne correct option

Your project requires you to study the districts and their respective health indicators. You have a shapefile with you that provides the required details. The objective of the project is to identify and carve out districts that present high levels of health indicators. Choose the most suitable answer among the given options.

  1. A

    QGIS can be used to create the shapefiles for districts with high levels of health indicators.

  2. B

    While QGIS can be used to create shapefiles for the requirement, it cannot be used to identify the districts with high levels of health indicators.

  3. C

    QGIS cannot be used to meet the objectives of the project.

  4. D

    None of the options are suitable to meet the objectives of the project.

Show answer

Correct answer

  • A

    QGIS can be used to create the shapefiles for districts with high levels of health indicators.

Question 2 on its own pageAlso asked in End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 3

+1 markOne correct option

What are the two outputs provided by the Excel Azure Machine Learning plugin?

  1. A

    Percentage, Score

  2. B

    Sentiment, Percentage

  3. C

    Sentiment, Score

  4. D

    Score, Labels

Show answer

Correct answer

  • C

    Sentiment, Score

Question 3 on its own pageAlso asked in End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 4

+1 markOne correct option

Provided below is an incomplete code snippet that enables you to compute distance between two locations. Choose the most appropriate option that can be used in place of <missing line> to compute the distance. Assume the coordinates of location one is stored in the variable “location1” and the coordinates of location 2 is stored in the variable “location2”.

  1. A

    geopy.distance(location1, location2).km

  2. B

    geopy.distance(location1, location2)

  3. C

    geopy.distance.distance(location1, location2).km

  4. D

    geopy.distance.distance.distance(location1_coord, location2_coord).km

Show answer

Correct answer

  • C

    geopy.distance.distance(location1, location2).km

Question 4 on its own page

Question 5

+1 markOne correct option

Provided below is a snippet of the code block of HTML tags from a website providing weather forecast. Your goal is to scrape the high and low values for the 10-day temperature forecast.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answer

  • C
Question 5 on its own page

Question 6

+1 markOne correct option

The dataset consists of year, annual cotton production, annual rainfall, loan interest rates and fuel prices. You would like to compute the correlation coefficient between annual cotton production and other variables in the dataset to analyze the effects of various variables on the target variable. Choose the most suitable option among the following choices:

  1. A

    Excel cannot be used to compute correlation coefficients. Although we can use excel to visualize the data using scatter plots to study the relationships.

  2. B

    The CORREL() function in Excel is not suitable for this analysis because it doesn’t take more than two variables as inputs.

  3. C

    Correlation coefficients cannot be computed for continuous variables.

  4. D

    None of the options are appropriate.

Show answer

Correct answer

  • D

    None of the options are appropriate.

Question 6 on its own pageAlso asked in End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 7

+1 markOne correct option

You would like to prepare your dataset before analysis. You choose python pandas-profiling library to perform exploratory analysis. Choose the most suitable option among the given choices:

  1. A

    Your choice of pandas-profiling library is not appropriate because it does not provide information about outliers.

  2. B

    Your choice is appropriate because the pandas-profiling library provides information about outliers.

  3. C

    pandas-profiling library is appropriate because it helps build models.

Show answer

Correct answer

  • B

    Your choice is appropriate because the pandas-profiling library provides information about outliers.

Question 7 on its own pageAlso asked in End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 8

+1 markOne correct option

Which piece of code below will extract and display details of the 9 scheduled airlines in India?

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answer

  • A
Question 8 on its own page

Question 9

+1 markOne correct option

Comicgen is a useful tool in narrating data stories using comics. Which of the following is not a function of comicgen?

  1. A

    Comicgen creates comic characters

  2. B

    Comicgen provides options to custom create different comic characters and their emotions and pose

  3. C

    Comicgen can be easily integrated into Google sheets or Excel to narrate your data stories

  4. D

    You can type in your data story into comicgen to get your comic in return

Show answer

Correct answer

  • D

    You can type in your data story into comicgen to get your comic in return

Question 9 on its own pageAlso asked in End Term 3 Apr 2022, End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 10

+1 markOne correct option

A very large Matrix A has a lot of zero entries in it.Which function from the scipy library is useful in efficient storage of such a matrix A?

  1. A

    compressed_mat

  2. B

    comp_mat

  3. C

    csr_matrix

  4. D

    zip_mat

Show answer

Correct answer

  • C

    csr_matrix

Question 10 on its own pageAlso asked in End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 11

+1 markOne correct option

Which of the following libraries has functions and tools that are useful in the analysis of large graphs?

  1. A

    scikit-network

  2. B

    pandas-network

  3. C

    numpy-network

  4. D

    pd-network

Show answer

Correct answer

  • A

    scikit-network

Question 11 on its own pageAlso asked in End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 12

+1 markOne correct option

Kumu is a tool that allows you to:

  1. A

    Visualize project management charts

  2. B

    create stunning dashboards for large projects

  3. C

    merge Comicgen characters into a comic

  4. D

    Visualize complex network data

Show answer

Correct answer

  • D

    Visualize complex network data

Question 12 on its own pageAlso asked in End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 13

+1 markOne correct option

Which of the following libraries has functions extensively written to extract data from Wikipedia pages?

  1. A

    BeautifulSoup

  2. B

    wikimedia

  3. C

    wikipedia

  4. D

    wiki_scrape

Show answer

Correct answer

  • C

    wikipedia

Question 13 on its own pageAlso asked in End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 14

+1 markOne correct option

A dataset provided to you has information about countries and respective populations. You plan to visualize the data in Tableau using the map representation. But you are unable to do so because the map representation is not activated for you to choose. What might be the issue? Provided below is a snapshot of the dataset column names and types. Choose the most appropriate option that would solve the problem.

  1. A

    The provided dataset is incomplete

  2. B

    We also need Latitude and Longitude information to activate the map representation

  3. C

    There might be column type incompatibility issues

  4. D

    The given information provided would not have caused any issues. It is sufficient for map representation

Show answer

Correct answer

  • C

    There might be column type incompatibility issues

Question 14 on its own page

Question 15

+1 markOne correct option

Logical calculations in tableau helps to determine if a certain condition is true or false. Is the following expression valid ?

  1. A

    TRUE

  2. B

    FALSE

Show answer

Correct answer

  • B

    FALSE

Question 15 on its own page

Question 16

+1 markOne correct option

__________ is helpful to understand the structure of (or inspect) a website before writing a scraping script.

  1. A

    BeautifulSoup

  2. B

    Developer Tools

  3. C

    Airflow

  4. D

    Pycaret

Show answer

Correct answer

  • B

    Developer Tools

Question 16 on its own pageAlso asked in End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 17

+1 markOne correct option

__________ library has tools to get a webpage’s html contents into Python.

  1. A

    BeautifulSoup

  2. B

    numpy

  3. C

    requests

  4. D

    get

Show answer

Correct answer

  • C

    requests

Question 17 on its own pageAlso asked in End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 18

+1 markOne correct option

Which among the following code blocks will get you the latitude and longitude of “IIT Madras”? Assume the Nominatim library is imported using the command given below:

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answer

  • C
Question 18 on its own page

Question 19

+1 markOne correct option

Type of location (tourist/historic/etc.) can be retrieved using Nominatim in Python

  1. A

    TRUE

  2. B

    FALSE

Show answer

Correct answer

  • A

    TRUE

Question 19 on its own pageAlso asked in End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 20

+1 markOne correct option

Which of the following delimiters cannot be used in text-to-column function in Excel?

  1. A

    Comma (,)

  2. B

    Tab (\t)

  3. C

    Semi colon (;)

  4. D

    Tilde (~)

  5. E

    None of these

Show answer

Correct answer

  • E

    None of these

Question 20 on its own pageAlso asked in End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 21

+1 markOne correct option

What is the y-axis in autocorrelation plot?

  1. A

    Correlation

  2. B

    Covariance

  3. C

    Standard deviation

  4. D

    Variance

  5. E

    None of these

Show answer

Correct answer

  • A

    Correlation

Question 21 on its own pageAlso asked in End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 22

+1 markOne correct option

Which of the following tools cannot be used for anonymising the data?

  1. A

    Anonimatron

  2. B

    ARX anonymization tool

  3. C

    PowerBI

  4. D

    Amnesia

  5. E

    sdcMicro

Show answer

Correct answer

  • C

    PowerBI

Question 22 on its own pageAlso asked in End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 23

+1 markOne correct option

For a one-time anonymization, static anonymization is sufficient. Is this statement true or false?

  1. A

    TRUE

  2. B

    FALSE

Show answer

Correct answer

  • A

    TRUE

Question 23 on its own pageAlso asked in End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 24

+1 markOne correct option

We have a variable X, which can take values AA, BB, or CC. The first 4 values of this variable in a dataset are CC, AA, BB, AA. The format of representing this information as shown in the table below is called:

  1. A

    multi-col format

  2. B

    one - hot encoding

  3. C

    long format

  4. D

    integer

Show answer

Correct answer

  • B

    one - hot encoding

Question 24 on its own page

Question 25

+1 markOne correct option

We have a variable X, which can take values AA, BB, or CC. The first 4 values of this variable in a dataset are CC, AA, BB, AA. This information is represented as shown below.

To convert a variable to this format in Python, one can use:

  1. A

    pandas.get_dummies

  2. B

    from sklearn.preprocessing import BinaryEncoder

  3. C

    import numpy as np

  4. D

    import seaborn as sb

Show answer

Correct answer

  • A

    pandas.get_dummies

Question 25 on its own page

Question 26

+1 markOne correct option

k-means is typically influenced by the start values. What option in sklearn.cluster.KMeans helps reduce the impact?

  1. A

    verbose

  2. B

    algorithm

  3. C

    n_init

  4. D

    init

Show answer

Correct answer

  • C

    n_init

Question 26 on its own pageAlso asked in End Term 3 Apr 2022, End Term 3 Apr 2022, End Term 11 Dec 2022, End Term 30 Apr 2023 and 1 more

Question 27

+1 markOne correct option

A Pandas dataframe DF has a column named salary_range which contains the salary details of 10000 employees of a firm binned as medium, high, and very high. You are interested in finding out the number of employees in each category of salary_range. Which of the following commands will help you to achieve this goal?

  1. A

    DF[‘salary_range’].bin_count()

  2. B

    DF[‘salary_range’].value_counts()

  3. C

    DF$‘salary_range.bin_count()

  4. D

    DF$‘salary_range.value_counts()

Show answer

Correct answer

  • B

    DF[‘salary_range’].value_counts()

Question 27 on its own pageAlso asked in End Term 3 Apr 2022, End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 28

+1 markOne correct option

Scikit-learn has a DecisionTreeClassifier module that is useful in building decision tree classifiers. Suppose, our dataset is imbalanced in class. Which feature in the DecisionTreeClassifier() will help us tackle this problem?

  1. A

    random_state

  2. B

    min_sample_split

  3. C

    class_balance

  4. D

    class_weight

Show answer

Correct answer

  • D

    class_weight

Question 28 on its own pageAlso asked in End Term 3 Apr 2022, End Term 3 Apr 2022, End Term 7 Aug 2022, End Term 11 Dec 2022 and 5 more

Question 29

+1 markOne correct option
  1. A

    from sklearn.metrics import mean_absolute_error

  2. B

    from sklearn.metrics import median_absolute_error

  3. C

    from sklearn.metrics import median_absolute_percentage_error

  4. D

    from sklearn.metrics import average_absolute_percentage_error

Show answer

Correct answer

  • A

    from sklearn.metrics import mean_absolute_error

Question 29 on its own page

Question 30

+1 markOne correct option

We are interested in fitting an ARIMA model to our time series data. Specifically, we are interested in a moving average model of 0, setting a lag value of 4 for autoregression, and a difference order of 1. Which of the following gives you such a model?

  1. A

    ARIMA(..., trend = (4,1,0))

  2. B

    ARIMA(..., order = (4,1,0))

  3. C

    ARIMA(..., order = (0,4,1))

  4. D

    ARIMA(..., trend = (0,4,1))

Show answer

Correct answer

  • B

    ARIMA(..., order = (4,1,0))

Question 30 on its own pageAlso asked in End Term 3 Apr 2022, End Term 3 Apr 2022, End Term 7 Aug 2022, End Term 11 Dec 2022 and 8 more

Question 31

+1 markOne correct option

pycaret is a

  1. A

    Visualization tool

  2. B

    Dashboard helper

  3. C

    low-code machine learning library

  4. D

    Data cleaning solution

Show answer

Correct answer

  • C

    low-code machine learning library

Question 31 on its own pageAlso asked in End Term 3 Apr 2022, End Term 3 Apr 2022, End Term 7 Aug 2022, End Term 11 Dec 2022 and 5 more

Question 32

+1 markOne correct option

subjectivity and polarity are two properties returned by the sentiment function of library:

  1. A

    TextBulb

  2. B

    NLPtext

  3. C

    TextBlob

  4. D

    NLP

Show answer

Correct answer

  • C

    TextBlob

Question 32 on its own pageAlso asked in End Term 3 Apr 2022, End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 33

+1 markOne correct option

A subjectivity score of 0.8 means that the text statement:

  1. A

    has a positive sentiment

  2. B

    has a negative sentiment

  3. C

    is more of an opinion statement

  4. D

    is more of a factual statement

Show answer

Correct answer

  • C

    is more of an opinion statement

Question 33 on its own pageAlso asked in End Term 3 Apr 2022, End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 34

+1 markOne correct option

A polarity score of negative 0.5 means that the text statement:

  1. A

    has a positive sentiment

  2. B

    has a negative sentiment

  3. C

    is more of an opinion statement

  4. D

    is more of a factual statement

Show answer

Correct answer

  • B

    has a negative sentiment

Question 34 on its own pageAlso asked in End Term 3 Apr 2022, End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 35

+1 markOne correct option

You are working on a piece of code that classifies different fruits into its respective groups (citrus, berries, melons, apples & pears, and tropical & exotic). Which of the following loss functions from Keras would you pick for the task?

  1. A

    binary_crossentropy

  2. B

    categorical_crossentropy

  3. C

    mean_squared_error

  4. D

    mean_absolute_error

Show answer

Correct answer

  • B

    categorical_crossentropy

Question 35 on its own pageAlso asked in End Term 3 Apr 2022, End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 36

+1 markOne correct option

classification_report function from the sklearn.metrics module

  1. A

    builds a decision tree classifier and prints the accuracy of the classifier

  2. B

    reports the root mean square error of the model

  3. C

    runs different classification models and compares the results

  4. D

    builds a text report displaying the main classification metrics

Show answer

Correct answer

  • D

    builds a text report displaying the main classification metrics

Question 36 on its own pageAlso asked in End Term 3 Apr 2022, End Term 3 Apr 2022, End Term 7 Aug 2022, End Term 11 Dec 2022 and 5 more

Question 37

+1 markOne correct option

csr_matrix from the scipy library:

  1. A

    always helps reduce matrix space

  2. B

    helps reduce matrix space when there are a lot of zero entries in the matrix

  3. C

    helps reduce matrix space when there are a lot of negative entries in the matrix

  4. D

    makes matrix multiplication more meaningful and powerful

Show answer

Correct answer

  • B

    helps reduce matrix space when there are a lot of zero entries in the matrix

Question 37 on its own pageAlso asked in End Term 3 Apr 2022, End Term 3 Apr 2022, End Term 7 Aug 2022, End Term 11 Dec 2022 and 5 more

Question 38

+1 markOne correct option

Google Studio is a tool that allows you to

  1. A

    merge Comicgen characters into a comic

  2. B

    visualize complex network data

  3. C

    create dashboards for small scale projects

  4. D

    Edit photographs and videos

Show answer

Correct answer

  • C

    create dashboards for small scale projects

Question 38 on its own pageAlso asked in End Term 3 Apr 2022, End Term 3 Apr 2022, End Term 7 Aug 2022, End Term 11 Dec 2022 and 5 more

Question 39

+1 markOne correct option

Which of the following tabs is used to identify API calls in the Inspect element in any browser?

  1. A

    Network

  2. B

    Elements

  3. C

    Console

  4. D

    Sources

Show answer

Correct answer

  • A

    Network

Question 39 on its own pageAlso asked in End Term 3 Apr 2022, End Term 3 Apr 2022, End Term 7 Aug 2022, End Term 11 Dec 2022 and 5 more

Question 40

+1 markOne correct option

Which of the following libraries is used to construct API urls?

  1. A

    Urllib

  2. B

    BeautifulSoup

  3. C

    Requests

  4. D

    Pandas

Show answer

Correct answer

  • A

    Urllib

Question 40 on its own pageAlso asked in End Term 3 Apr 2022, End Term 3 Apr 2022, End Term 7 Aug 2022, End Term 11 Dec 2022 and 5 more

Question 41

+1 markOne correct option

The final output from the BBC Weather Location Service API is in JSON format:

  1. A

    TRUE

  2. B

    FALSE

Show answer

Correct answer

  • A

    TRUE

Question 41 on its own pageAlso asked in End Term 3 Apr 2022, End Term 11 Dec 2022, End Term 30 Apr 2023, End Term 3 Sept 2023

Question 42

+1 markOne correct option

Which among the following excel charts is the most suitable for detecting outliers in the data?

  1. A

    Bar chart

  2. B

    Line chart

  3. C

    Box and Whisker chart

  4. D

    Histogram

Show answer

Correct answer

  • C

    Box and Whisker chart

Question 42 on its own pageAlso asked in End Term 3 Apr 2022, End Term 3 Apr 2022, End Term 7 Aug 2022, End Term 11 Dec 2022 and 5 more

Question 43

+1 markOne correct option

Provided below is a snapshot of the dataset which consists of movie reviews and respective labels.

To compute the sentiment scores the Azure Machine Learning add-in requires input and output values. In the figure provided below the input and output cells need to be populated with appropriate values to obtain sentiment scores.

Choose the most appropriate option that enables you to predict sentiment scores using the Excel Azure Machine Learning add-in.

  1. A
  2. B
Show answer

Correct answer

  • A
Question 43 on its own page

Question 44

+1 markOne or more correct options

scikit-network package contains functions for (pick all correct sentences):

Select all that apply.

  1. A

    analysis of faults in a computer network

  2. B

    social network analysis

  3. C

    analysis of large graphs

  4. D

    enhancing one’s social network

Show answer

Correct answers

  • B

    social network analysis

  • C

    analysis of large graphs

Question 44 on its own pageAlso asked in End Term 3 Apr 2022, End Term 3 Apr 2022, End Term 7 Aug 2022, End Term 11 Dec 2022 and 1 more

Question 45

+1 markOne correct option

Answer the given subquestions

We are analyzing how much the number of lecture hours attended by students affects their exam scores. Which Excel function would you use as a starting point in this analysis?

  1. A

    STDEV.P()

  2. B

    STDEV.S()

  3. C

    SLOPE()

  4. D

    EXACT()

Show answer

Correct answer

  • C

    SLOPE()

Question 45 on its own pageAlso asked in End Term 30 Apr 2023, End Term 3 Sept 2023

Question 46

+1 markOne correct option

Answer the given subquestions

In the previous question, we plan to run a regression analysis after the preliminary analysis. Which of the following features provide you with the capability to do this?

  1. A

    Data Analysis Toolpak

  2. B

    Regression Analyzer

  3. C

    Regression ToolBokz

  4. D

    OptSol finder

Show answer

Correct answer

  • A

    Data Analysis Toolpak

Question 46 on its own page