Directquery - Study guides, Class notes & Summaries

An app is the creation of official ___ content. Does it make managing permissions easier? An app is the creation of official packaged content. Managing permissions is easier with apps. What are 3 ways to get app access? How about for external users? 3 ways to get app access: install through AppSource, receive a direct link, (applies to external users) automatically install via admin permission. In an App, where can you add a link to an external resource? In the Navigation pane, U...

DA-100 Exam Practice Questions and Answers 100% Pass A custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size. - Remove the Subject and Body columns during the import. >Removing col reduce size of model Surface videos directly in a Power BI dashboard. Which tile? -...

PowerBI CERTIFICATION EXAM 2025 | QUESTIONS WITH VERIFIED 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. you're always viewing current data. How do you conne...

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...

The addition of two different RLS filters allows the member of both of them to see data for ___ and not just the ___ of them. - ️️The addition of two different RLS filters allows the member of both of them to see data for the RLS_1 as well as for the RLS_2, not just their intersection. (I.e. The member will see all the data that have ''USA'' as Store[State] or ''T-shirts'' as Product[ProductName].) With a Power BI Premium license, you have the ability to share Po...

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...

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 ...

DA100 - Practice Questions with Correct Answers An app is the creation of official ___ content. Does it make managing permissions easier? - An app is the creation of official packaged content. Managing permissions is easier with apps. What are 3 ways to get app access? How about for external users? - 3 ways to get app access: install through AppSource, receive a direct link, (applies to external users) automatically install via admin permission. In an App, where can you add a link to an ex...

DA-100 Exam Prep QUESTIONS & ANSWERS 100% CORRECT You have tables. 30 million records. You need ad analytics system. Which two actions? - Group the impressions in power query. Create one-to-many relationships between tables. Training videos published to Microsoft stream need to be in PowerBI dashboard. Which tile to add? - custom streaming data You open a query. Need to identify the percentage of empty values in each column. Which data preview option? - column quality Prospective custome...

Power BI Pl300 Certification Test | Complete Questions & Answers (100% Correct) Power BI Pl300 Certification Test | Complete Questions & Answers (100% Correct) You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.) The data has the following refresh requirements: Customer must be refreshed daily. Date must be refreshed once every three years. Sales must be refreshed in near real time . SalesAggregate must be refreshed once per week. You need to select th...