Powerbi exam Study guides, Class notes & Summaries

PowerBI Certification Exam 2023 Verified 100% If you want your data to automatically refresh as you interact with visualizations, which option should you choose? A) Import B) DirectQuery B) DirectQuery Explanation: When you use DirectQuery, no data is imported into Power BI Desktop. As you create or interact with a visualization, PowerBI Desktop queries the underlying data source, i.e. you're always viewing current data. How do you connect to Excel files that contain target figures? T...

If you want your data to automatically refresh as you interact with visualizations, which option should you choose? A) Import B) DirectQuery B) DirectQuery Explanation: When you use DirectQuery, no data is imported into Power BI Desktop. As you create or interact with a visualization, PowerBI Desktop queries the underlying data source, i.e. you're always viewing current data. How do you connect to Excel files that contain target figures? The solution should involve minimum manual w...

You have a collection of datasets and reports. You need to share the datasets and report together. This solution must NOT send any email notifications to internal users after sharing. What should you create in the Power BI Service? Select only one answer. 1 a deployment pipeline 2 a workspace 3 an app 4 metrics - ANSWER-3 (MS) Workspace apps can be installed automatically for any user in an organization, and without requiring notifications of installation.

PowerBI Certification Exam 2023 Verified 100% If you want your data to automatically refresh as you interact with visualizations, which option should you choose? A) Import B) DirectQuery B) DirectQuery Explanation: When you use DirectQuery, no data is imported into Power BI Desktop. As you create or interact with a visualization, PowerBI Desktop queries the underlying data source, i.e. you're always viewing current data. How do you connect to Excel files that contain target figures? T...

Phases in Data Analytics - Data requirement gathering - Data source identification - Data cleaning - Data processing - Exploratory data analysis Types of Analytics - Descriptive analytics - Diagnostic analytics - Predictive analytics - Cognitive analytics - Prescriptive analytics Roles in data science - Data analyst - Business analyst - Data engineer - Data scientist - Database admin Data analyst - jack of all traits - PowerBI (minimal/no code) - PM / stake...

What are some of the data sources you can use in PBI? Flat files & Folders (csv, text, excel, json, etc). Databases (SQL Access, Oracle, IBM, MySql, etc.). Power Platform (Dataflows, Power BI Datasets, Datavers3, etc). Azure (SQL Db, Blob Storage, Cosmos DB, Data Lake Storage, etc). Online Services (Sharepoint, Github, Dynamics 365, Google Analytics, Salesforce, etc). Others (web feeds, R scripts, Spark, Hadoop, etc.). What let's you shape and transform data? Query editor What is Po...

AZ 900: Azure Fundamentals Exam Questions and Answers Already Passed What types of attacks can a Web Application Firewall (WAF) protect from? Cross Site Scripting (XSS) attacks Not DDoS (DDoS protection is offered separately, not part of the firewall) Scenario: You have an application in the cloud that has 10 servers with various roles. Six servers are D2S machines, two servers are D4S, and two are D8S instance types. This application is expected to run for years, but the business has...

You plan to get data for a Power BI dataset from flat files. You need a location type to store the files. The date must NOT automatically synchronize between the original file and the dataset. Which location type should you recommend? Local File The local file option will result in importing the file contents without providing automatic synchronization between the original file and the dataset. SharePoint - Team Sites, personal OneDrive accounts, and OneDrive for Business provide the abili...

WGU D204 Data Analytics Exam Questions and Answers 100% Pass Lack of Organization and Lack of Sponsor Support - Answer- What are some of the main reasons that projects fail? Hacking Skills, Math and Statistics, and Domain Expertise - Answer- What is the Venn Diagram for Data Science? Discovery - Answer- Define Goals, Ask Questions, Develop a Problem Statement, Organize Resources Data Acquisition - Answer- Gather Data through API's, Open Data, Passive Data, and internal/external sources...

If you want your data to automatically refresh as you interact with visualizations, which option should you choose? A) Import B) DirectQuery - B) DirectQuery Explanation: When you use DirectQuery, no data is imported into Power BI Desktop. As you create or interact with a visualization, PowerBI Desktop queries the underlying data source, i.e. you're always viewing current data. How do you connect to Excel files that contain target figures? The solution should involve minimum manual work...