Exam PL-300 topic 13 question 1 discussion

No (it's Azure SQLDB; cloud based) No (we need Direct Query) No (we use Azure AD; OAuth2)

No - Azure SQL Server, therefore no need for an on-premise Gateway as Service and Azure are in the cloud. No - DirectQuery mode for the DB connection, so no need to schedule a refresh. DirectQuery is a live connection. No - Azure SQL supports the following connections from Power BI: Windows, Database and Microsoft Account. (Basic is reserved for Power Query Online. Do not confuse Database with Basic.): https://learn.microsoft.com/en-us/power-query/connectors/azuresqldatabase https://learn.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-database-with-direct-connect

from the link https://learn.microsoft.com/en-us/power-query/connectors/azure-sql-database. It states in the summary section that, "Authentication types supported Windows (Power BI Desktop, Excel, Power Query Online with gateway) Database (Power BI Desktop, Excel) Microsoft Account (all) Basic (Power Query Online) Service Principal" So for the 3rd statement, I think it is "YES".

in the exam today, 12/30/2023

on exam today

Guys, take into account (Direct Query) = Oauth2. There is no Basic connection No No No

No, No, No.

No, it's a Azure SQL DB - No nned to use gateway No, we use Direct Query, so no need to set refresh schedules Yes, it says: "yon can use..." not "you can ONLY use", which is true, we can use basic or OAuth2

No No Yes

The third question stated that "you can use" which I feel it's a question of Yes, I can or No, I can't. Since we can use it, then I am of the opinion that YES is the right answer

Box1: No Here below is directly copied from PowerBI service gateway connection configuration page for a dataset that comes out of an Azure SQL database. "You don't need a gateway for this dataset, because all of its data sources are in the cloud, but you can use a gateway for enhanced control over how you connect". The question asks if gateway is needed. No you do not need a gateway, but you can use a gateway. Box2: No Again, you do not "need" to configure a scheduled refresh of the dataset if DirectQuery is used, but nothing stops you doing so. Box3: Yes There are two authentication methods, being basic and OAuth2, you might use on the dataset to connect to the database/data. With basic authentication method, you will be asked for user name and password. If you use database credential here, you can use the Basic Authentication method. You can use basic authentication but it does not mean you have to use it.

1- You definitely don't need a gateway as Azure SQL is could based. 2- The question says that "transactions must be updated within 5 minutes". Therefore, (unless you plan to create a composite model) you should connect to the DB in direct query mode, hence you don't need to schedule any refresh. 3- Azure SQL allow to use OAuth2. This doesn't mean that you can't use basic authentication anymore. The question asks if you CAN use basic authentication and you can still use it, even though you have the option to use azure authentication. In my opinion the answer is : NO, NO , YES !

Isn't the Azure SQL database - cloud base? Do we still need gateway?