MO-200: Interview Questions
MO-200 Exam covers the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. Survival of fittest has become the policy to rule the corporate sector. You have to be excellent in depicting your skills in order to maintain your position. Now, the certifications, in this situation helps you to get promotions and show your commitment towards work. Also, we all know, a certified professional is valued way more than a normal employee. Keep reading till the end and you will be equipped with all the information related to the exam.
Let us look at some MO-200: Interview Questions and see what types and patterns can be expected.
1. What types of workbooks does Power BI support?
Microsoft Excel is one of the most widely used business applications around. It’s also one of the most common ways to get your data into Power BI. Power BI supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type and be under 1 GB.
2. What Data Types does Power BI Support?
Power BI supports the following data types: Whole Number, Decimal Number, Currency, Date, True/False, Text.
3. What happens if you save you workbook in a local drive?
If you save your Workbook in a local drive what really happens is a new dataset is created in Power BI and data and the data model from the workbook are loaded into the dataset. If your workbook has any Power View sheets, those will appear in your Power BI site under Reports. Excel 2016 also has the Publish feature . Using Publish is effectively the same as using Get Data > Files > Local File from Power BI, but is often easier to update your dataset in Power BI if you’re regularly making changes to the workbook.
4. What is the role of Parameters?
Report creators add query parameters to reports in Power BI Desktop. Parameters allow them to make parts of reports depend on one or more parameter values. For example, a report creator may create a parameter that restricts the data to a single country/region or a parameter that defines acceptable formats for fields like dates, time, and text.
5. What happens when you refresh data in Power BI?
Power BI enables you to go from data to insight to action quickly, yet you must make sure the data in your Power BI reports and dashboards is recent. Whenever you refresh data, Power BI must query the underlying data sources, possibly load the source data into a dataset, and then update any visualizations in your reports or dashboards that rely on the updated dataset.
6. In what modes can power Bi dataset operate?
A Power BI dataset can operate in one of the following modes to access data from a variety of data sources.
- Import mode
- DirectQuery mode
- LiveConnect mode
- Push mode
7. What is Incremental refresh?
Incremental refresh extends scheduled refresh operations by providing automated partition creation and management for dataset tables that frequently load new and updated data. For most datasets, this is one or more tables that contain transaction data that changes often and can grow exponentially, like a fact table in a relational or star database schema. By partitioning the table and refreshing only the most recent partition(s) significantly reduces the amount of data that has to be refreshed.
8. Give some benefits of Incremental Refresh.
With incremental refresh:
- Refreshes are faster – Only the most recent data that has changed needs to be refreshed.
- Refreshes are more reliable – Long-running connections to volatile data sources aren’t necessary. Queries to source data run faster, reducing potential for network problems to interfere.
- Resource consumption is reduced – Less data to refresh reduces overall consumption of memory and other resources in both Power BI and data source systems.
- Enables large datasets – Datasets with potentially billions of rows can grow without the need to fully refresh the entire dataset with each refresh operation.
- Easy setup – Incremental refresh policies are defined in Power BI Desktop with just a few tasks. When published, the service automatically applies those policies with each refresh.
9. How do you schedule Refresh in Power BI?
When you set up a refresh schedule, Power BI connects directly to the data sources. Power BI uses connection information and credentials in the dataset to query for updated data. Then Power BI loads the updated data into the dataset. It then updates any report visualizations and dashboards based on that dataset in the Power BI service.
10. What are Power BI template apps?
The new Power BI template apps enable Power BI partners to build Power BI apps with little or no coding, and deploy them to any Power BI customer. The general process to develop and submit a template app involves several stages. Some stages can include more than one activity at the same time. You build template apps that allow your customers to connect and instantiate within their own accounts. As domain experts, they can unlock the data in a way that’s easy for their business users to consume.
11. Explain Threat protection in Microsoft 365 E5?
Microsoft 365 E5 enables you to protect your organization with adaptive, built-in intelligence. With the security capabilities in Microsoft 365 E5, you can detect and investigate advanced threats, compromised identities, and malicious actions across your environment (on-premises and in the cloud).
12. Define Document properties.
Document properties, also known as metadata, are details about a file that describe or identify it. They include details such as title, author name, subject, and keywords that identify the document’s topic or contents. If you include the document properties for your files, you can easily organize and identify them later. You can also search for documents based on their properties or insert them into your documents.
13. What are Standard properties?
By default, Office documents are associated with a set of standard properties, such as author, title, and subject. You can specify your own text values for these properties to make it easier to organize and identify your documents. For example, in Word, you can use the Keywords property (also called Tags) to add the keyword “customers” to your sales documents. You can then search for all sales documents with that keyword.
14. Explain Custom Properties.
You can define additional custom properties for your Office documents. You can assign a text, time, or numeric value to custom properties, and you can also assign them the values yes or no. You can choose from a list of suggested names or define your own.
15. What is SharePoint organization-level sharing settings?
The organization-level settings for SharePoint determine the settings that will be available for individual SharePoint sites. Site settings cannot be more permissive than the organization-level settings. The organization-level setting for OneDrive determines the level of sharing that will be available in users’ OneDrive libraries.
16. What is Microsoft Compliance Manager?
Compliance Manager is a workflow-based risk assessment tool in the Microsoft 365 compliance center for managing regulatory compliance activities related to Microsoft cloud services. As part of your Microsoft 365 or Azure Active Directory (Azure AD) subscription, Compliance Manager helps you manage regulatory compliance within the shared responsibility model for Microsoft cloud services.
17. What are SQL Server Big Data Clusters?
SQL Server Big Data Clusters allow you to deploy scalable clusters of SQL Server, Spark, and HDFS containers running on Kubernetes. These components are running side by side to enable you to read, write, and process big data from Transact-SQL or Spark, allowing you to easily combine and analyze your high-value relational data with high-volume big data.
18. What is HDFS storage pool?
A SQL Server big data cluster includes a scalable HDFS storage pool. This can be used to store big data, potentially ingested from multiple external sources. Once the big data is stored in HDFS in the big data cluster, you can analyze and query the data and combine it with your relational data.
19. What tasks can you perform on big Data Cluster?
You can use Azure Data Studio to perform a variety of tasks on the big data cluster:
- Built-in snippets for common management tasks.
- Ability to browse HDFS, upload files, preview files, and create directories.
- Ability to create, open, and run Jupyter-compatible notebooks.
- Data virtualization wizard to simplify the creation of external data sources (enabled by the Data Virtualization Extension).
20. Define Kubernetes concepts.
Kubernetes is an open source container orchestrator, which can scale container deployments according to need.
21. Define Kubernetes Cluster.
A Kubernetes cluster is a set of machines, known as nodes. One node controls the cluster and is designated the master node; the remaining nodes are worker nodes. The Kubernetes master is responsible for distributing work between the workers, and for monitoring the health of the cluster.
22. Define a Kubernetes Pod.
A pod is the atomic deployment unit of Kubernetes. A pod is a logical group of one or more containers-and associated resources-needed to run an application. Each pod runs on a node; a node can run one or more pods. The Kubernetes master automatically assigns pods to nodes in the cluster.
23. What is SQL Server Replication?
Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. You Use replication to distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.
24. What is Stretch Database?
Stretch Database migrates your cold data transparently and securely to the Microsoft Azure cloud.
25.How do Cursors extend result processing?
Cursors extend result processing by:
- Allowing positioning at specific rows of the result set.
- Retrieving one row or block of rows from the current position in the result set.
- Supporting data modifications to the rows at the current position in the result set.
- Supporting different levels of visibility to changes made by other users to the database data that is presented in the result set.
- Providing Transact-SQL statements in scripts, stored procedures, and triggers access to the data in a result set.
26. How many types of Physical Join Operations are their?
SQL Server employs four types of physical join operations to carry out the logical join operations:
- Nested Loops joins
- Merge joins
- Hash joins
- Adaptive joins
27. What is a Subquery?
A subquery is also called an inner query or inner select, while the statement containing a subquery is also called an outer query or outer select. A subquery can be used anywhere an expression is allowed.
28. What is SQL Command Prompt Utilities?
Command prompt utilities enable you to script SQL Server operations.
29. What are Sparklines?
Sparklines are small charts that fit inside individual cells in a sheet. Because of their condensed size, sparklines can reveal patterns in large data sets in a concise and highly visual way. You Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. A sparkline has the greatest effect when it’s positioned near the data that it represents.
30. What isthe TEXTJOIN function?
The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.
Start Preparing for the MO-200: Microsoft Excel (Excel and Excel 2019) exam now
