Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Certiport Software Development #1 revision test/updated version, Exams of Advanced Education

Cheyney University of PennsylvaniaAdvanced Education

Certiport Software Development #1 revision test/updated version

Typology: Exams

2025/2026

Available from 04/17/2026

tizian-mwangi
tizian-mwangi 🇺🇸

4.1

(8)

29K documents

1 / 7

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
1 /
7
Certiport Software Development #1 revision test/updated version
1. The server limits data connections. What should
you use for connectivity when the number of users
exceeds the number of connections?
A.)Named Pipes
B.)Connection Pooling
C.)Connection Timeouts
D.)Normalization
B.)
Connection
Pooling
2.
The
database
administrator
will
not
allow
you
to
write
A.) Call a stored
procedure
SQL code in your application how do you retrieve
data?
A.)Call a stored procedure
B.)Script a SELECT statement to a file
C.)reference an index in the database
D.)Query a database view
3.
A database dictionary that describes the structure of a
D.)
Metadata
database is called
A.)
DBMS
B.)Metacontent
C.)Normalization
D.)Metadata
4.
You need to ensure the data integrity of a database by
C.)
Normalization
resolving insertion, update, and deletion
anomalies. Which term is used to describe this
process?
A.)Resolution
B.)Integration
pf3
pf4
pf5

Partial preview of the text

Download Certiport Software Development #1 revision test/updated version and more Exams Advanced Education in PDF only on Docsity!

1 /

  1. The server limits data connections. What should you use for connectivity when the number of users exceeds the number of connections? A.)Named Pipes B.)Connection Pooling C.)Connection Timeouts D.)Normalization B.) Connection Pooling
  2. The database administrator will not allow you to write A.) Call a stored procedure SQL code in your application how do you retrieve data? A.)Call a stored procedure B.)Script a SELECT statement to a file C.)reference an index in the database D.)Query a database view
  3. A database dictionary that describes the structure of a D.) Metadata database is called A.)DBMS B.)Metacontent C.)Normalization D.)Metadata
  4. You need to ensure the data integrity of a database by C.) Normalization resolving insertion, update, and deletion anomalies. Which term is used to describe this process? A.)Resolution B.)Integration

2 / C.)Normalization D.)Isolation

  1. Your database has a table called students that contains B.) SELECT firstName, last- the following fields: firstNamelastNameemailAddressphone You need to get the firstName, last Name, and email for all students listed alphabetically by last name and then first name. A.)SELECT lastName, firstName FROM students OR-DER BY lastName, firstName B.)SELECT firstName, lastName, email FROM students ORDER BY lastName, firstName C.)SELECT firstName, lastName, email FROM students ORDER BY firstName, lastName D.)SELECT firstName, lastName FROM students OR-DER BY lastName, firstName
  2. Your application must pull data from a database on a separate server. What must you do? A.)Install the database on each client computer B.)Establish a connection to the database by using the appropriate data provider C.)Create a routine that bypasses firewalls D.)Configure the network routers to allow database connections
  3. Using Asp.net, you need to store a value that can be shared across users on the server A.)Application Name, email FROM stu-dents ORDER BY lastName, firstName B.) Establish a connection to the database by us-ing the appropriate data provider A.) Application

4 / A.)Implement the Console.WriteLine method through-out the Windows Service. B.)Set the Windows Service status to Paused. C.)Write all events to an event log. D.)Use the Attach to Process menu in Microsoft Visual Studio.

  1. What is the gesture when running your finger across a Swiping device?
  2. What is displayed on the Surface tablet when this ges- App bar ture is performed?
  3. To minimize the time between when a race official records the results and when the results are available on the web, which part of the system is critical?
  4. To increase the number of students that can access race results, what element should be added to the system?
  5. To minimize the amount of storage used on the hard drive by an application that generates many small files, you should make the as small as possi-ble. A.)Partition B.)No answer text provided. C.)File allocation table D.)Block size
  6. Which two types of information should you include in an effective test case? (Choose two.) Satellite Link Web Application Servers D.) Block size A.) any pre- conditions necessary to test the case

5 / A.)any pre-conditions necessary to test the case B.)the expected result from testing the case C.)multiple actions combined as a single step to test the case D.)the stakeholders who originated the test case B.)the expected result from testing the case

  1. The Dog class and the Cat class inherit from the Animal D.) Polymorphism class. The Animal class includes a breathe() method and a speak() method. If the speak() method is called from an object of type Dog, the result is a bark. If the speak() method is called from an object of type Cat, the result is a meow. Which term is used to describe this object- oriented concept? A.)Encapsulation B.)No answer text provided. C.)Data hiding D.)Polymorphism
  2. In your student directory database, the Students table SELECT firstName, last- contains the following fields: firstName lastName emailAddress telephoneNumber You need to retrieve the data from the firstName, last-Name, and emailAddress fields for all students listed in the directory. The results must be in alphabetical order according to lastName and then firstName.
  3. What are two advantages of normalization in a data-base? Choose two. Name, emailAddress FROM Students ORDER BY lastName, firstName B.) minimizes impact of data

7 / A.)decreases space on disk B.)minimizes impact of data corruption C.)reduces schema limitations D.)prevents data inconsistencies

  1. You have a base class named Tree with a friend prop-erty named color and a protected property named NumberOfLeaves. In the same project, you also have a class named Person. Q1: Methods in the Person class can access the color property Q2: Methods in the Person class can access the Num-berOfLeaves property Q3: Methods in the Tree class can access all private properties in Person
  2. The specifications require a class that cannot be in-stantiated but can specify methods that must be im-plemented in concrete inherited classes. A.)abstract B.)public C.)sealed D.)stub D.) prevents data inconsis-tencies Q Yes Q No Q No C.) sealed
  3. When creating a site to utilize message queuing, the ip A.) Protocol must be configured to MSMQ. A.)Protocol B.)Address