HOTSPOT - You publish the dataset to powerbi.com. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:
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".
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
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.
In Question #2Topic 5 we were asked to choose the DirectQuery connection that uses either a database credential or the end-user's credentials. I think most people go with a database credential. In that case, we may use the basic authentication here.
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 !
I disagree with you on the 3rd question. The requirement is that Litware uses Azure Active Directory (Azure AD) to authenticate users. Requirements must be adhered to.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
fdsdfgxcvbdsfhshfg
Highly Voted 2 years, 3 months agoNotMeAnyWay
Highly Voted 2 years, 2 months agoHenryBiz
Most Recent 6 months, 4 weeks agoCMPB
1 year agomadyjoe21
11 months agoAKUMAR2104
1 year, 5 months agoMadalina1
1 year, 4 months agormeng
1 year, 7 months agoUlyUkr
1 year, 7 months agonmosq
1 year, 11 months agoyoussef_yt89
2 years agoChokochoko
2 years agoAzureJobsTillRetire
2 years agoAzureJobsTillRetire
2 years agozerone72
2 years, 2 months agoWadyba
2 years agoJune15
2 years, 3 months agofdsdfgxcvbdsfhshfg
2 years, 3 months agoTsuk
2 years, 3 months ago