👉Get Full PDF
| Question.6 You plan to publish your SSAS Tabular (live connection) data model to Power BI Service. What must be used in order for this to be possible? (A) Data Gateway (B) Dual Storage Mode (C) Parameters (D) Admin Privileges |
6. Click here to View Answer
Answer is (A) Data Gateway
Data Gateways are required for on-premises data sources, like SSAS Tabular live connections.
| Question.7 Which of the following sources can Power BI connect to? (A) SQL Database (B) Google Analytics (C) R scripts (D) All of the above |
7. Click here to View Answer
Answer is (D) All of the above
Power BI can connect to virtually any type of data source, including (but not limited to) SQL databases, R scripts, and Google Analytics.
| Question.8 What is the Query Editor used for? (A) As a cloud-based storage option for your organization’s data (B) To shape & transform data, then load it into Power BI (C) To create relationships between data and lookup tables (D) To create measures & calculated columns using DAX |
8. Click here to View Answer
Answer is (B) To shape & transform data, then load it into Power BI
Once you connect to data, the Query Editor lets you shape & transform the data to meet your needs, then load that model into Power BI Desktop
| Question.9 In which storage mode are tables solely stored in-memory and queries fulfilled by cached data? (A) Import (B) DirectQuery (C) Dual (D) Native |
9. Click here to View Answer
Answer is (A) Import
In import storage mode, tables are stored in-memory, whereas in DirectQuery tables are connected directly to the source. Dual storage mode allows tables to come from in-memory data or by an on-demand query to the data source.
| Question.10 When should you use DirectQuery? (A) The source data never changes (B) Company policy states no data source restrictions (C) Dataset is too large to be stored in-memory (D) All of the above |
10. Click here to View Answer
Answer is (C) Dataset is too large to be stored in-memory
Use DirectQuery when the dataset is too large to be stored in-memory, when the source data changes frequently & reports must show the most recent data, and when the company policy states data can only be accessed from the original source.