MCQ Bank
What does the acronym DAX stand for in Power BI?
- A) Data Analytics Xtension
- B) Data Analysis Xpressions
- C) Deutscher Aktien Index
- D) Data Analysis Expressions
How can you reference a variable named "Salary" in Power BI's custom column function?
- A) Salary()
- B) [Salary]
- C) Salary{}
- D) @Salary
In Power BI, when working with conditional expressions, what does the term "slab" typically represent?
- A) A measure of temperature
- B) A specific database table
- C) A range of values with different rates
- D) A type of data source
What is the primary purpose of the "Power Query Editor" in Power BI?
- A) To generate DAX measures
- B) To clean, transform, and shape data before loading it into the model
- C) To apply conditional formatting
- D) To create visualizations
What is the primary purpose of using cards in Power BI?
- A) To create detailed visualizations.
- B) To represent complex data structures.
- C) To display graphs and charts.
- D) To showcase key numerical figures without using graphs or charts.
What happens to the measures created in Power BI after the session is closed?
- A) They become part of a new column
- B) They are permanently saved in the data model
- C) They are stored separately as entries
- D) They are eliminated and not saved
When applying conditional formatting to a variable like income in Power BI, which visual options are available?
- A) Only numeric values
- B) Data bars, color scales, and icons
- C) Only bars
- D) Only icons
What is the primary purpose of the "Append Queries" option in Power BI?
- A) To remove duplicates from a dataset
- B) To combine data from two or more tables by stacking rows
- C) To join two queries based on a common column
- D) To add new calculated columns
In geographical analysis using Power BI, what type of data can be imported onto the map?
- A) Geographical data without latitude or longitude but with general location names.
- B) Geographical data with both latitude and longitude coordinates.
- C) Geographical data with only latitude coordinates.
- D) Geographical data with only longitude coordinates.
What is the primary limitation when exporting a Power BI dashboard as a static image (PDF, JPEG, etc.)?
- A) Data becoming inaccurate over time.
- B) Loss of interactivity and ability to analyze data.
- C) Large file sizes that slow down performance.
- D) Compatibility issues with different devices or software.
What is the primary challenge when trying to transform data in Power BI?
- A) Understanding the data types of variables
- B) Knowing the exact sequence of data transformation
- C) Ensuring that all variables are highlighted
- D) Identifying the correct data transformation function
Which button is used to access the data editor in Power BI?
- A) Editor
- B) Transformation
- C) Transform Data
- D) Add Column
What does the col parameter in a plot function control?
- A) Plot title
- B) Data types
- C) Column names
- D) Color of the graph
What can be done after identifying outliers in R?
- A) Export them as images
- B) Remove them from the data set
- C) Always multiply their values by 2
- D) Rename the dataset
What is a good practice when installing R?
- A) Always choose the latest version
- B) Avoid reading instructions
- C) Turn off antivirus software
- D) Skip unnecessary files
Which plot is used in R to visualize outliers?
- A) Box plot
- B) Pie chart
- C) Line chart
- D) Bar plot
How can users make a graph more informative in R?
- A) Removing all labels
- B) Hiding axis values
- C) Customizing axis labels
- D) Reducing graph size
What is the primary advantage of using variables in R?
- A) Variables replace the need for using the R help file.
- B) Variables make it easier to download and install R modules.
- C) Variables allow you to combine functions in R.
- D) Variables help you remember and reuse specific values.
How does R commonly treat data within a database?
- A) HTML files
- B) Vectors or matrices
- C) Images
- D) Charts only
What does the term "CRAN" stand for in the context of R programming?
- A) Centralized R Application Node
- B) Coded R Analytical Network
- C) Comprehensive R Archive Network
- D) Complete R Access Network