Directquery - Study guides, Class notes & Summaries
Looking for the best study guides, study notes and summaries about Directquery? On this page you'll find 42 study documents about Directquery.
Page 2 out of 42 results
Sort by
-
PowerBI Certification Exam (2023) | Questions & Answers (Graded A+)
- Exam (elaborations) • 18 pages • 2023
-
- $10.99
- + learn more
PowerBI Certification Exam (2023) | Questions & Answers (Graded A+) 
PowerBI Certification Exam (2023) | Questions & Answers (Graded A+) 
 
If you want your data to automatically refresh as you interact with visualizations, which option should you choose? 
A) Import 
B) DirectQuery - ANSWER - 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. ...
-
Power BI Desktop & Service exam questions and answers 2024
- Exam (elaborations) • 11 pages • 2024
-
- $15.99
- + learn more
When is the Assume Referential Integrity option available, and what does it accomplish? 
1) Available in the Edit Relationships menu when connected to data source(s) using DirectQuery 
 
2) Enables queries on the data source(s) to use INNER JOIN statements rather than OUTER JOIN, which improves query efficiency 
 
 
 
What are the requirements for using the Assume Referential Integrity option when connecting to data? 
1) Data in the 'Many' side of the table relationship (foreign key) is never ...
-
PL 300: Power BI MS Data Analyst practice exam questions fully solved & updated
- Exam (elaborations) • 7 pages • 2024
-
- $16.49
- + learn more
Which query language do you use to extract data from Microsoft SQL Server? 
DAX 
T-SQL 
MDX 
T-SQL 
 
 
 
You're creating a Power BI report with data from an Azure Analysis Services Cube. When the data refreshes in the cube, you would like to see it immediately in the Power BI report. How should you connect? 
Connect Live 
Import 
Direct Query 
Connect Live 
 
 
 
What can you do to improve performance when you are getting data in Power BI? 
Only pull data into the Power BI service, not Power B...
-
PL-300 PowerBI Exam Questions and answers already graded A+ 2024
- Exam (elaborations) • 33 pages • 2024
-
- $15.99
- + learn more
D (Visual2 and Visual5) 
You plan to embed multiple visualization in a public website. Your Power BI infrastructure contains the visualizations configured as shown. 
Visual1; characteristic: Uses row-level securitv (RLS) 
Visual2; characteristic: Uses a dataset that is stored in Microsoft OneDrive for Business 
Visual3; characteristic: Contained in a report that was shared to your user account 
Visual4; characteristic: Is a custom visual 
Visual5; characteristic: Uses a dataset from an on-premis...
-
PowerBI Certification Exam 2023 Verified 100%
- Exam (elaborations) • 18 pages • 2023
-
- $14.99
- + learn more
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...
As you read this, a fellow student has made another $4.70
-
PowerBI Certification Exam 2023 Verified 100%
- Exam (elaborations) • 18 pages • 2023
-
- $14.99
- + learn more
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...
-
PowerBI Certification Exam Prep 2 with 100% correct answers
- Exam (elaborations) • 12 pages • 2024
-
- $15.49
- + learn more
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...
-
PowerBI Certification Exam 2023 Verified 100%
- Exam (elaborations) • 18 pages • 2023
-
- $14.99
- + learn more
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...
-
Power BI Essential Training exam with complete solutions
- Exam (elaborations) • 13 pages • 2024
-
- $15.99
- + learn more
Role Hierarchy 
ADMN, Member, Contributor, Viewer 
 
 
 
Admin Role 
All responsibilities 
 
 
 
Member Role 
Same as Admin but cannot assign roles, delete workspaces, or change metadata 
 
 
 
Contributor Role 
Can create, update, and publish and set refreshes for content and reports but cannot publish apps, delete reports change metadata or assign roles 
 
 
 
Viewer Role 
Can only view information 
 
 
 
Auto Date Hierarchy 
Day, Month, Quarter, Year 
 
 
 
Lineage View 
Shows last refresh an...
-
Microsoft Power BI 70-778 Certification Exam | Questions & Answers (Rated A+)
- Exam (elaborations) • 18 pages • 2023
-
Available in package deal
-
- $10.99
- + learn more
Microsoft Power BI 70-778 Certification Exam | Questions & Answers (Rated A+) 
Microsoft Power BI 70-778 Certification Exam | Questions & Answers (Rated A+) 
 
You have a Power BI model for sales data. You need to create a measure to calculate the year-to-date sales and to compare those sales to the previous year for the same time period. Which DAX function should you use? 
a) PARALELLPERIOD 
b) SAMEPERIODLASTYEAR 
c) DATESYTD 
d) PREVIOUSYEAR - ANSWER - c) DATESYTD 
 
You have a Power BI report...
How did he do that? By selling his study resources on Stuvia. Try it yourself! Discover all about earning on Stuvia