nerdexam
Microsoft

70-177 · Question #109

Which of the following Project Server databases contains near real-time data from the Published database, organized in tables that are read-only and optimized for report generation?

The correct answer is D. Reporting. The Reporting database contains near real-time data from the Published database, organized in tables that are read-only and optimized for report generation. Answer option B is incorrect. The Published database Stores published projects and all enterprise data such as outline…

Administering Project Server 2010

Question

Which of the following Project Server databases contains near real-time data from the Published database, organized in tables that are read-only and optimized for report generation?

Options

  • ASharePoint Admin Content
  • BPublished
  • CWSS Search
  • DReporting

How the community answered

(18 responses)
  • A
    6% (1)
  • B
    6% (1)
  • C
    11% (2)
  • D
    78% (14)

Explanation

The Reporting database contains near real-time data from the Published database, organized in tables that are read-only and optimized for report generation. Answer option B is incorrect. The Published database Stores published projects and all enterprise data such as outline codes, security, and metadata. It also contains PWA specific tables such as timesheets, views, and so on. Answer option A is incorrect. The SharePoint Admin Content database contains the content associated with the Central Administration site. Answer option C is incorrect. The WSS Search database contains the metadata for WSS help files. What is Windows SharePoint Services (WSS)? Windows SharePoint Services (WSS) is a technology used to increase the efficiency of business processes and improve team productivity. It is used to create Web-based environment in which users can share information and documents. It provides a single workspace for teams to coordinate schedules, organize documents, and participate in discussions within the organization and over the extranet. WSS is easy to use and can be deployed rapidly because of its familiar Web-based interface and close integration with tools such as the Microsoft Office.

Topics

#Reporting database#Project Server databases#read-only data#report optimization

Community Discussion

No community discussion yet for this question.

Full 70-177 Practice