it works like any other video card. yes it does enhance the real time "rendering" in maya (the viewports). if you software render the quadro card is no advantage. maya uses the card automatically. you should check in your driver setting to enhance the settings for maya.
hope that helps