| CATEGORII DOCUMENTE |
| Bulgara | Ceha slovaca | Croata | Engleza | Estona | Finlandeza | Franceza |
| Germana | Italiana | Letona | Lituaniana | Maghiara | Olandeza | Poloneza |
| Sarba | Slovena | Spaniola | Suedeza | Turca | Ucraineana |
The School of Fine Art is a large regional university with more than 45,000 students. Currently, the university manages course scheduling and course registration by using applications that run on an AS/400 computer. However, this solution is no longer adequate.
The university has a long-term goal of migrating away from all of its existing AS/400 applications. You are contracted for a short term goal. You will replicate and extend the existing functionality course scheduling and course registration in a new Windows-based solution. Your solution will consist of a new administrative application and associated user applications. You will develop the new application by using the Microsoft .Net Framework and Microsoft SQL Server
The university uses two AS/400 applications to provide the existing functionality for scheduling and registration:
A scheduling application is used by administrators, academic counsellors and professors to establish and review course schedules for the upcoming academic term
A registration application is used by students to register for the upcoming academic term
Both of these applications use a DB2 database named REG2. This database contains all current information relating to students, professors, course schedules and registrations.
Both of these applications can be accessed by using dedicated terminals located on campus, or by using terminal emulation software on computers that are connected to the university network. Both applications will be replaced as part of the new solution
The university has two additional AS/400 applications, which were developed by a single software vendor:
A grading application is used by professors to assign course grades to students at the end of each academic term
A transcript application is used by administrators to generate official student transcripts
The grading application and the transcript application use a DB2 database named TRANS2. This database contains records of all courses completed by each student and all grades received by each student. TRANS2 and the associated applications will not be replaced.
Four registration periods occur each year. Each registration period begins one month before the beginning of an academic term. Registration closes when the term begins. A summary of student enrolment data is then exported by a batch export operation from REG2 to TRANS2.
We want to make it impossible for students with overdue tuition accounts to register for courses.
Currently, students must wait in long lines to use dedicated terminals or on-campus computers during each registration period. We want to enable students to register over the Internet. In addition, we want to enable professors, academic counsellors and administrators to access the new administrative application over the internet.
Our existing scheduling application lets us specify prerequisite courses only in a very simple way. We can specify prerequisite relationships of the following type: ARTHI 101 and ARTHI 202 are required before registering for ARTHI 303. However, we need to be able to specify more complex prerequisite relationships, such as ARTHI 101 and ARTHI 202 are required, or ARTHI 301 is required, before registering for ARTHI 303.
Currently, a student cannot register for a course if it is fully enrolled or if the student has not completed the prerequisites. The professor who currently teaches a course section can issue various waivers. One type of waiver authorizes a student to register in a course section that is fully enrolled. Another type authorizes a student to register for a course section without completing the prerequisites.
Currently a professor issues a waiver by signing a paper form and sending it to the IT department. However, we want the new administrative application to enable professors to issue waivers online. After a professor issues an online waiver, the student should be able to register for the appropriate course.
If a student transfers from another university, the students academic history will not exist in TRANS2. This omission can cause problems with prerequisite requirements. Academic counsellors must be able to use the new administrative application to issue prerequisite waivers on the basis of our own evaluation of a students academic history. When an academic counsellor issues a waiver, it must apply to all sections of a course, except for sections that are fully enrolled.
High availability is critical to the success of this solution. We can have no single point of failure. For maximum scalability and flexibility, we do not want any Web server session affinity.
Initially, the IT department will generate an XML file to populate the new SQL Server database from REG2.
At the end of each registration period, we must be able to import into TRANS2 a list of all courses for which a student is registered. We need this information in an XML file format. All information about courses that students have already completed must be stored only in TRANS2.
At the end of each registration period, all course registration information for students should be archived and then removed from the SQL Server database.
We have the Microsoft OLE DB Provider for DB2, which will enable access to student transcript data from TRANS2
Each course is worth between one and six credits. Tuition for each term is calculated on the basis of the total number of credits for which a student is registered during that term. Information about student tuition accounts is stored in an Oracle database named Accounting. This database is located on the same intranet that the new solution will use. Whenever a student adds or drops a course, the new student registration application must update the credit information for the student in Accounting. The credit data in Accounting must reflect the total number of credits for which the student is registered.
We can also provide the SQL statements needed to update credit data and to establish whether a students tuition account is past due. We have an OLE DB provider for Oracle and Oracle supports the Microsoft Distributed Transaction Coordinator (MS DTC).
The university offers thousands of different courses each year. Each course has a name (for example, Introduction to Art History), a department code (for example, ARTHI), a three-digit course number (for example, 101) and a number of credits(for example, 5). Each course is taught in one or more sections.
However, not all courses are taught every term. Zero, one, or more than one section of any course might be offered in any given term. Therefore, the professor, section identifier, location, meeting time and maximum student count are properties of a section of the course rather than of the course itself.
1. You must minimize the time required to establish whether a course section is fully enrolled. What are two possible ways to achieve this goal?(Each correct answer presents a complete solution. Choose two)
|
h) |
Keep a hash table of enrolment counts for each course section. Save the hash table in the ASP.NET Cache object. |
|
i |
Keep a hash table of enrolment counts for each course section. Save the hash table in the ASP.NET Application object. |
|
j) |
Create an index on the CourseSectionID foreign key column in the StudentCourseSection table. |
|
k) |
Denormalize the course registration database so that the CourseSection table contains a column for enrolment count. |
|
l) |
2. The Web application for the student registration includes business logic that queries TRANS2. The purpose of the query is to establish whether a student satisfies the prerequisite requirements for a course. Preliminary testing shows that the query is slow. To optimize access to transcript data, you need to minimize the number of these queries. What should you do?
|
m) |
Store the students transcript data in the ASP.NET Session object. Use the default session state configuration |
|
n) |
Cache the students transcript data in a session cookie. |
|
o) |
Use ASP.NET page caching |
|
p) |
Store the students transcript data in the ASP.NET Session object. Configure ASP.NET to store session state in a Microsoft SQL Server database |
|
q) |
3. You want to simplify the code that embodies security restrictions and exception handling. You also want to minimize redundant code. What should you do?
|
r) |
Use Microsoft Visual Studio .NET Enterprise templates |
|
s) |
Use Microsoft .NET reflection |
|
t) |
Derive all classes in your solution from a single base class that implements best practices |
|
u) |
Apply attributes |
|
v) |
Use utility components |
|
w) |
4. Your developers are allowed to use only the project types and components that are approved by your architectural guidance team. You need to establish a process to ensure that the developers comply with this guideline. This process should be as automatic as possible. What should you do?
|
x) |
Create and distribute a Microsoft Visual Studio .NET Enterprise template |
|
y) |
Use Enterprise Services components |
|
z) |
Establish a code review process |
|
aa |
Write and distribute a white paper detailing your architectural policies |
|
bb) |
Which new module or modules should you develop for the school of Fine Arts? (Choose all that apply)
|
cc) |
An accounting database |
|
dd |
A Web application for administrators, academic counsellors and professors |
|
ee |
A course registration database |
|
ff |
An application to report transcripts |
|
gg |
A Web application for student registration |
|
hh |
A utility to export course registration data |
|
ii) |
5. You are creating a list of business requirements for your solution. Which two requirements should you include?(Each correct answer presents part of the solution. Choose two)
|
jj |
A professor can grant a student a waiver from a prerequisite requirement for any course section |
|
kk |
A professor can grant a student a waiver from a prerequisite requirement for any course section that he or she teaches |
|
ll |
An academic counsellor can grant a student a waiver from a prerequisite requirement for any course section |
|
mm) |
An academic counsellor can grant a student a waiver to enrol in a course section even if it is fully enrolled |
|
nn |
6. You are writing the functional specification for your solution. You need to specify the data integration needs and the migration needs for transferring data to and from the existing REG2 and TRANS2 databases. Which two statements should you include n your specification?(Each correct answer presents part of the solution. Choose two)
|
a) |
The new student registration application must query historical transcript data in REG2. |
|
b) |
Student data, professor data and course schedule data from REG2 are needed to initially populate a Microsoft SQL Server course registration database. |
|
c) |
Student data, professor data and course schedule data from REG2 will be needed each term to populate the Microsoft SQL Server course registration database. |
|
d) |
The new student registration application must query historical transcript data in TRANS2. |
7. You are writing the technical specification for your solution. You need to implement a class that will retrieve information about tuition account status from the Accounting database. Which implementation should you specify?
|
a) |
A queued component |
|
b) |
A Microsoft .NET serviced component that requires a transaction |
|
c) |
A Microsoft .NET class that is not a serviced component |
|
d) |
An XML Web service proxy class |
8. You are writing the technical specification for your solution. You need to implement a class that will update information about course credit in the Accounting database. Which implementation should you specify?
|
a) |
A queued component |
|
b) |
A Microsoft .NET serviced component that requires a transaction |
|
c) |
A Microsoft .NET class that is not a serviced component |
|
d) |
An XML Web service proxy class |
9. You are using Object Role Modeling (ORM) to model data relationships between courses and course sections. You plan to use entities named Course and CourseSection. Which fact should you include in your model?
|
a) |
CourseSection has a name |
|
b) |
It is possible that the same CourseSection is of more than one Course and that the same Course has more than one CourseSection |
|
c) |
Course has CourseSection. CourseSection is of Course |
|
d) |
Course has a location |
10. Tou are creating the primary scenario for a use case named Student registers for a course. You need to identify the actions that should be part of the primary scenario. Move the appropriate actions from the Possible Actions pane and arrange them in the appropriate order.(Use only actions that apply)
|
Possible actions |
Primary scenario actions |
|
Application exports course enrolment data in an XML text file | |
|
Student selects course for which to register | |
|
Application enters course enrolment data in TRANS2 | |
|
Application queries REG2 to verify that the course is not fully enrolled | |
|
Application updates course credits in the Accounting database | |
|
Application queries REG2 for prerequisite requirements and then queries | |
|
TRANS2 to verify that requirements are met | |
|
Application registers student for any prerequisites that are unmet | |
|
Application registers student in course |
11. You need to identify the sequence of decisions that are required when a student tries to register for a course section. Proposed sequences are shown in the sequence diagrams. Which diagram should you use?
|
a) | |
|
b) | |
|
c) | |
|
d) |
12. To create the logical data model for your solution, you need to identify the relationships between the Student, Course and CourseSection entities. Which two entity relationships should you identify?(Each correct answer presents part of the solution. Choose two)
|
a) |
There is a many-to-many relationship between the Course entity and the CourseSection entity |
|
b) |
There is a many-to-many relationship between the Course entity and the Student entity |
|
c) |
The Course entity is a parent of the CourseSection entity |
|
d) |
The Student entity is a parent of the CourseSection entity |
|
e) |
There is a many-to-many relationship between the CourseSection entity and the Student entity |
|
f) |
The Student entity is a parent of the Course entity |
13. The new administrative application will be used by administrators, professors and academic counsellors. You need to select a mechanism that will authorize the use of application functionality on the basis of user type. Which mechanism should you use?
|
a) |
Access Control List (ACL) based security |
|
b) |
Integrated Windows authentication |
|
c) |
Microsoft .NET role-based security |
|
d) |
Code access security |
14. You are creating the physical design of the Web application for student registration. Your design includes a Web page that shows all course names within a selected department. The content of this page will change once each term. The page is generated slowly. You want to optimize its generation. What should you do?
|
a) |
Store the list of courses for each department in a session cookie |
|
b) |
Store the list of courses for each department in the ASP.NET Application object |
|
c) |
Store the list of courses for each department in the ASP.NET Session object |
|
d) |
Use ASP.NET page caching |
15. You are designing a utility to export all data from REG2 to an XML file. The utility must write important messages to an event log. You must choose a log type. What are two possible log types for you to use?(Each correct answer presents a complete solution. Choose two)
|
a) |
The Application log |
|
b) |
The system log |
|
c) |
The security log |
|
d) |
A custom log |
|
Politica de confidentialitate | Termeni si conditii de utilizare |
Vizualizari: 1330
Importanta: 
Termeni si conditii de utilizare | Contact
© SCRIGROUP 2024 . All rights reserved
