Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 58 discussion

Actual exam question from Microsoft's 70-778

Question #: 58
Topic #: 1

You have a service published to a website.
When you connect to the website, you receive the following data.

You need to create a query that retrieves the Categories data and the Customers data.
Which type of source should you use?

A. JSON
B. Text/CSV
C. OData Feed
D. XML

Show Suggested Answer

Suggested Answer: D 🗳️

by nose at March 28, 2020, 4:18 p.m.

Comments

Submit Cancel

nose

Highly Voted 5 years, 2 months ago

this is C. OData Feed if you want to retrieve data.... https://services.odata.org/V3/Northwind/Northwind.svc/

upvoted 12 times

r8d1

5 years ago

the top of your link shows this as an XML file.

upvoted 2 times

r8d1

4 years, 11 months ago

sample xml: https://services.odata.org/V2/Northwind/Northwind.svc/ sample json: https://blog.exploratory.io/working-with-json-data-in-very-simple-way-ad7ebcc0bb89 sample OData: https://services.odata.org/V2/Northwind/Northwind.svc/Products?$format=json&$top=2&$orderby=ProductName%20desc https://docs.microsoft.com/en-us/odata/overview

upvoted 1 times

...

angelluc

4 years, 11 months ago

I think you are rght https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-odata

upvoted 1 times

...

asdfefd

4 years, 8 months ago

I agree here. I tested using OData Feed data source type to connect to the service and was able further view the Categories and Customers data. If I select XML, it just asks for a local XML file which is not what the question is asking for.

upvoted 3 times

...

asgafsaf

Most Recent 3 years, 9 months ago

OData Feed is correct I think

upvoted 1 times

...

Sivakami

3 years, 9 months ago

Ans: C.OData feed ... Tested it

upvoted 1 times

...

nemanjaandic

4 years, 3 months ago

It is OData Feed. There is also "atom" text (xmlns:atom.... atom:title...) https://www.odata.org/documentation/odata-version-2-0/atom-format/

upvoted 1 times

...

EshaM

4 years, 4 months ago

https://www.kizan.com/blog/consuming-xml-web-service-data-in-power-bi

upvoted 1 times

...

Lhouss

4 years, 6 months ago

C is the correct anwswer. https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-odata D is not possible as the XML contains only description of collections (customers...etc) and NOT underlying data.

upvoted 1 times

...

CDL

4 years, 7 months ago

I go with C. OData supports two formats for representing the resources (Collections, Entries, Links, etc) it exposes: the XML-based Atom format and the JSON format. Ref Link: https://www.odata.org/documentation/odata-version-2-0/atom-format/

upvoted 1 times

...

cromastro

4 years, 9 months ago

It's XML. It says so in the actual data ... xmlns ... (xml namespace)

upvoted 1 times

...

pbia

4 years, 11 months ago

XML Odata3 feeds looks like XML but OData4 is more kinda json. But the code above looks like more of xml so xml

upvoted 1 times

...

123

4 years, 11 months ago

O Data feed https://www.bing.com/images/search?view=detailV2&ccid=Sjr2UCn6&id=6CEB2AAE95A867A755553B336480D13CA6AD4F6F&thid=OIP.Sjr2UCn6eAMxv90o1zHM5wHaEV&mediaurl=https%3a%2f%2fmsdnshared.blob.core.windows.net%2fmedia%2fMSDNBlogsFS%2fprod.evol.blogs.msdn.com%2fCommunityServer.Blogs.Components.WeblogFiles%2f00%2f00%2f01%2f52%2f63%2fmetablogapi%2f6735.image_thumb.png&exph=426&expw=727&q=example+of+an+odata+feed&simid=608006213237083867&ck=D926CDF110F0E6FA9379D74E1A4A2582&selectedindex=0&ajaxhist=0&first=1&scenario=ImageHoverTitle

upvoted 2 times

...