web analytics

Daily Archives: Monday, March 26, 2018

  • [March 2018] Lead2pass Free Cisco 200-105 Braindumps VCE Updated 497q

    Lead2pass Latest 200-105 Free Dumps Guarantee 200-105 Certification Exam 100% Success:


    Refer to the exhibit. While troubleshooting a switch, you executed the show interface port-channel 1 etherchannel command and it returned this output.
    Which information is provided by the Load value?


  • [March 2018] Free Sharing Of Cisco 100-105 Brain Dumps From Lead2pass 553q

    Free Sharing Of Updated 100-105 VCE And PDF Dumps From Lead2pass:


    Which three statements are true about the operation of a full-duplex Ethernet network? (Choose three.)

    A.    There are no collisions in full-duplex mode.
    B.    A dedicated switch port is required for each full-duplex node.
    C.    Ethernet hub ports are preconfigured for full-duplex mode.
    D.    In a full-duplex environment, the host network card must check for the availability of the network
    media before transmitting.
    E.    The host network card and the switch port must be capable of operating in full-duplex mode.

    Answer: ABE
    Half-duplex Ethernet is defined in the original 802.3 Ethernet and Cisco says you only use one wire pair with a digital signal running in both directions on the wire. It also uses the CSMA/CD protocol to help prevent collisions and to permit retransmitting if a collision does occur. If a hub is attached to a switch, it must operate in half-duplex mode because the end stations must be able to detect collisions. Half-duplex Ethernet–typically 10BaseT–is only about 30 to 40 percent efficient as Cisco sees it, because a large 10BaseT network will usually only give you 3- to 4Mbps–at most. Full-duplex Ethernet uses two pairs of wires, instead of one wire pair like half duplex. Also, full duplex uses a point-to-point connection between the transmitter of the transmitting device and the receiver of the receiving device, which means that with full-duplex data transfer, you get a faster data transfer compared to half duplex. And because the transmitted data is sent on a different set of wires than the received data, no collisions occur. The reason you don’t need to worry about collisions is because now Full-duplex Ethernet is like a freeway with multiple lanes instead of the single-lane road provided by half duplex. Full-duplex Ethernet is supposed to offer 100 percent efficiency in both directions; this means you can get 20Mbps with a 10Mbps Ethernet running full duplex, or 200Mbps for FastEthernet.

    Which router command can be used to determine the status of Serial 0/0?

    A.    show ip route
    B.    show interfaces
    C.    show s0/0 status
    D.    debug s0/0
    E.    show run
    F.    show version

    Answer: B

    What is the subnet address of


    Answer: C
    Converting to binary format it comes to
    11111111.11111111.11111100.00000000 or
    Starting with and having increment of 4 we get.

    An administrator is working with the network, which has been subnetted with a /26 mask. Which two addresses can be assigned to hosts within the same subnet? (Choose two.)


    Answer: CD
    Only the values of host with 67 and 125 fall within the range of /26 CIDR subnet mask, all others lie beyond it.

    Refer to the exhibit. The internetwork is using subnets of the address with a subnet mask of The routing protocol in use is RIP version 1.
    Which address could be assigned to the FastEthernet interface on RouterA?



    Answer: D

    What is the network address for the host with IP address


    Answer: C
    convert bit-length prefix to quad-dotted decimal representation, then from it find the number of bits used for subnetting you can find previously calculated number of subnets by separating subnets each having value of last bit used for subnet masking Find that your IP address is in which subnet, that subnet’s first address is network address and last address is broadcast address. Based on above steps the answer is option C.

    What is the best practice when assigning IP addresses in a small office of six hosts?

    A.    Use a DHCP server that is located at the headquarters.
    B.    Use a DHCP server that is located at the branch office.
    C.    Assign the addresses by using the local CDP protocol.
    D.    Assign the addresses statically on each node.

    Answer: D
    Its best to use static addressing scheme where the number of systems is manageable rather than use dynamic protocol as it is easy to operate and manage.

    Refer to the exhibit. The enterprise has decided to use the network address The network administrator needs to design a classful addressing scheme to accommodate the three subnets, with 30, 40, and 50 hosts, as shown.
    What subnet mask would accommodate this network?



    Answer: A

    Which two statements describe the IP address (Choose two.)

    A.    The subnet address is
    B.    The lowest host address in the subnet is
    C.    The last valid host address in the subnet is
    D.    The broadcast address of the subnet is
    E.    The network is not subnetted.

    Answer: BD
    The mask (/23) used with a Class A address means that there are 15 subnet bits and 9 host bits. The block size in the third octet is 2 (256 – 254). So this makes the subnets in 0, 2, 4, 6, etc., all the way to 254. The host is in the 2.0 subnet. The next subnet is 4.0, so the broadcast address for the 2.0 subnet is 3.255. The valid host addresses are 2.1 through 3.254

    Given a Class C IP address subnetted with a /30 subnet mask, how many valid host IP addresses are available on each of the subnets?

    A.    1
    B.    2
    C.    4
    D.    8
    E.    252
    F.    254

    Answer: B
    /30 CIDR corresponds to mask whose binary is 11111100 which means 6 subnet bits and 2 host bits which means 62 subnets and 2 hosts per subnet.

    100-105 dumps full version (PDF&VCE): https://www.lead2pass.com/100-105.html

    Large amount of free 100-105 exam questions on Google Drive: https://drive.google.com/open?id=0B3Syig5i8gpDdDNkZEswTDRMaVE

    You may also need:

    200-105 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDX09LZEFNYnpfM2c

    200-125 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDM0s1aXlFTXBWdGM

  • [March 2018] Easily Pass 70-765 Exam By Training Lead2pass Latest VCE Dumps 155q

    Easily Pass 70-765 Exam By Training Lead2pass New Microsoft VCE Dumps:


    You have a server named Serverl that is hosted in an Azure virtual machine.
    Server1 contains the following:

    – One instance of SQL Server 2016 Enterprise
    – 10 databases
    – 500 stored procedures

    You have a database named Databasel that is hosted on Server1.
    Database1 contains 100 queries that are executed dynamically from web applications.
    You plan to remove data from the procedure cache on Database1.
    You have the following requirements:

    – Changes to Database1 must not affect other databases that are hosted on Server1
    – Changes to Database1 must not affect the performance of queries that are stored in other databases.
    – The solution must minimize administrative effort.

    You need to remove the data from the procedure cache as quickly as possible.
    What should you do?

    D.     Write a script that iterates through each stored procedure definition and add WITH RECOMPILE to the definition.

    Answer: B
    You should run ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE CACHE in the context of Database! This statement lets you change the settings of a database without affecting other databases that are installed on the instance of SQL Server 2016.
    You should not run DBCC FREEPROCCACHE. DBCC FREEPROCCACHE would clean the entire plan cache and would affect all databases. It is possible to remove a single plan from the cache by using the plan_handle argument to DBCC FREEPROCCACHE, but you would have to identify all plans that are related to Databasel, which requires a lot more administrative effort.
    You should not run DBCC DROPCLEANBUFFERS. DBCC DROPCLEANBUFFERS will remove the clean pages from the buffer cache. Columnstore pages are removed from the columnstore cache.
    You should not write a script that will iterate through each stored procedure definition and add WITH RECOMPILE to the definition. Each time the procedure is called, it will be recompiled, and this might degrade the server’s performance. This approach would require additional administrative effort to produce the script. In addition, some calls are made from the web application and the script would not have any control over these calls. In earlier versions of SQL Server, prior to the availability of the ALTER DATABASE statement, this option would have been the way to avoid affecting other databases.

    You are designing a Windows Azure SQL Database for an order fulfillment system.
    You create a table named Sales.Orders with the following script.


    Each order is tracked by using one of the following statuses:

    – Fulfilled
    – Shipped
    – Ordered
    – Received

    You need to design the database to ensure that that you can retrieve the following information:

    – The current status of an order
    – The previous status of an order.
    – The date when the status changed.
    – The solution must minimize storage.

    More than one answer choice may achieve the goal. Select the BEST answer.

    A.    To the Sales.Orders table, add three columns named Status, PreviousStatus and ChangeDate.
    Update rows as the order status changes.
    B.    Create a new table named Sales.OrderStatus that contains three columns named OrderID,
    StatusDate, and Status. Insert new rows into the table as the order status changes.
    C.    Implement change data capture on the Sales.Orders table.
    D.    To the Sales.Orders table, add three columns named FulfilledDate, ShippedDate, and ReceivedDate.
    Update the value of each column from null to the appropriate date as the order status changes.

    Answer: B

    You are using dynamic management views to monitor an SQL Server server named SQL1.
    A database administrator named Dba1 must monitor the health of SQL1.
    You need to ensure that Dba1 can access dynamic management views for SQL1.
    The solution must use the principle of least privilege.
    Which permissions should you assign to Dba1?


    Answer: B
    To query a dynamic management view or function requires SELECT permission on object and VIEW SERVER STATE or VIEW DATABASE STATE permission.

    You are the administrator for a SQL Server 2016 instance that stores the data for an online transaction processing sales system.
    The company takes full backups every week; differential backups on the days with no full backups; and hourly transaction backups.
    These backups are stored on a backup server in the company’s data center.
    Every week, the company places the full backup on a tape and sends it to a third-party backup storage system.
    The company is worried that a disaster might occur that could destroy their computer center and cause them to lose orders.
    You need to determine the best method for providing the smallest amount of data loss and downtime without leasing or purchasing additional physical locations.
    What should you do? More than one answer choice may achieve the goal. Select the BEST answer.

    A.    Set up SQL Server Always On with a SQL Azure database as a replica.
    B.    Set up SQL Server Always On by using a SQL Server on a Windows Azure Virtual Machine.
    C.    Put the differential backup on tape and send it to the third-party backup storage system.
    D.    Use the Microsoft SQL Server Backup to Microsoft Windows Azure Tool to direct all backups
    to a different geographical location.

    Answer: D

    You have a SQL Server 2016 database named DB1.
    You plan to import a large number of records from a SQL Azure database to DB1.
    You need to recommend a solution to minimize the amount of space used in the transaction log during the import operation.
    What should you include in the recommendation?

    A.    The bulk-logged recovery model
    B.    The full recovery model
    C.    A new partitioned table
    D.    A new log file
    E.    A new file group

    Answer: A
    Compared to the full recovery model, which fully logs all transactions, the bulk-logged recovery model minimally logs bulk operations, although fully logging other transactions.
    The bulk-logged recovery model protects against media failure and, for bulk operations, provides the best performance and least log space usage.
    The bulk-logged recovery model is a special-purpose recovery model that should be used only intermittently to improve the performance of certain large-scale bulk operations, such as bulk imports of large amounts of data.

    You administer a Microsoft SQL Server 2012 database.
    Users report that an application that accesses the database displays an error, but the error does not provide meaningful information.
    No entries are found in the SQL Server log or Windows event logs related to the error.
    You need to identify the root cause of the issue by retrieving the error message.
    What should you do?

    A.    Create an Extended Events session by using the sqlserver.error_reported event.
    B.    Create a SQL Profiler session to capture all ErrorLog and EventLog events.
    C.    Flag all stored procedures for recompilation by using sp_recompile.
    D.    Execute sp_who.

    Answer: A
    Event sqlserver.error_reported: This event gets fired every time that an error happens in the server.

    You administer a Microsoft SQL Server 2012 server.
    One of the databases on the server supports a highly active OLTP application.
    Users report abnormally long wait times when they submit data into the application.
    You need to identify which queries are taking longer than 1 second to run over an extended period of time.
    What should you do?

    A.    use SQL Profiler to trace all queries that are processing on the server.
    Filter queries that have a Duration value of more than 1,000.
    B.    Use sp_configure to set a value for blocked process threshold.
    Create an extended event session.
    C.    Use the Job Activity monitor to review all processes that are actively running.
    Review the Job History to find out the duration of each step.
    D.    Run the sp_who command from a query window.
    E.    Run the DBCC TRACEON 1222 command from a query window and review the SQL Server event log.

    Answer: A
    Incorrect Answers:
    E: DBCC TRACEON 1222 is used to detect deadlocks, not to detect long running queries.

    You administer a Microsoft SQL Server 2012 database.
    You need to ensure that the size of the transaction log file does not exceed 2 GB.
    What should you do?

    A.    Execute sp_configure ‘max log size’, 2G.
    B.    use the ALTER DATABASE…SET LOGFILE command along with the maxsize parameter.
    C.    In SQL Server Management Studio, right-click the instance and select Database Settings. Set the maximum size of the file for the transaction log.
    D.    In SQL Server Management Studio, right-click the database, select Properties, and then click Files.
    Open the Transaction log Autogrowth window and set the maximum size of the file.

    Answer: B
    You can use the ALTER DATABASE (Transact-SQL) statement to manage the growth of a transaction log file
    To control the maximum the size of a log file in KB, MB, GB, and TB units or to set growth to UNLIMITED, use the MAXSIZE option.
    However, there is no SET LOGFILE subcommand.

    You administer a Microsoft SQL Server 2012 server.
    The MSSQLSERVER service uses a domain account named CONTOSO\SQLService.
    You plan to configure Instant File Initialization.
    You need to ensure that Data File Autogrow operations use Instant File Initialization.
    What should you do? Choose all that apply.

    A.    Restart the SQL Server Agent Service.
    B.    Disable snapshot isolation.
    C.    Restart the SQL Server Service.
    D.    Add the CONTOSO\SQLService account to the Perform Volume Maintenance Tasks local security policy.
    E.    Add the CONTOSO\SQLService account to the Server Operators fixed server role.
    F.    Enable snapshot isolation.

    Answer: CD
    How To Enable Instant File Initialization
    1. Open Local Security Policy and go to Local Policies –> User Rights Assignment.
    2. Double click Perform Volume Maintenance Tasks and add your SQL Server database engine service account.
    3. Restart the SQL Server service using SQL Server Configuration Manager and this setting should now be enabled.

    You administer a Microsoft SQL Server 2012 failover cluster that contains two nodes named Node A and Node B.
    A single instance of SQL Server is installed on the cluster.
    An additional node named Node C has been added to the existing cluster.
    You need to ensure that the SQL Server instance can use all nodes of the cluster.
    What should you do?

    A.    Run the New SQL Server stand-alone installation Wizard on Node C.
    B.    Run the Add Node to SQL Server Failover Cluster Wizard on Node C.
    C.    Use Node B to install SQL Server on Node C.
    D.    Use Node A to install SQL Server on Node C.

    Answer: B
    To add a node to an existing SQL Server failover cluster, you must run SQL Server Setup on the node that is to be added to the SQL Server failover cluster instance.
    Do not run Setup on the active node.
    The Installation Wizard will launch the SQL Server Installation Center. To add a node to an existing failover cluster instance, click Installation in the left-hand pane.
    Then, select Add node to a SQL Server failover cluster.

    70-765 dumps full version (PDF&VCE): https://www.lead2pass.com/70-765.html

    Large amount of free 70-765 exam questions on Google Drive: https://drive.google.com/open?id=0B3Syig5i8gpDejczeWp0aURaSnM

    You may also need:

    70-761 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDU2RSQnhzX2pIZVE

    70-762 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDMW9NcjJrQXlsMGs

    70-764 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDUjBoM0pVQnlUTlU

    70-767 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDdTF0R0taLWgxSmc

    70-768 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDZ2pRQkV6Vnc4dHc

  • [March 2018] Lead2pass 2018 New 70-761 Exam PDF Ensure 70-761 Certification Exam Pass 100% 135q

    Lead2pass 2018 New 70-761 Exam PDF Ensure 70-761 Certification Exam Pass Successfully:


    You are developing a Microsoft SQL Server database.
    You create a view that performs the following tasks:
    Joins 10 tables that contain up to 400,000 records each.
    Performs aggregations on 4 fields.
    The view is frequently used in several detailed reports.
    You need to improve the performance of the reports. What should you do?

    A.    Convert the view into a table-valued function
    B.    Convert the view into an indexed view
    C.    Convert the view into a stored procedure and retrieve the result from the stored procedure into a temporary table
    D.    Convert the view into a Common Table Expression (CTE)

    Answer: B
    The first index created on a view must be a unique clustered index. After the unique clustered index has been created, you can create more nonclustered indexes. Creating a unique clustered index on a view improves query performance because the view is stored in the database in the same way a table with a clustered index is stored. The query optimizer may use indexed views to speed up the query execution. The view does not have to be referenced in the query for the optimizer to consider that view for a substitution.

    Is the following statement TRUE or FALSE?
    JSON is not a built-in data type in SQL Server 2016, and SQL Server 2016 does not have custom JSON indexes?

    A.    TRUE
    B.    FALSE

    Answer: A

    The !> operator is a comparison operator that compares two expressions.
    However, if ANSI_NULLS is set to ON and one of the operands is NULL, what will the result be?

    expression !> expression (NULL)

    A.    FALSE
    B.    0
    C.    TRUE
    D.    NULL

    Answer: D
    If either or both operands are NULL and SET ANSI_NULLS is set to ON, the result is NULL. If SET ANSI_NULLS is set to OFF, the result is FALSE if one of the operands is NULL, and TRUE if both operands are NULL.

    You are developing a SQL Server database that contains a heap named OrdersArchive.
    You write the following Transact-SQL query:

    INSERT INTO OrdersArchive
    SELECT * FROM CompletedOrders

    You need to optimize transaction logging and locking for the statement.
    Which table hint should you use?

    A.    HOLDLOCK
    B.    TABLOCK
    C.    XLOCK
    D.    ROWLOCK

    Answer: B
    Table hints override the default behavior of the query optimizer for the duration of the data manipulation language (DML) statement by specifying a locking method, one or more indexes, a query-processing operation such as a table scan or index seek, or other options. Table hints are specified in the FROM clause of the DML statement and affect only the table or view referenced in that clause.
    When importing data into a heap by using the INSERT INTO SELECT FROM statement, you can enable optimized logging and locking for the statement by specifying the TABLOCK hint for the target table. In addition, the recovery model of the database must be set to simple or bulk- logged.

    Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

    After you answer a question in this section. You will NOT be able to return to it. As a result, these questions will not appear in the review screen.

    A database has two tables as shown in the following database diagram:


    You need to list all provinces that have at least two large cities.
    A large city is defined as having a population of at least one million residents.
    The query must return the following columns:


    Solution: You run the following Transact-SQL statement:


    Does the solution meet the goal?

    A.    Yes
    B.    No

    Answer: A
    The requirement to list all provinces that have at least two large cities is meet by the WHERE CitySummary.LargeCityCount >=2 clause.
    CROSS APPLY will work fine here.
    The APPLY operator allows you to invoke a table-valued function for each row returned by an outer table expression of a query. The table-valued function acts as the right input and the outer table expression acts as the left input. The right input is evaluated for each row from the left input and the rows produced are combined for the final output. The list of columns produced by the APPLY operator is the set of columns in the left input followed by the list of columns returned by the right input.
    There are two forms of APPLY: CROSS APPLY and OUTER APPLY. CROSS APPLY returns only rows from the outer table that produce a result set from the table-valued function. OUTER APPLY returns both rows that produce a result set, and rows that do not, with NULL values in the columns produced by the table-valued function.
    References: https://technet.microsoft.com/en-us/library/ms175156(v=sql.105).aspx

    You create a table named Products.Sales by running the following Transact-SQL statement:

    CREATE TABLE Products.Sales (
    SalesId int IDENTIFY(1,1) PRIMARY KEY,
    SalesDate DateTime NOT NULL,
    SalesAmount decimal(18,2) NULL

    You add the following data to the table.


    You are developing a report to display monthly sales data.
    You need to create a Transact-SQL query to meet the following requirements:

    – Retrieve a column for the year followed by a column for each month from January through December.
    – Include the total sales amount for each month.
    – Aggregate columns by year, month, and then amount.

    Construct the query using the following guidelines:

    – Use the MONTH keyword as the interval when using the DATANAME function.
    – Do not modify the provided IN clause.
    – Do not surround object names with square brackets.
    – Do not use implicit joins.
    – Do not use the DATEPART function.

    Part of the correct Transact-SQL has been provided in the answer area below. Enter the code in the answer area that resolves the problem and meets the stated goals or requirements. You can add code within the code that has been provided as well as below it.

    1. SELECT * FROM
    2. (SELECT YEAR(SalesData)) AS Year, DATENAME (MONTH, SalesDate) AS Month,
    SalesAmount AS Amount
    4. ) AS MonthlySalesData
    6. FOR Month IN (January, February, March, April, May, June, July, August, September,
    October, November, December))
    AS MonthNamePivot


    A.    Pending

    Answer: A

    70-761 dumps full version (PDF&VCE): https://www.lead2pass.com/70-761.html

    Large amount of free 70-761 exam questions on Google Drive: https://drive.google.com/open?id=0B3Syig5i8gpDU2RSQnhzX2pIZVE

    You may also need:

    70-762 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDMW9NcjJrQXlsMGs

    70-764 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDUjBoM0pVQnlUTlU

    70-765 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDejczeWp0aURaSnM

    70-767 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDdTF0R0taLWgxSmc

    70-768 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDZ2pRQkV6Vnc4dHc