Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 20 of 134
Free Preview · 134 of 444 · questions 1–134 of 444 are free. Sign up free to sync your progress across devices.
Hot Area / Sentence Completion
Select the appropriate option to complete the statement. Click Check Answer below to see the marked solution.
Hotspot Solution:
Command timeout in minutes: If your connection lasts longer than 10 minutes (the default timeout), you can enter another value in minutes to keep the connection open longer. This option is only available in Power Query Desktop. Navigate using full hierarchy: If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
* Answer: - Default timeout for the connection: 10 minutes (Power BI Desktop uses a default command timeout of 10 minutes when the field is left blank.) - Navigator will display: All the tables (Because “Include relationship columns” is checked, but hierarchy navigation is not enabled, Navigator still shows all tables in the database.)
Command timeout in minutes: If your connection lasts longer than 10 minutes (the default timeout), you can enter another value in minutes to keep the connection open longer. This option is only available in Power Query Desktop. Navigate using full hierarchy: If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data.
Correct answer