DirectQuery When you use the DirectQuery connectivity mode, you are not caching any data in…