FC0-U71 Practice Test 29 — 15 Questions

Question 1

Refer to the exhibit. What is the purpose of the 'no shutdown' command in this router configuration?

Accepted Answer

Enable the interface. The 'no shutdown' command is used in Cisco IOS to administratively bring an interface from the 'administratively down' state to an operational 'up/up' state. By default, many router interfaces are placed in a shutdown state upon initial configuration, and issuing 'no shutdown' enables the interface to send and receive traffic.

Answer

Remove the IP address

Answer

Reset the interface configuration

Answer

Disable the interface

Question 2

A technician runs the ipconfig command and observes the following output:

IPv4 Address. . . . . . . . . . . : 192.168.1.10
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.1.1

Based on the output, which of the following can the technician conclude?

Accepted Answer

The computer can communicate on the local network. The output from commands such as ipconfig or ifconfig typically shows the computer's IP address and subnet mask. A valid IP address on a local subnet (e.g., 192.168.x.x with a 255.255.255.0 mask) indicates the computer can communicate with other devices on the same local network, as no gateway or internet access is required for local communication. The presence of a default gateway does not confirm internet access or DNS reachability without further testing.

Answer

The computer has internet access

Answer

The DNS server is reachable

Answer

The default gateway is not configured

Question 3

A technician is converting the decimal number 255 to binary. Which binary value is correct?

Accepted Answer

11111111. 255 in binary is 11111111 (eight 1s).

Answer

10000000

Answer

11111110

Answer

1111111

Question 4

Which THREE of the following are best practices for database normalization? (Choose three.)

Accepted Answer

Eliminate redundant data. Eliminating redundant data is a core goal of database normalization because it reduces storage requirements and prevents data inconsistencies. By ensuring each piece of data is stored in only one place, you avoid update anomalies that occur when the same fact is recorded in multiple rows or tables. This practice directly supports the second normal form (2NF) and third normal form (3NF) objectives of removing partial and transitive dependencies.

Answer

Use composite primary keys excessively

Answer

Create separate tables for each attribute

Question 5

A user needs to edit a video file for a presentation. Which type of application is most suitable?

Accepted Answer

Video editing software. Video editing software is specifically designed to manipulate video files, offering features like trimming, transitions, effects, and timeline-based editing. For editing a video file for a presentation, this type of application provides the necessary tools to adjust the video content, add text overlays, and synchronize audio, making it the most suitable choice.

Answer

Spreadsheet software

Answer

Database software

Answer

Audio editing software

Question 6

A company is developing a mobile app and wants to release a minimal set of features quickly, then add more features based on user feedback. Which methodology best supports this approach?

Accepted Answer

Agile. Agile methodology uses iterative development and adapts to changing requirements based on feedback.

Answer

V-Model

Answer

Spiral

Answer

Waterfall

Question 7

A developer is debugging a program that crashes with an error. Which THREE of the following are common debugging techniques?

Accepted Answer

Stepping through code line by line. Setting breakpoints, stepping through code, and inspecting variable values are standard debugging techniques. Rewriting the entire program is inefficient, and ignoring errors does not help.

Answer

Ignoring the error and continuing

Answer

Recompiling the entire program without changes

Question 8

A database designer wants to enforce that a 'CustomerID' value in an 'Orders' table must exist in the 'Customers' table. Which TWO methods can achieve this?

Accepted Answer

Use a trigger to check existence. A trigger can be programmed to check, before an INSERT or UPDATE on the Orders table, whether the new CustomerID exists in the Customers table. If the value is not found, the trigger can roll back the transaction, enforcing referential integrity without using a formal foreign key constraint. This is a valid method in database systems that support procedural logic within triggers.

Answer

Create a unique constraint on Orders.CustomerID

Answer

Create an index on Orders.CustomerID

Answer

Create a primary key on Customers.CustomerID

Question 9

A database administrator is designing a normalized database. Which TWO are benefits of normalization?

Accepted Answer

Reduces data redundancy. Normalization reduces data redundancy (Option A) and eliminates update anomalies (Option B). Option C is false because normalization often increases the number of joins, which can degrade query performance. Option D is false because normalization decreases redundancy. Option E is false because normalization typically results in more tables, not fewer.

Answer

Improves query performance

Answer

Increases data redundancy

Answer

Requires fewer tables

Question 10

A software development team is in the process of gathering requirements from stakeholders, identifying project scope, and creating a project plan. After this phase, they will move to analyzing requirements in detail. In which phase of the SDLC is the team currently working?

Accepted Answer

Planning. The team is gathering requirements, identifying scope, and creating a project plan, which are all activities of the Planning phase in the SDLC. The Analysis phase follows Planning and involves detailed requirement analysis, not the initial gathering and scoping. Therefore, option D is correct.

Answer

Analysis

Answer

Design

Answer

Implementation

Question 11

Which THREE of the following are common file formats for images?

Accepted Answer

.gif. The .gif (Graphics Interchange Format) is a common image file format that supports both static and animated images using lossless compression. It is widely used for simple graphics, logos, and animations on the web due to its support for up to 256 colors and transparency.

Answer

.mp3

Answer

.docx

Question 12

A user is unable to insert a new record into a database table because a required field is missing. Which database concept enforces that a field must have a value?

Accepted Answer

NOT NULL constraint. A NOT NULL constraint is a database rule that prevents a field from containing a NULL value, ensuring that a value must be provided for that column when inserting or updating a record. In this scenario, the user cannot insert a new record because the required field is missing, which directly violates the NOT NULL constraint. This constraint is enforced at the database engine level, typically during the INSERT or UPDATE operation, and will raise an error if the field is omitted or set to NULL.

Answer

Primary key

Answer

Index

Answer

Foreign key

Question 13

You are a junior developer at a small company that uses a monolithic web application written in Python. The application runs on a single server and uses a MySQL database. Recently, the application has become slow during peak hours. The operations team reports high CPU usage on the server. You suspect that the database queries are not optimized. You propose to refactor the application to use a caching layer. However, your manager is concerned about adding complexity and suggests that you first optimize the most frequently executed queries. You review the code and find that the most frequent query selects all columns from a large table without a WHERE clause. The table has over 1 million rows. Which course of action should you take?

Accepted Answer

Modify the query to include a WHERE clause that filters on an indexed column.. The query selects all columns from a large table without a WHERE clause, which forces a full table scan. Adding a WHERE clause that filters on an indexed column reduces the number of rows scanned, dramatically improving performance without introducing the complexity of a caching layer. This directly addresses the high CPU usage caused by inefficient query execution.

Answer

Implement a caching layer using Redis.

Answer

Upgrade the server to have more CPU and RAM.

Answer

Add an index on all columns used in the query.

Question 14

Which of the following storage types uses spinning platters to read and write data?

Accepted Answer

HDD. HDDs (Hard Disk Drives) use spinning magnetic platters, while SSDs use flash memory.

Answer

SSD

Answer

RAM

Answer

Cache

Question 15

A user is unable to open a .docx file. The user has the correct application installed. Which of the following is the MOST likely cause?

Accepted Answer

The file is corrupted.. The .docx file is a compressed XML-based format used by Microsoft Word. Even with the correct application installed, if the file's internal structure is damaged (e.g., due to incomplete download, bad sectors, or software crash), the application cannot parse it and will fail to open. File corruption is the most direct cause of an application being unable to open a specific file when the application itself is functional.

Answer

The hard drive is full.

Answer

The operating system is outdated.

Answer

The network is down.