Practice questions Data analysis

Data Analysis
#1

Hello learners,
Try to answer all the questions.
All the best

  1. In SQL, which data manipulation language (DML) command is used to delete a table from the database?
    a) REMOVE TABLE
    b) DROP TABLE
    c) DELETE TABLE
    d) ERASE TABLE
  2. Power BI MCQ - Data Sources: Which of the following data sources can Power BI connect to?
    a) Only Microsoft Excel files
    b) Only Microsoft SQL Server databases
    c) Only cloud-based data sources
    d) A wide variety of data sources, including databases, cloud services, and online services
  3. Power BI MCQ - Visualization: What type of visualization is best suited to show trends over time?
    a) Pie chart
    b) Scatter plot
    c) Bar chart
    d) Line chart
  4. Power BI MCQ - Data Modeling: In Power BI, what is the purpose of creating relationships between tables?
    a) To restrict access to certain data
    b) To improve report performance
    c) To enable drill-down capabilities
    d) To establish connections between data from different tables
  5. Power BI MCQ - DAX Language: What does DAX stand for in Power BI?
    a) Data Analysis Expressions
    b) Data Aggregation XML
    c) Data Access Extender
    d) Data eXchange Protocol
2 Likes