You attempt to connect Power BI Desktop to a Cassandra database.
From the Get Data connector list, you discover that there is no specific connector for the Cassandra database.
You need to select an alternate data connector that will connect to the database.
Which type of connector should you choose?
When attempting to connect Power BI Desktop to a Cassandra database without a specific connector, the ODBC (Open Database Connectivity) connector is the most suitable alternative. ODBC is a general-purpose interface that allows connection to various types of databases through ODBC drivers. By using the ODBC connector, you can establish a connection to the Cassandra database and retrieve data using the standard API provided by the ODBC driver. This makes ODBC the most versatile and appropriate choice for connecting to databases not natively supported by Power BI's specific connectors.
B is Correct because, B´cause it allows you to connect to data sources that aren't identified in the Get Data lists. The ODBC connector lets you import data from any third-party ODBC driver simply by specifying a Data Source Name (DSN) or a connection string. As an option, you can also specify a SQL statement to execute against the ODBC driver. List details a few examples of data sources to which Power BI Desktop can connect by using the generic ODBC interface: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-using-generic-interfaces
Great question. Great answer! Thank you so much.
Gracias por la explicación :)
The anwer is B * Cassandra has an ODBC driver available that can be used to connect to the database using the ODBC connector in Power BI. * Microsoft SQL Server database is specifically designed to connect to SQL Server databases, * OLE DB is designed to connect to Microsoft databases and other third-party databases, * OData is designed to connect to web-based data sources
This question was in Exam today.
To connect Power BI Desktop to a Cassandra database when there is no specific connector available, you should choose option B: ODBC (Open Database Connectivity) connector. ODBC is a widely-used standard for connecting to various types of databases, including Cassandra. It provides a common interface that allows applications like Power BI to communicate with different database systems using the same API. By leveraging the ODBC connector, you can establish a connection to the Cassandra database and retrieve data for analysis and visualization in Power BI.
This was on the exam
B is the correct answer. ODBC (Open Database Connectivity) is a general-purpose data access that allows us to connect to a wide range of databases, including Cassandra, using ODBC drivers.
this was on exam on 14/03/2024 i scored 948 my answer was B ODBC
28-Mar-24 - This Q came up. Blitzed all 266 Q's on Exam Topics and Scored 813/1000. Only 1 question out of the 50 wasn't on exam topics exactly.
given exam on 21th Oct 2023 , This Question is in the exam . I scored 79 , No need to take ful version most of the question covern under 24 pages only.
This Question was in exam (05/21/2024) Correct answer is B
Was at the exam on February 12th 2024
21-feb- 2024, Scored 920 My answer ODBC
Given answer is correct
odbc allows connection to third party database
Open database connector
correct
ODBC allows to connect other DB