East End Wholesale Stores Data Migration Consultant Interview Questions and Answers

Q1. Explain what is windows server.
Ans. 
Windows Server is a group of operating systems designed by Microsoft for server use.
• Windows Server is a group of operating systems developed by Microsoft.

• It is specifically designed for use in server environments.

• Windows Server provides features such as networking, storage, and virtualization capabilities.

• Examples of Windows Server versions include Windows Server 2016 and Windows Server 2019.
Answered by AI
Add your answer
Q2. Explain what does intellimirror do
Ans. 
Intellimirror is a feature in Windows Server that allows for centralized management of user desktop settings and files.
• Intellimirror provides users with access to their desktop settings and files from any computer on the network.

• It allows for automated backup and restoration of user data and settings.

• Intellimirror can be used to deploy software applications to multiple computers in a network.

• It helps in reducing IT sup...read more
Answered by AI
Add your answer
Q3. What does it mean by "tattooing" the registry
Ans. 
Tattooing the registry refers to making permanent changes to the Windows registry that cannot be easily undone.
• Tattooing the registry involves modifying critical system settings in the Windows registry.

• These changes are typically irreversible and can have a significant impact on system performance and stability.

• It is important to exercise caution when tattooing the registry as incorrect changes can lead to system error...read more
Answered by AI
Add your answer
Q4. Mention how many types of queries DNS does
Ans. 
DNS can perform various types of queries including recursive, iterative, inverse, and dynamic updates.
• DNS can perform recursive queries where it queries other servers on behalf of the client until it finds the answer.

• Iterative queries involve the DNS server providing the best answer it can based on its own knowledge.

• Inverse queries allow a DNS client to request the domain name associated with a specific IP address.

• Dyna...read more
Answered by AI
Add your answer
Q5. Explain what is the primary function of the domain controller
Ans. 
The primary function of the domain controller is to authenticate and authorize all users and computers in a Windows domain network.
• Authenticating and authorizing users and computers in a Windows domain network

• Managing security policies and access control

• Maintaining Active Directory database

• Enforcing security policies across the network
Answered by AI
Add your answer

Q1. Wat is cardinality
Ans. 
Cardinality refers to the uniqueness of values in a column or relationship.
• Cardinality is the number of unique values in a column or relationship.

• High cardinality means a column has many unique values, while low cardinality means few unique values.

• For example, a column like 'Customer ID' may have high cardinality, while 'Gender' may have low cardinality.
Answered by AI
Add your answer
Q2. Challenges faced
Add your answer

Q1. Write SQL query
Ans. 
SQL query to retrieve data from a table
• Use SELECT statement to specify columns to retrieve

• Use FROM statement to specify the table to retrieve data from

• Use WHERE statement to filter the data based on conditions
Answered by AI
Add your answer

Power bi desktop in power bi service

Q1. What is power bi
Ans. 
Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
• Power BI allows users to connect to various data sources and create interactive reports and dashboards.

• Users can easily share and collaborate on reports with others within the organization.

• It offers features like data modeling, data visualization, and data transformation.

• Power BI can be use...read more
Answered by AI
View 1 more answer
Q2. How creative a dashboard in power query
Ans. 
A creative dashboard in Power Query involves using unique visuals and interactive elements to present data in an engaging way.
• Utilize custom visuals to display data in a visually appealing manner

• Incorporate interactive elements such as slicers and filters for user-friendly navigation

• Use color coding and formatting to highlight important insights

• Include dynamic elements like tooltips and drill-down capabilities

• Experimen...read more
Answered by AI
View 1 more answer

Q1. Power bi desktop
Add your answer
Q2. Write the Dax query in data modeling
Ans. 
Write a DAX query in data modeling
• Use CALCULATE function to apply filters and context to calculations

• Use SUMX function to iterate over a table and perform calculations

• Use RELATED function to retrieve related values from other tables
Answered by AI
View 1 more answer

Q1. What is power pivot
Ans. 
Power Pivot is a data modeling tool in Excel that allows users to create relationships, calculations, and measures for analyzing large datasets.
• Power Pivot is an add-in for Excel that enables users to create data models and perform advanced data analysis.

• It allows users to import and combine data from multiple sources, create relationships between tables, and define calculations and measures.

• Users can create complex ca...read more
Answered by AI
Add your answer
Q2. Creation in dax
Ans. 
Creation in DAX refers to the process of generating new calculated columns or measures in Power BI using Data Analysis Expressions.
• Use DAX functions like CALCULATE, SUMX, AVERAGE, etc. to create new columns or measures

• Understand the data model and relationships to create accurate calculations

• Test the newly created calculations to ensure they are working correctly
Answered by AI
Add your answer

Brief information about Business Intelligence (BI) tools.

Q1. What is the role of Power BI in today's market?
Add your answer
Q2. What are the differences between Power BI and Tableau?
Add your answer
Q3. What are some case studies that demonstrate the use of Power BI?
Add your answer

Q1. What are your salary expectations?
Add your answer

Q1. What are the components of Power bi
Ans. 
Power BI components include Power Query, Power Pivot, Power View, Power Map, and Power Q&A.
• Power Query: Used for data extraction and transformation.

• Power Pivot: Used for data modeling and analysis.

• Power View: Used for interactive data visualization.

• Power Map: Used for geographical data visualization.

• Power Q&A: Allows users to ask questions in natural language and get answers from data.
Answered by AI
Add your answer
Q2. What is mean by DAX
Ans. 
DAX stands for Data Analysis Expressions and is a formula language used in Power BI for creating custom calculations.
• DAX is used to create custom calculations in Power BI, similar to Excel formulas.

• It can be used to create calculated columns, measures, and calculated tables.

• DAX functions can be used to manipulate data, perform calculations, and create complex expressions.

• Examples of DAX functions include SUM, AVERAGE,
Answered by AI
Add your answer
Q3. What is mean by M language
Ans. 
M language is a powerful data transformation language used in Power Query in Power BI.
• M language is used to transform and clean data in Power BI.

• It is a functional language with a wide range of functions and operators.

• M language is case-sensitive and uses a step-by-step approach to data transformation.

• Examples of M language functions include Table.TransformColumns and List.Transform.
Answered by AI
Add your answer

It was a real-time scenario that they asked about.

Q1. Difference Between direct query mode and import mode
Ans. 
Direct query mode connects to data source in real-time, while import mode loads data into Power BI for faster analysis.
• Direct query mode connects to data source in real-time, providing up-to-date data

• Import mode loads data into Power BI for faster analysis, but may not always reflect real-time changes

• Direct query mode is suitable for large datasets that require real-time updates

• Import mode is suitable for smaller datas
Answered by AI
Add your answer
Q2. Define powerBI in layman poin of view
Ans. 
PowerBI is a data visualization tool that helps users analyze and visualize data to make informed business decisions.
• PowerBI helps in creating interactive reports and dashboards

• It allows users to connect to various data sources like Excel, SQL databases, and cloud services

• Users can create custom visualizations and share insights with others

• PowerBI can be used for data exploration, data modeling, and data storytelling
Answered by AI
Add your answer

Q1. How the end user access the report
Ans. 
End users can access the report through Power BI Service, Power BI Mobile App, or embedded in other applications.
• End users can access the report through Power BI Service by logging in with their credentials

• End users can also access the report through Power BI Mobile App on their smartphones or tablets

• Reports can be embedded in other applications using Power BI Embedded feature
Answered by AI
Add your answer