http://https://www.lead1pass.com/Microsoft/70-461-practice-exam-dumps.html (204 Q&As Dumps, 30%OFF Special Discount: 30free )

NEW QUESTION NO: 15
You administer a Microsoft SQL Server database that supports a shopping application.
You need to retrieve a list of customers who live in territories that do not have a sales person.
Which Transact- SQL query or queries should you use? (Each correct answer presents a complete solution. Choose all that apply.)
A. SELECT CustomerID FROM Customer
WHERE TerritoryID <> SOME(SELECT TerritoryID FROM Salesperson)
B. SELECT CustomerID FROM Customer
WHERE TerritoryID <> ALL(SELECT TerritoryID FROM Salesperson)
C. SELECT CustomerID FROM Customer
WHERE TerritoryID <> ANY(SELECT TerritoryID FROM Salesperson)
D. SELECT CustomerID FROMCustomer
WHERE TerritoryID NOT IN(SELECT TerritoryID FROM Salesperson)
Answer: B,D
Explanation/Reference:
Explanation:

NEW QUESTION NO: 16
You create a stored procedure that will update multiple tables within a transaction.
You need to ensure that if the stored procedure raises a run-time error, the entire transaction is terminated and rolled back.
Which Transact-SQL statement should you include at the beginning of the stored procedure?
A. SET XACT_ABORT ON
B. SET ARITHABORT ON
C. TRY
D. BEGIN
E. SET ARITHABORT OFF
F. SET XACT_ABORT OFF
Answer: A
Explanation/Reference:
Explanation:
Reference: http://msdn.microsoft.com/en-us/library/ms190306.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms188792.aspx

NEW QUESTION NO: 17
You use Microsoft SQL Server 2012 to develop a database application.
You need to create an object that meets the following requirements:
Takes an input variable

Returns a table of values

Cannot be referenced within a view

Which object should you use?
A. Scalar-valued function
B. Inline function
C. User-defined data type
D. Stored procedure
Answer: D
Explanation/Reference:
Explanation:

NEW QUESTION NO: 18
DRAG DROP
You create the following stored procedure. (Line numbers are included for reference only.)

You need to ensure that the stored procedure performs the following tasks:
If a record exists, update the record.

If no record exists, insert a new record.

Which four Transact-SQL statements should you insert at line 07? (To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.) Select and Place:

Answer: 

Explanation/Reference:
Reference: http://technet.microsoft.com/en-us/library/bb510625.aspx

NEW QUESTION NO: 19
You use Microsoft SQL Server 2012 to develop a database application.
You create a stored procedure named dbo.ModifyData that can modify rows.
You need to ensure that when the transaction fails, dbo.ModifyData meets the following requirements:
Does not return an error

Closes all opened transactions

Which Transact-SQL statement should you use?
A. BEGIN TRANSACTION
BEGIN TRY
EXEC dbo.ModifyData
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@ TRANCOUNT = 0
ROLLBACK TRANSACTION;
END CATCH
B. BEGIN TRANSACTION
BEGIN TRY
EXEC dbo.ModifyData
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@ERROR != 0
ROLLBACK TRANSACTION;
THROW;
END CATCH
C. BEGIN TRANSACTION
BEGIN TRY
EXEC dbo.ModifyData
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@TRANCOUNT = 0
ROLLBACK TRANSACTION;
THROW;
END CATCH
D. BEGIN TRANSACTION
BEGIN TRY
EXEC dbo.ModifyData
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@ERROR != 0
ROLLBACK TRANSACTION;
END CATCH
Answer: D
Explanation/Reference:
Explanation:

NEW QUESTION NO: 20
You administer several Microsoft SQL Server 2012 database servers. Merge replication has been configured for an application that is distributed across offices throughout a wide area network (WAN).
Many of the tables involved in replication use the XML and varchar (max) data types. Occasionally, merge replication fails due to timeout errors. You need to reduce the occurrence of these timeout errors. What should you do?
A. Set the Merge agent on the problem subscribers to use the slow link agent profile.
B. Create a snapshot publication, and reconfigure the problem subscribers to use the snapshot publication.
C. Change the Merge agent on the problem subscribers to run continuously.
D. Set the Remote Connection Timeout on the Publisher to 0.
Answer: A
Explanation/Reference:
Explanation:

NEW QUESTION NO: 21
You are a database developer of a Microsoft SQL Server 2012 database.
The database contains a table named Customers that has the following definition:

You need to ensure that the CustomerId column in the Orders table contains only values that exist in the CustomerId column of the Customer table.
Which Transact-SQL statement should you use?
A. ALTER TABLE Orders
ADD CONSTRAINTFX_Orders_CustomerID FOREIGN KEY (CustomerId) REFERENCES
Customer (CustomerId)
B. ALTER TABLE Customer
ADD CONSTRAINT FK_Customer_CustomerID FOREIGN KEY {CustomerID) REFERENCES Orders (CustomerId)
C. ALTER TABLE Orders
ADD CONSTRAINT CK_Orders_CustomerID
CHECK (CustomerId IN (SELECT CustomerId FROM Customer))
D. ALTER TABLE Customer
ADD OrderId INT NOT NULL;
ALTER TABLE Customer
ADD CONSTRAINT FK_Customer_OrderID FOREIGN KEY (OrderID) REFERENCES Orders (OrderID);
E. ALTER TABLE Orders
ADD CONSTRAINT PKOrders CustomerId PRIMARY KEY (CustomerID)
Answer: A
Explanation/Reference:
Reference: http://msdn.microsoft.com/en-us/library/ms189049.aspx

NEW QUESTION NO: 22
You administer a Microsoft SQL Server 2012 database named ContosoDb. The database contains a table named Suppliers and a column named IsActive in the Purchases schema. You create a new user named ContosoUser in ContosoDb. ContosoUser has no permissions to the Suppliers table. You need to ensure that ContosoUser can delete rows that are not active from Suppliers. You also need to grant ContosoUser only the minimum required permissions. Which Transact-SQL statement should you use?
A. GRANT DELETE ON Purchases.Suppliers TO ContosoUser
B. CREATE PROCEDURE Purchases.PurgeInactiveSuppliers
WITH EXECUTE AS USER = 'dbo'
AS
DELETE FROM Purchases.Suppliers WHERE IsActive = 0
GO
GRANT EXECUTE ON Purchases.PurgelnactiveSuppliers TO ContosoUser
C. GRANT SELECT ON Purchases.Suppliers TO ContosoUser
D. CREATE PROCEDURE Purchases.PurgeInactiveSuppliers
AS
DELETE FROM Purchases.Suppliers WHERE IsActive = 0
GO
GRANT EXECUTE ON Purchases.PurgeInactiveSuppliers TO ContosoUser
Answer: D
Explanation/Reference:
Reference: http://msdn.microsoft.com/en-us/library/ms188354.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms187926.aspx

NEW QUESTION NO: 23
DRAG DROP
You use Microsoft SQL Server to develop a database application.
You create two tables by using the following table definitions.

Which five Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.) Select and Place:

Answer: 


NEW QUESTION NO: 24
You administer a Microsoft SQL Server 2012 database named ContosoDb. Tables are defined as shown in the exhibit. (Click the Exhibit button.)

You need to display rows from the Orders table for the Customers row having the CustomerId value set to
1 in the following XML format:
<row OrderId="1" OrderDate="2000-01-01T00:00:00" Amount="3400.00" Name="Customer A" Country="Australia" />
<row OrderId="2" OrderDate="2001-01-01T00:00:00" Amount="4300.00" Name="Customer A" Country="Australia" /> Which Transact-SQL query should you use?
A. SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders
INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML RAW
B. SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders
INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML RAW, ELEMENTS
C. SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders
INNER JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML AUTO
D. SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders
INNER JOIN Customers ON Orders.CustomerId - Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML AUTO, ELEMENTS
E. SELECT Name, Country, OrderId, OrderDate, Amount
FROM Orders
INNER JOIN Customers ON Orders.CustomerId= Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML AUTO
F. SELECT Name, Country, OrderId, OrderDate, Amount
FROM Orders
INNER JOIN Customers ON Orders.CustomerId= Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML AUTO, ELEMENTS
G. SELECT Name AS '@Name', Country AS '@Country', OrderId, OrderDate,
Amount
FROM Orders
INNER JOIN Customers ON Orders.CustomerId= Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML PATH ('Customers')
H. SELECT Name AS 'Customers/Name', Country AS 'Customers/Country',
OrderId, OrderDate, Amount
FROM Orders
INNER JOIN Customers ON Orders.CustomerId= Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML PATH ('Customers')
Answer: A
Explanation/Reference:
Reference:http://msdn.microsoft.com/en-us/library/bb510464.aspx

NEW QUESTION NO: 25
You develop a Microsoft SQL Server 2012 database.
You need to create a batch process that meets the following requirements:
Returns a result set based on supplied parameters.

Enables the returned result set to perform a join with a table.

Which object should you use?
A. Inline user-defined function
B. Stored procedure
C. Table-valued user-defined function
D. Scalar user-defined function
Answer: C
Explanation/Reference:
Explanation:

NEW QUESTION NO: 26
You have an existing SharePoint 2016 on-premises environment. You use document libraries as file archives.
Users report that they cannot upload documents larger than 3 gigabytes (GB).
You need to ensure that users can upload any type of file up to 4 GB in size.
What should you do?
A. On each front-end server in the farm, locate the following registry key:HKEY_LOCAL_MACHINE
\SYSTEM\\CurrentControlSet\Services\WebClientParametersSet the value of the FileSizeLimitInBytes key to 4294967295. Then, restart the Web Client service.
B. In SharePoint Central Administration, change the value of the Maximum Upload Size property for the web application.
C. Run the following Windows PowerShell command:$WebApp.MaximumFileSizePerExtension.Add ("MaxFileSize", 4096000)
D. Add the following markup to the web.config file for the web application:<httpRuntime executionTimeout
="999999"maxRequestLength= "4096000" requestValidationMode ="2.0" />
Answer: B
Explanation/Reference:
Explanation:

NEW QUESTION NO: 27
DRAG DROP
You have a SharePoint Online environment. You enable the Delve feature.
The human resources (HR) team is concerned that private, sensitive documents from the HR team site are appearing in Delve. You have created a HideFromDelve column in the library and the documents continue to appear in Delve. The column is a Yes/No type and every item in the library must have a value.
You need to perform steps to configure Delve to show only specific documents and update existing items in the library with minimum effort.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Answer: 

Explanation/Reference:
References:
http://www.learningsharepoint.com/2016/06/23/how-to-hide-documents-from-delve-office-365/

NEW QUESTION NO: 28
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 sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You manage an on-premises SharePoint Server 2016 farm and SharePoint Online.
You plan to deploy a SharePoint Search solution. The solution must meet the following requirements:
Present a unified set of search results to users.

Reduce the number of Search Servers in the farm.

Customize the search schema for content that is stored on-premises.

You implement cloud hybrid search for SharePoint.
Does the solution meet the goal?
A. Yes
B. No
Answer: A
Explanation/Reference:
Explanation:

NEW QUESTION NO: 29
DRAG DROP
Case Study
This is a case study. Case studies are not limited separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other question on this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next sections of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question on this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
General
Blue Yonder Airlines manufactures, sells, and services small commercial jet aircraft. The company has offices worldwide. Blue Yonder currently uses both SharePoint 2013 and SharePoint 2016. The company has a public website that is based on an ASP.NET web application.
SharePoint 2013
Service environment (SharePoint 2013)
The legacy SharePoint farm runs SharePoint Server 2013.

This farm has over200 site collections that are hosted on 20 content databases. There is no clear

documentation that details which site collections are located in which content databases.
The SQL Server for the SharePoint 2013 farm is ServerRole2013.

Requirements
General
Every file stored within the system must contain the following common document properties:
Document Status

Department

Author

Enterprise Keywords

Values for the Document Status property must be displayed in English, Spanish, or French. The display language must be based on a user's language preferences.
Additional fields or settings may be added in the future.
You must be able to manage file metadata settings from a single location. When you make changes to settings, the changes must be applied to site collections and existing documents. This location must not be a part of the existing marketing, HR, or procurement team sites.
Site collections
Each departmental site must have a separate site collection. All departmental sites must be hosted in a single web application which is located at http://sp.blueyonder.com.
Locations for the storage of personal documents for each employee should be created in a dedicated web application.
Governance
No custom development is permitted. Custom solutions must not be installed on the farm. Only configurations based on standard functionality acceptable.
Employees in the marketing, HR, and procurement departments are only permitted to have Read, Contribute, or Edit permissions to their sites.
Human Resources
The human resources (HR) department is responsible for sharing information with all employees related to four themes: my work, my pay, my benefits, and my career. The naming of these themes may change over time, and additional themes may be added. It must be possible for someone from the HR team to edit the themes.
The HR site in the intranet is divided into a top level site with three subsites. Each subsite represents a unique team.
The global navigation of the HR site must feature a listing of the relevant themes and link to custom pages that list content for each theme. The site must not display links to subsites or other pages on the HR site.
Team site URL
The HR site must use the URL http://hr.blueyonder.com.
Marketing
The marketing department will use SharePoint to publish brochures, marketing materials, and announcements. Only final versions of these documents may be added to the marketing team site for sharing with other Blue Yonder employees. Once a file is published, employees must be able to access the file by using a consistent link even if the file is renamed or moved within the site.
User file storage
Files that are in draft mode must not be accessible to any user except the author until the file is ready for review. Each marketing employee must have a single location for storing draft work, work in progress materials, and other personal files. Files stored in this location must only be accessible to the employee that owns the area unless the employee chooses to share a file with other users.
The storage location must be created automatically for an employee and must not require assistance from IT for configuration.
The URL for each employees' site must be http://employees.blueyonder.com/my/personal/username, where username represents the login of the employee.
Public website
The public website is not part of the SharePoint environment. It is a standalone ASP.NET website. Content on the public website, including news and job postings, is updated once a month. Information posted to the public website must be accessible by using search. Information stored in the Downloads section of the website must not be crawled due to the large size and the number of files.
Team site URL
The team site for the department must use the URL http://marketing.blueyonder.com.
Procurement
The procurement department uses SharePoint to store contracts and related documents. You must store these documents in as few document libraries as possible. The documents may contain precedents or terms that are relevant for reuse. The procurement site stored over 20 million documents. The term store for the site contains two million terms.
File storage
Currently, the site consumes approximately 100 gigabytes (GB) of storage. This is expected to double within a year. It is expected that search will be a key feature for this group.
Search
When a search is conducted and a user hovers over the search result, the user must be able to easily launch the document, visit the library that it is stored in, or preview the file. The links to the document and the library must appear above the preview of the file.
Team site URL
The site for the department must use the URL http://procurement.blueyonder.com.
Products
The product team uses the legacy SharePoint 2013 farm. You must upgrade the farm to SharePoint Server
2016 so that the product team can take advantage of all the services that are available to the other departments.
The existing products site is very active. You must ensure that users cannot change the site content during the upgrade process.
SharePoint 2016
Logical architecture
The SharePoint environment has two web applications. One web application is used for Departmental

Collaboration, and the other is used for Central Administration.
Each departmental site should beconfigured as a separate site collection.

All departmental sited should be hosted within the same web application. The web application is

accessible at the URLhttp://sp.bluyonder.com.
Locations for the storage ofpersonal documents for each employee should be created in a dedicated

web application.
Server environment
The server farm is configured with SharePoint Server 2016 and Office Online Server. No additional

add-ons or software packages are installed.
The SQLServer for the SharePoint 2016 farm is ServerRole2016.

The farm should leverage MinRole with a dedicated server for search.

You need to configure SharePoint Server URLs to allow access to the following sites:
HR

Marketing

Procurement

For each site, which feature should you configure? To answer, drag the appropriate feature to the correct site. Each feature may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:

Answer: 


NEW QUESTION NO: 30
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 sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are the SharePoint administrator for a company.
You must provide an on-premises SharePoint solution that helps monitor and analyze your business in order to make informed business decisions that align with the objectives and strategies for the company.
The solution must include the following features:
Dashboards

Scorecards

Key Performance Indicators (KPI)

You install and configure Office Online Server.
Does the solution meet the goal?
A. Yes
B. No
Answer: B
Explanation/Reference:
Explanation:
You need PerformancePoint Services which is a SharePoint BI tool.
References:
https://technet.microsoft.com/en-us/library/ee424392(v=office.16).aspx

NEW QUESTION NO: 31
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 sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are the SharePoint administrator for a company.
The SharePoint environment is causing excessive information to be recorded in the diagnostic logs.
You need to configure the SharePoint farm to only write events to the Windows event log that are equal to or more severe than the Error level.
You run the following Windows PowerShell command:
Set-SPDiagnosticConfig -errorReportingEnable
Does the solution meet the goal?
A. Yes
B. No
Answer: B
Explanation/Reference:
Explanation:

NEW QUESTION NO: 32
Case Study
This is a case study. Case studies are not limited separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other question on this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next sections of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question on this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
General
Blue Yonder Airlines manufactures, sells, and services small commercial jet aircraft. The company has offices worldwide. Blue Yonder currently uses both SharePoint 2013 and SharePoint 2016. The company has a public website that is based on an ASP.NET web application.
SharePoint 2013
Service environment (SharePoint 2013)
The legacySharePoint farm runs SharePoint Server 2013.

This farm has over 200 site collections that are hosted on 20 content databases. There is no clear

documentation that details which site collections are located in which content databases.
The SQL Server for theSharePoint 2013 farm is ServerRole2013.

Requirements
General
Every file stored within the system must contain the following common document properties:
Document Status

Department

Author

Enterprise Keywords

Values for the Document Status property must be displayed in English, Spanish, or French. The display language must be based on a user's language preferences.
Additional fields or settings may be added in the future.
You must be able to manage file metadata settings from a single location. When you make changes to settings, the changes must be applied to site collections and existing documents. This location must not be a part of the existing marketing, HR, or procurement team sites.
Site collections
Each departmental site must have a separate site collection. All departmental sites must be hosted in a single web application which is located at http://sp.blueyonder.com.
Locations for the storage of personal documents for each employee should be created in a dedicated web application.
Governance
No custom development is permitted. Custom solutions must not be installed on the farm. Only configurations based on standard functionality acceptable.
Employees in the marketing, HR, and procurement departments are only permitted to have Read, Contribute, or Edit permissions to their sites.
Human Resources
The human resources (HR) department is responsible for sharing information with all employees related to four themes: my work, my pay, my benefits, and my career. The naming of these themes may change over time, and additional themes may be added. It must be possible for someone from the HR team to edit the themes.
The HR site in the intranet is divided into a top level site with three subsites. Each subsite represents a unique team.
The global navigation of the HR site must feature a listing of the relevant themes and link to custom pages that list content for each theme. The site must not display links to subsites or other pages on the HR site.
Team site URL
The HR site must use the URL http://hr.blueyonder.com.
Marketing
The marketing department will use SharePoint to publish brochures, marketing materials, and announcements. Only final versions of these documents may be added to the marketing team site for sharing with other Blue Yonder employees. Once a file is published, employees must be able to access the file by using a consistent link even if the file is renamed or moved within the site.
User file storage
Files that are in draft mode must not be accessible to any user except the author until the file is ready for review. Each marketing employee must have a single location for storing draft work, work in progress materials, and other personal files. Files stored in this location must only be accessible to the employee that owns the area unless the employee chooses to share a file with other users.
The storage location must be created automatically for an employee and must not require assistance from IT for configuration.
The URL for each employees' site must be http://employees.blueyonder.com/my/personal/username, where username represents the login of the employee.
Public website
The public website is not part of the SharePoint environment. It is a standalone ASP.NET website. Content on the public website, including news and job postings, is updated once a month. Information posted to the public website must be accessible by using search. Information stored in the Downloads section of the website must not be crawled due to the large size and the number of files.
Team site URL
The team site for the department must use the URL http://marketing.blueyonder.com.
Procurement
The procurement department uses SharePoint to store contracts and related documents. You must store these documents in as few document libraries as possible. The documents may contain precedents or terms that are relevant for reuse. The procurement site stored over 20 million documents. The term store for the site contains two million terms.
File storage
Currently, the site consumes approximately 100 gigabytes (GB) of storage. This is expected to double within a year. It is expected that search will be a key feature for this group.
Search
When a search is conducted and a user hovers over the search result, the user must be able to easily launch the document, visit the library that it is stored in, or preview the file. The links to the document and the library must appear above the preview of the file.
Team site URL
The site for the department must use the URL http://procurement.blueyonder.com.
Products
The product team uses the legacy SharePoint 2013 farm. You must upgrade the farm to SharePoint Server
2016 so that the product team can take advantage of all the services that are available to the other departments.
The existing products site is very active. You must ensure that users cannot change the site content during the upgrade process.
SharePoint 2016
Logical architecture
The SharePoint environment has two web applications. One web application is used for Departmental

Collaboration, and theother is used for Central Administration.
Each departmental site should be configured as a separate site collection.

All departmental sited should be hosted within the same web application. The web application is

accessible at the URLhttp://sp.bluyonder.com.
Locations for the storage of personal documents for each employee should be created in a dedicated

web application.
Server environment
The server farm is configured with SharePoint Server 2016 and Office Online Server. No additional

add-ons or software packages are installed.
The SQL Server for the SharePoint 2016 farm is ServerRole2016.

The farm should leverage MinRole with a dedicated server for search.

You need to configure search for the marketing public website.
What should you create?
A. a Query rule
B. a SharePoint Site content source
C. a Basic Search Center
D. a Crawl rule
Answer: B
Explanation/Reference:
Explanation:

NEW QUESTION NO: 33
DRAG DROP
You are assisting Company1 in the development of a website that displays information about their products to customers on the Internet. Company1 web publishers will not have access to publish directly to the Internet site.
You have the following requirements:
Web publishers must be able to update web pages from a SharePoint site collection thatis only

accessible on the Company1 internal network.
Web page updates must be published on an automated basis to a SharePoint site collection that is

accessible from the Internet.
You need to configure the website.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Answer: 


NEW QUESTION NO: 34
HOTSPOT
Case Study
This is a case study. Case studies are not limited separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other question on this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next sections of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question on this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
Tailspin Toys manufactures and sells toys and games. The company also resells board games. The new chief executive officer (CEO) recently launched an effort to update the company's information technology (IT) infrastructure. The CEO wants a blog site to provide updates in plain text about the progress of company projects and the overall health of the company to employees. Content from this site will be used to populate some content on the internet-facing site.
You hire a consultant to design and deploy a SharePoint farm. The company plans to use the farm to create internal collaboration sites, an e-commerce site, and a place to display public announcements.
The following diagram shows the topology of the SharePoint farm:

Requirements
General
You must create a separate site collection for each department. You must base each site collection on the Team site template. The direct URL for each site collection must use the following format: http:// department.tailspin.com.
You must place the site collections for all departments in the same web application, if possible. You must place the site collections for departments that have unique requirements in separate web applications.
Business continuity
You identify the following requirements related to continuity of the business:
All SharePoint services must be highly available.

The SharePoint environment must be able to withstand the failure of a single system without affecting

accessibility.
You must monitor the SharePoint environment to ensure that systems are available and that response times meet service level agreements (SLAs). In the event the times are not within the required thresholds, the system must alert SharePoint administrators. You must create a site that allows department managers to view the performance data that has been collected. The use of additional monitoring software will be permitted where it can be justified.
Governance and security
Governance requirements
Marketing department employees may create team sites. All other sites must be created by members of

the informationtechnology (IT) administration staff.
You must handle requests for new sites by using a Help Desk site on SharePoint.

The corporate taxonomy must be managed by the SharePoint administrative staff. Users must not be

allowed to create their own information architecture. Exceptions to this requirement will be handled on a case by case basis.
All information in SharePoint must be consistently identified and readily accessible by using searches.

Search components must be configured to provide the best search results while minimizing administrative overhead.
Security requirements
Anonymous access is only permitted for Internet-facing sites. Authentication is required for all sites.
Authentication must occur through the Active Directory Domain Services environment. All custom apps must be installed and managed by the SharePoint administrative staff. Any requests for new apps must be submitted through the Help Desk site.
Hardware and storage
Hardware requirements
You must minimize the number of servers and applications whenever possible. You must only deploy additional servers and applications if the requesting department manager provides the appropriate documentation to support the need.
File storage requirements
Content must not be stored in the perimeter network. All access to SharePoint content from the Internet must be handled through servers in the perimeter network. Human resources (HR) data must be kept separate from all other data.
HR department
The HR manager needs a website to implement time management and leave requests. The HR manager has found an app that will provide this functionality on a SharePoint independent software vendor website, and would prefer to use this app as opposed to creating a custom in-house app. This app will only need access to data in the HR site collection.
You must create a site for the HR department that allows new employees to read required documents regarding policies and procedures. The site must also provide all employees access to other HR documentation such as the employee handbook, employee leave procedures, and acceptable use guides.
IT department
You must implement a Help Desk website and associated workflows. To create the site, you must access data from a Microsoft Excel workbook into a SQL Server database by using an SQL Server Integration Services (SSIS) package. You must access data from other data sources.
Employees must be able to fill out a help request on the site and then check the status of the request. IT department staff must be able to respond to the requests, update the status of requests, update the status of requests, and close requests. IT department managers must be able to track the status of the requests, and generate reports on the progress of requests.
Marketing department
Collaboration sites
Marketing department employees must be able to create their own collaboration sites in SharePoint. The collaboration sites will be used for new product release discussions and marketing plans related to those new products. The URL for the collaboration sites must use the format: /products/productname.
Custom terms
The marketing department must be able to use custom terms when identifying marketing strategies. Other departments must not be able to use custom terms. This requirement has been approved by management.
Public-facing sites
You must create a site for the marketing department that provides information to potential customers about the current product line and any products in development. The marketing team must be able to access this site by using their mobile devices.
Sales department
The sales manager needs a site to display sales progress data. The site must include KPIs and metrics that are generated by using information from a database stored on a SQL Server. Sales department employees are often away from the office. They must be able to access SharePoint data from external locations and when they work remotely. Sales department employees need a site that customers can access to purchase products and check on the status of orders.
You need to deploy the HR app.
Which options should you recommend? To answer, select the appropriate setting from each list in the answer area.
Hot Area:

Answer: 

Explanation/Reference:
References:
https://support.office.com/en-gb/article/Add-an-app-to-a-site-ef9c0dbd-7fe1-4715-a1b0-fe3bc81317cb
https://technet.microsoft.com/en-us/library/jj219576.aspx

NEW QUESTION NO: 35
You are the SharePoint administrator for a company. You plan to deploy the SharePoint sites that will be accessible from the company portal. You create the following sites:

A user named User1 will manage the sites. You must prevent all users except for User1 from creating sites and subsites. User1 must be able to delegate management of List permissions to other users. You designate a user in each division as a lead for that division's site.
You need to allow the designated lead in a division to manage their division's site while minimizing administrative effort.
What should you do?
A. For each site, addthe designated divisional user account to the Team owners group for that divisions' site.
B. Add all divisional user accounts to the portal site's Team Owners group.
C. Create a new SharePoint group on the Portal site namedSP Division Managers. Grant theDesign permission to the group and add all designated divisional lead user accounts into the group.
D. Add the designated divisional user account for each divisional site and grant each user the Design permission.
E. Add all the designated divisional useraccount to the portal site and grant each user the Design permission.
Answer: D
Explanation/Reference:
Explanation:

NEW QUESTION NO: 36
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 sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are the SharePoint administrator for a company.
The SharePoint environment is causing excessive information to be recorded in the diagnostic logs.
You need to configure the SharePoint farm to only write events to the Windows event log that are equal to or more severe than the Error level.
You run the following Windows PowerShell command:
Set-SPUsageService -LoggingEnabled $true
Does the solution meet the goal?
A. Yes
B. No
Answer: B
Explanation/Reference:
Explanation:

NEW QUESTION NO: 7
To log in to the cluster with OnCommand System Manager, a cluster administrator account must be authorized for which two application types? (Choose two.)
A. HTTP
B. SSH
C. ONTAPI
D. service processor
Answer: A,C
Explanation/Reference:
You must have a cluster user account configured with the admin role and the http, ontapi, and console application types.
References: https://library.netapp.com/ecmdocs/ECMP1636037/html/GUID-0E8373DA-D297-4FBA-9C4D-
3AD3C169D37F.html

NEW QUESTION NO: 8
You have a FlexVol volume with LUNs and need to set policies to prevent an ENOSPC error on the host.
In this scenario, which two commands will keep the LUN available to the host? (Choose two.)
A. volume autosize
B. snapshot autodelete
C. snapshot delete
D. volume size
Answer: B,C
Explanation/Reference:
ENOSPC is a UNIX operating system error that sometimes returns the message ―Not enough space is available to service your request." The error message occurs because of a shortage of file system space or lack of available media blocks.
You can delete Snapshot copies manually, or automatically by enabling the Snapshot autodelete capability for the volume.
Define and enable a policy for automatically deleting Snapshot copies by using the volume snapshot autodelete modify command.
You can use the snap delete command to delete a Snapshot copy before the preset interval to free disk space or because it is a manual Snapshot copy that is no longer needed but is not going to be automatically deleted.
Note: We get ENOSPC errors because Data ONTAP lets the Snapshot copy grow into the volume space.
Every write in WAFL is a write to a new block. If an old block is part of a Snapshot copy, Data ONTAP needs to preserve the old block and the new changed block. This is not a problem specific to NetApp.
Every storage vendor who supports a snapshot feature has to deal with it. There are two options when there is no space to accommodate the Snapshot copies:
Delete old Snapshot copies as the Snapshot copies grow to reduce delta

Preserve the older Snapshot copies and generate an error on the active file system

References: https://community.netapp.com/fukiw75442/attachments/fukiw75442/backup-and-restore- discussions/5980/1/tr-3633.pdf

NEW QUESTION NO: 9
A customer has a 1,000 GB volume used as a NAS share that has 3x 100 GB files and has no existing Snapshot copies. The customer creates a Snapshot copy of the volume, adds a 500 Gb file to the volume, and then deletes one of the 100 GB files from the volume.
How much free space is in the volume in this scenario?
A. 500 GB
B. 200 GB
C. 300 GB
D. 600 GB
Answer: B
Explanation/Reference:
Snapshot copies minimize disk consumption by preserving individual blocks rather than whole files.
Snapshot copies begin to consume extra space only when files in the active file system are changed or deleted. When this happens, the original file blocks are still preserved as part of one or more Snapshot copies.

References: https://library.netapp.com/ecmdocs/ECMP1368826/html/GUID-CF9E77A6-BDD9-4138-A281- FC0E7BEA4C6D.html

NEW QUESTION NO: 10
What are three causes of a storage failover partial giveback? (Choose three.)
A. iSCSI sessions are active.
B. AutoSupports are being generated.
C. NFSv3 mounts are active.
D. CIFS sessions are active.
E. SnapMirrors are running.
Answer: B,D,E
Explanation/Reference:
When a giveback occurs, the storage will be once again homed to the owning node of the disks.
However, this process can be vetoed in certain conditions, such as:
AutoSupports are being generated

CIFS sessions are active

SnapMirrors are running

Storage issues occur (such as failed disks)

References: https://kb.netapp.com/support/s/article/ka21A0000000daaQAA/what-does-partial-giveback- mean-in-clustered-data-ontap?language=en_US

NEW QUESTION NO: 11
You are configuring an ONTAP solution for FC host connectivity.
In this scenario, how should the cluster be configured? (Choose two.)
A. The SVM must be configured for Ethernet LIFs.
B. FC ports must be configured as initiators.
C. FCP must be licensed on the cluster.
D. FC ports must be configured as targets.
Answer: C,D
Explanation/Reference:
References: https://library.netapp.com/ecmdocs/ECMP1354558/html/GUID-A8D48BB6-ADBF-446D- A0B8-8F3A43D8FCF5.html

NEW QUESTION NO: 12
Click the exhibit button.

You have a 2-node cluster named cl1 that has separate LIFs on each node for both SAN and NAS traffic.
A storage failover takeover process is initiated as shown in the exhibit.
In this scenario, which two statements about the takeover process are true? (Choose two.)
A. The SAN LIFs on cl1-01 go offline.
B. The NAS LIFs on cl1-01 automatically migrate to cl1-02.
C. The NAS LIFs on cl1-01 go offline.
D. The SAN LIFs on cl1-01 automatically migrate to cl1-02.
Answer: B,C
Explanation/Reference:
Storage failover takeover
{ -ofnode {<nodename>|local} - Node to Takeover
This specifies the node that is taken over. It is shut down and its partner takes over its storage.
References: https://library.netapp.com/ecmdocs/ECMP1196817/html/storage/failover/takeover.html

NEW QUESTION NO: 13
You just finished upgrading a cluster to ONTAP 9.1 and would like to enable NetApp Volume Encryption (NVE) on an existing volume. You do not have NetApp Storage Encryption (NSE) drives installed.
Which three steps would you take to accomplish this task? (Choose three.)
A. Replace drives with NSE drives.
B. Modify the volume options with the -encrypt trueparameter.
C. Install the NVE license.
D. Execute the key manager setup wizard.
E. Perform volume move operation using the -encrypt-destination true parameter.
Answer: C,D,E
Explanation/Reference:
You must install the NVE license and enable onboard key management before you can enable volume encryption. You can enable encryption on a new volume or on an existing volume.
You can use the volume move start command to enable encryption on an existing volume. You can use the same aggregate or a different aggregate.
References: http://docs.netapp.com/ontap-9/index.jsp?topic=%2Fcom.netapp.doc.pow-nve%2FGUID- EAD13D8E-0219-45B6-A2C6-B25B76C9CA1A.html

NEW QUESTION NO: 14
Click the Exhibit button.

An administrator installed UTA2 PCIe cards into an existing FAS8200 HA pair. The new cards will be used for native FC traffic. The administrator wants to configure the UTA2 ports for FC client access.
Referring to the exhibit, which two actions address the requirement? (Choose two.)
A. Use the network fcp adapter modifycommand to bring the adapter online.
B. Reboot the node to bring the adapter online after final configuration.
C. Use the system hardware unified-connectcommand to verify that the port mode is set to initiator.
D. Use the ucadmin modifycommand to set the adapter mode to FC.
Answer: B,D
Explanation/Reference:
B: Ports must be converted in pairs, for example, 0c and 0d, after which, a reboot is required, and the ports must be brought back to the up state.
D: CNA ports can be configured into native Fibre Channel (FC) mode or CNA mode.
If the current configuration does not match the desired use (here we want to change from CNA mode to FC mode), enter the following commands to change the configuration as needed:
system node hardware unified-connect modify -node node_name -adapter adapter_name -mode fc|cna - type target|initiator
-mode is the personality type, fc or 10GbE cna.
-type is the FC4 type, target or initiator.
References: https://library.netapp.com/ecmdocs/ECMP1151595/html/GUID-1D06A7C4-F354-4793-A331-
68A2CD916084.html

NEW QUESTION NO: 15
Click the Exhibit button.

Referring to the exhibit, the write operations would be compacted into how many WAFL blocks?
A. 4
B. 2
C. 3
D. 5
Answer: C
Explanation/Reference:
4k is the block size that WAFL uses to write on each disk.
From the exhibit: 0.5 + 1 + 2 + 1.3 + 1 + 0.5 + 0.5 + 1 + 2 KB equals 9.8 KB, which would fit in 3 WAFL blocks.
References: http://community.netapp.com/t5/Network-Storage-Protocols-Discussions/WAFL-questions- blocks-and-stripes/td-p/31555

NEW QUESTION NO: 16
Which two features provide physical path resiliency from a Windows 2016 server to an iSCSI LUN on a 12- node ONTAP cluster? (Choose two.)
A. broadcast domains
B. MPIO
C. failover groups
D. ALUA
Answer: B,D
Explanation/Reference:
Microsoft Multipath I/O (MPIO) is a Microsoft-provided framework that allows storage providers to develop multipath solutions that contain the hardware-specific information needed to optimize connectivity with their storage arrays. These modules are called device-specific modules (DSMs). The concepts around DSMs are discussed later in this document.
MPIO is protocol-independent and can be used with Fibre Channel, Internet SCSI (iSCSI), and Serial Attached SCSI (SAS) interfaces in Windows Server.
Asymmetric Logical Unit Access (ALUA), also known as Target Port Groups Support (TPGS), is a set of SCSI concepts and commands that define path prioritization for SCSI devices.
References: https://kb.netapp.com/support/s/article/ka21A0000000d32QAA/asymmetric-logical-unit- access-alua-support-on-netapp-storage-frequently-asked-questions?language=en_US

NEW QUESTION NO: 17
What is an array LUN?
A. a LUN provisioned in ONTAP that is mounted by a connected host
B. a LUN provisioned on third-party storage that ONTAP will use as a passthrough LUN
C. a LUN that is used only as a part of a volume group
D. a LUN provisioned on third-party storage that ONTAP will use in a RAID group
Answer: A
Explanation/Reference:
The Data ONTAP software-based scheme provides ownership control only for storage systems running Data ONTAP; it does not prevent a different type of host from overwriting data in an array LUN owned by a system running Data ONTAP. Therefore, if multiple hosts are accessing array LUNs through the same storage array port, be sure to use LUN security on your storage array to prevent the systems from overwriting each other's array LUNs.
References: https://library.netapp.com/ecmdocs/ECMP1196986/html/GUID-D5079042-EA9A-4052-9B00-
670B3728FFAA.html

http://https://www.lead1pass.com/EMC/E05-001-practice-exam-dumps.html (177 Q&As Dumps, 30%OFF Special Discount: 30free )

NEW QUESTION NO: 15
An application generates 8400 small random I/Os at peak workloads with a read/write ratio of 2:1. What is the disk load at peak activity for a RAID 1/0 configuration?
A. 5600
B. 11200
C. 16800
D. 22400
Answer: B
Explanation/Reference:
Explanation:

NEW QUESTION NO: 16
What accurately describes the flow control mechanism in an FC SAN?
A. Both transmitting and receiving ports agree on the number of buffers available during port login
B. Negotiation occurs between an E_Port and an F_Port, and between two N_Ports
C. Credit value is incremented when a frame is transmitted and decremented upon receiving a response
D. Receiver Ready (R_RDY) is sent from the receiving port if available credits reach zero
Answer: A
Explanation/Reference:
Explanation:

NEW QUESTION NO: 17
What is a function of the orchestration layer in a data center infrastructure?
A. Provides workflows for automated execution of management tasks
B. Aggregates physical infrastructure components into resource pools
C. Measures the consumption of IT resources by various services
D. Decouples an operating environment from the underlying hardware
Answer: A
Explanation/Reference:
Explanation:

NEW QUESTION NO: 18
What is signified by the "variety" characteristic of big data?
A. Data is generated in different formats by numerous sources
B. Meaning of the data changes constantly
C. Varying data quality affects its reliability and accuracy
D. Data change rate affects its timely analysis
Answer: A
Explanation/Reference:
Explanation:

NEW QUESTION NO: 19
What contains the information about backup configuration and backup metadata?
A. Backup catalog
B. Proxy server
C. Tracking database
D. Backup image
Answer: A
Explanation/Reference:
Explanation:

NEW QUESTION NO: 20
Which type of Fibre Channel (FC) ports do the labels "X" and "Y" represent in the exhibit?

A. X is an F_Port and Y is an E_Port
B. X is an F_Port and Y is a G_Port
C. X is a G_Port and Y is an N_Port
D. X is an N_Port and Y is an E_Port
Answer: D
Explanation/Reference:
Explanation:

NEW QUESTION NO: 21
What is an accurate statement about a denial-of-service attack?
A. Prevents legitimate users from accessing resources or services
B. Intentional misuse of privileges to compromise data security
C. Gaining unauthorized access to a user's accounts and data
D. Captures a user's credentials and then sends to the attacker
Answer: A
Explanation/Reference:
Explanation:

NEW QUESTION NO: 22
What improves the performance of multi-threaded large block I/O workloads on a solid state drive?
A. Parallel I/O channels
B. I/O coalescing
C. Native command queuing
D. High capacity RAM cache
Answer: A
Explanation/Reference:
Explanation:

NEW QUESTION NO: 23
What is a characteristic of software-defined networking?
A. Abstracts and separates the control plane from the data plane
B. Data plane sends instructions to the control plane to handle network traffic
C. Controller in network switches takes over data plane functions
D. External software combines both data plane and control plane functions
Answer: A
Explanation/Reference:
Explanation:

NEW QUESTION NO: 24
What maps the logical path of a file system to its physical path in a file-level virtualization implementation?
A. Global namespace
B. Remote procedure call
C. Distributed file system
D. Cache coherency
Answer: A
Explanation/Reference:
Explanation:

NEW QUESTION NO: 25
What is an accurate statement about the function of an archiving server?
A. Enables the ability to configure policies for archiving data
B. Installs agents on the archiving storage device
C. Scans the data that can be archived on application servers
D. Creates stub files on an archiving storage device
Answer: A
Explanation/Reference:
Explanation:

NEW QUESTION NO: 6
Which step must be performed before enabling a new inventory organization in SCM cloud for collection from Manage Upstream and Downstream Source System Task?
A. Add the Organization against the OPS source system manually.
B. Create a new source system for each organization.
C. Add the Organization against the OPS destination system.
D. Refresh the Organization List against the Oracle Planning and Sourcing (OPS) source system.
Answer: B

NEW QUESTION NO: 7
Identify two tasks that are used to set up statuses in the orchestration process configuration in the Functional Setup Manager. (Choose two.)
A. Manage Orchestration Status Values
B. Manage Task Status Condition
C. Manage Status Values
D. Manage Orchestration Status
Answer: B,D
Explanation/Reference:
Reference https://docs.oracle.com/cd/E29597_01/fusionapps.1111/E20365_06.pdf

NEW QUESTION NO: 8
Your company is a manufacturer and distributor of CTO type of products globally, and uses Global Order Promising to promise its orders. You recently noticed that the promising results are determining the expected sources globally but not the least-cost ones. You want to understand the logic used by the GOP engine to derive the least-cost source.
Identify the four cost elements used by the cloud Global Order Promising engine to achieve the Profitable- to-Promise objective? (Choose four.)
A. Cost of internal transfers between organizations
B. Storage Cost (when the cost of holding that item in inventory is high)
C. Overhead Cost
D. Resource Consumption Cost (in case the end item is to be manufactured)
E. Component Cost
F. Standard Cost at internal organizations
Answer: A,D,E,F
Explanation/Reference:
Reference https://docs.oracle.com/cd/E56614_01/scmop_gs/FASCP.pdf (page 48)

NEW QUESTION NO: 9
Your company wants to define different status conditions for fulfillment lines that have different categories assigned to a single orchestration process in Order Management Cloud.
Which two configurations would you perform to meet this requirement? (Choose two.)
A. Define a fulfillment line status rule set for each category.
B. Create a unique step for each category and assign different "next expected task statuses."
C. Define orchestration process status values for each category.
D. Assign the status catalog to the orchestration process.
Answer: C,D
Explanation/Reference:
Explanation
An orchestration process is a predefined business process that coordinates the orchestration of physical goods and activities within a single order and automates order orchestration across fulfillment systems.
Reference https://docs.oracle.com/cloud/farel8/scmcs_gs/FAOFO/F1191897AN12E0B.htm

NEW QUESTION NO: 10
You have deployed the Extensible Flexfield (EFF) successfully but it is not visible in the order capture additional information section.
Identify the two reasons for this behavior. (Choose two.)
A. The EFF definition is not frozen.
B. The EFF segments are not defined correctly.
C. The EFF compilation is not done.
D. The custom extensible flexfields are not published.
E. The EFF context is not associated with the page.
Answer: D,E
Explanation/Reference:

NEW QUESTION NO: 11
In which fulfillment process does a specific sales order demand trigger a supply creation, and a firm link is established between the sales order and the supply?
A. Consignment order
B. Internal Transfer
C. Configure to order
D. Back-to-back
E. Drop Ship
Answer: D
Explanation/Reference:
Explanation
The back-to-back fulfillment process is one in which specific sales order demand triggers supply creation, and a link is established between the sales order and the supply.
Reference https://docs.oracle.com/cloud/latest/scmcs_gs/FAIMS/FAIMS1823006.htm#FAIMS1823006

NEW QUESTION NO: 12
Which two activities can you perform by using Global Order Promising's stand-alone work area? (Choose two.)
A. You can split quantities against a Sales Order Line to perform what-if simulations and evaluate better ways of promising an order.
B. You can simulate the Capable-to-Promise option in place of the Available-to-Promise option for quicker fulfillment.
C. You can initiate back-to-back orders to expedite fulfillment of lines with a delayed schedule ship date.
D. You can re-schedule order lines that are already scheduled.
Answer: A,D

NEW QUESTION NO: 13
Your company wants to notify the external system when there is a high possibility that an order is going to be delayed.
Which four steps are required to invoke the external system connector to notify that an order is going to be delayed? (Choose four.)
A. Set up the Jeopardy threshold for the orchestration process task.
B. Set up the lead time for the orchestration steps in the orchestration process definition.
C. Register the web service connector.
D. Create a routing rule for the orchestration process task.
E. Enable a business event trigger point for Jeopardy and associate the connector.
F. Set up the Use Defined Lead time in the Available To Promise Rule.
Answer: A,B,D,E
Explanation/Reference:
Reference https://docs.oracle.com/cloud/latest/scmcs_gs/FAIOM/FAIOM2061950.htm#FAIOM2061950

NEW QUESTION NO: 14
Your company wants to default the preferred fulfillment warehouse and scheduled ship date as order requested date during order import and skip the scheduling task for a particular order type.
What are the two business rules that must be configured to achieve this requirement? (Choose two.)
A. Define a branching condition rule.
B. Define a line selection criteria rule for the scheduling task.
C. Define a compensation pattern rule.
D. Define a lead time expression rule.
E. Define a pre-transformation defaulting rule.
Answer: A,B

NEW QUESTION NO: 15
Which statement is true about the definition of source systems in Functional Setup manager?
A. All order capture and fulfillment systems are defined as Spoke systems.
B. The Oracle Fusion order capture and fulfillment system is defined as Fusion.
C. All external order capture systems are defined as Spoke systems and the Fusion fulfillment system is defined as Fusion.
D. All external order capture systems are defined as Spoke systems and external fulfillment systems are defined as purchased.
Answer: B
Explanation/Reference:
Reference https://docs.oracle.com/cloud/farel8/scmcs_gs/FAOFO/F1191897AN12E0B.htm

NEW QUESTION NO: 16
A tax authority requires that you calculate tax only on the selling price of an item that you are selling, and not on the shipping charge.
How will you achieve this?
A. by moving the "Compute Tax" step before the "Create Net Price Charge Component" step in the Pricing algorithm
B. by creating a sub- algorithm and an expression builder
C. by using nested action and Groovy scripts
D. by moving the "Compute Tax" step before the "Create Shipping Charges" step in the Pricing algorithm
Answer: D

http://https://www.examslabs.com/Oracle/Oracle-Database/best-1z0-062-exam-dumps.html (345 Q&As Dumps, 30%OFF Special Discount: bmzblwH7 )

NEW QUESTION NO: 11
In your production database, data manipulation language (DML) operations are executed on the SALES table.
You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information.
What action would you take to achieve this task?
A. Apply fine-grained auditing.
B. Implement value-based auditing.
C. Impose standard database auditing to audit object privileges.
D. Impose standard database auditing to audit SQL statements.
Answer: A
Explanation/Reference:
Explanation:
https://books.google.com.pk/books?id=TD5eibhYyd8C&pg=PA236&lpg=PA236&dq=oracle+auditing+keep
+track+of+both+the+old+data+and+new+data+in+the+table+long+with+the+user
+information&source=bl&ots=buMRdjIEkm&sig=tHCT-
XUPVSd1eFJZFcr2lkEifvo&hl=en&sa=X&redir_esc=y#v=onepage&q=oracle%20auditing%20keep%
20track%20of%20both%20the%20old%20data%20and%20new%20data%20in%20the%20table%20long%
20with%20the%20user%20information&f=false

NEW QUESTION NO: 12
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?
A. It will create a multitenant container database (CDB) with only the root opened.
B. It will create a CDB with root opened and seed read only.
C. It will create a CDB with root and seed opened and one PDB mounted.
D. It will create a CDB that must be plugged into an existing CDB.
E. It will create a CDB with root opened and seed mounted.
Answer: B
Explanation/Reference:
Explanation:
* The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs.
Along with the root (CDB$ROOT), Oracle Database automatically creates a seed PDB (PDB$SEED). The following graphic shows a newly created CDB:

* Creating a PDB
Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual significance; rather, it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation.

NEW QUESTION NO: 13
You are connected to a pluggable database (PDB) as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:
SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = '*' SCOPE = SPFILE; Which is true about the result of this command?
A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
Answer: C
Explanation/Reference:
Explanation:
Note:
* In a container architecture, the parameters for PDB will inherit from the root database. That means if statistics_level=all in the root that will cascade to the PDB databases.
You can override this by using Alter system set, if that parameter is pdb modifiable, there is a new column in v$system_parameter for the same.

NEW QUESTION NO: 14
You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.
A. 2, 1, 3, 4, 5, 6
B. 1, 3, 4, 5, 6, 7
C. 1, 4, 3, 5, 6, 7
D. 2, 1, 3, 4, 5, 6, 7
E. 1, 5, 6, 4, 3, 2
Answer: C
Explanation/Reference:
Explanation:
1. Set user tablespaces in the source database to READ ONLY.
2. From the Oracle Database 11g Release 2 {11.2.0.3) environment, export the metadata and any data residing in administrative tablespaces from the source database using the FULL=Y and TRANSPORTABLE=ALWAYS parameters. Note that the VER$ION=12 parameter is required only when exporting from an Oracle Database llg Release 2 database:
3. Copy the tablespace data files from the source system to the destination system. Note that the log file from the export operation will list the data files required to be moved.
4. Create a COB on the destination system, including a PDB into which you will import the source database.
5. In the Oracle Database 12c environment, connect to the pre-created PDB and import the dump file. The act of importing the dump file will plug the tablespace data files into the destination PDB Oracle White Paper - Upgrading to Oracle Database 12c -August 2013

NEW QUESTION NO: 15
In which two scenarios do you use SQL* Loader to load data?
A. Transform the data while it is being loaded into the database.
B. Use transparent parallel processing without having to split the external data first.
C. Load data into multiple tables during the same load statement.
D. Generate unique sequential key values in specified columns.
Answer: A,D
Explanation/Reference:
Explanation:
You can use SQL*Loader to do the following:
/(A) Manipulate the data before loading it, using SQL functions.
/(D) Generate unique sequential key values in specified columns.
etc:
/Load data into multiple tables during the same load session.
/Load data across a network. This means that you can run the SQL*Loader client on a different system from the one that is running the SQL*Loader server.
/Load data from multiple datafiles during the same load session.
/Specify the character set of the data.
/Selectively load data (you can load records based on the records' values).
/Use the operating system's file system to access the datafiles.
/Load data from disk, tape, or named pipe.
/Generate sophisticated error reports, which greatly aid troubleshooting.
/Load arbitrarily complex object-relational data.
/Use secondary datafiles for loading LOBs and collections.
/Use either conventional or direct path loading. While conventional path loading is very flexible, direct path loading provides superior loading performance.
Note:
* SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile.

NEW QUESTION NO: 16
You use a recovery catalog for maintaining your database backups.
You execute the following command:
$rman TARGET / CATALOG rman / cat@catdb
RMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
Which two statements are true?
A. Corrupted blocks, if any, are repaired.
B. Checks are performed for physical corruptions.
C. Checks are performed for logical corruptions.
D. Checks are performed to confirm whether all database files exist in correct locations
E. Backup sets containing both data files and archive logs are created.
Answer: B,D
Explanation/Reference:
Explanation:
B (not C): You can validate that all database files and archived redo logs can be backed up by running a command as follows:
RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
This form of the command would check for physical corruption. To check for logical corruption, RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;
D: You can use the VALIDATE keyword of the BACKUP command to do the following:
Check datafiles for physical and logical corruption
Confirm that all database files exist and are in the correct locations.
Note:
You can use the VALIDATE option of the BACKUP command to verify that database files exist and are in the correct locations (D), and have no physical or logical corruptions that would prevent RMAN from creating backups of them. When performing a BACKUP...VALIDATE, RMAN reads the files to be backed up in their entirety, as it would during a real backup. It does not, however, actually produce any backup sets or image copies (Not A, not E).

NEW QUESTION NO: 17
Which action takes place when a file checkpoint occurs?
A. The checkpoint position is advanced in the checkpoint queue.
B. All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWn and the SCN is stored in the control file.
C. The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files.
D. The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log files.
Answer: C
Explanation/Reference:
Explanation:

NEW QUESTION NO: 18
Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges?
A. Bind Variable Peeking
B. SQL Plan Baselines
C. Adaptive Cursor Sharing
D. Bind variable used in a SQL statement
E. Literals in a SQL statement
Answer: A,C,E
Explanation/Reference:
Explanation:
* In bind variable peeking (also known as bind peeking), the optimizer looks at the value in a bind variable when the database performs a hard parse of a statement.
When a query uses literals, the optimizer can use the literal values to find the best plan. However, when a query uses bind variables, the optimizer must select the best plan without the presence of literals in the SQL text. This task can be extremely difficult. By peeking at bind values the optimizer can determine the selectivity of a WHERE clause condition as if literals had been used, thereby improving the plan.
C: Oracle 11g/12g uses Adaptive Cursor Sharing to solve this problem by allowing the server to compare the effectiveness of execution plans between executions with different bind variable values. If it notices suboptimal plans, it allows certain bind variable values, or ranges of values, to use alternate execution plans for the same statement. This functionality requires no additional configuration.

NEW QUESTION NO: 19
In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?
A. The CDB must be open.
B. The CDB must be in the mount stage.
C. The CDB must be in the nomount stage.
D. Alt existing PDBs must be closed.
Answer: A
Explanation/Reference:
Explanation:
* Creating a PDB
Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual significance; rather, it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation. The size of the seed PDB is only about 1 gigabyte and it takes only a few seconds on a typical machine to copy it.

NEW QUESTION NO: 20
You execute the following commands to audit database activities:
SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;
SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL;
Which statement is true about the audit record that generated when auditing after instance restarts?
A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
Answer: A
Explanation/Reference:
Explanation:
Note:
* BY SESSION
In earlier releases, BY SESSION caused the database to write a single record for all SQL statements or operations of the same type executed on the same schema objects in the same session. Beginning with this release (11g) of Oracle Database, both BY SESSION and BY ACCESS cause Oracle Database to write one audit record for each audited statement and operation.
* BY ACCESS
Specify BY ACCESS if you want Oracle Database to write one record for each audited statement and operation.
Note:
If you specify either a SQL statement shortcut or a system privilege that audits a data definition language (DDL) statement, then the database always audits by access. In all other cases, the database honors the BY SESSION or BY ACCESS specification.
* For each audited operation, Oracle Database produces an audit record containing this information:
/The user performing the operation
/The type of operation
/The object involved in the operation
/The date and time of the operation
References:

NEW QUESTION NO: 21
Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX?
A. Thread creation must be routed through a dispatcher process
B. The local listener may spawn a now process and have that new process create a thread
C. Each Oracle process runs an SCMN thread.
D. Each multithreaded Oracle process has an SCMN thread.
E. The local listener may pass the request to an existing process which in turn will create a thread.
Answer: A,D,E
Explanation/Reference:
Explanation:

http://https://www.lead1pass.com/Dell/DCPPE-200-practice-exam-dumps.html (88 Q&As Dumps, 30%OFF Special Discount: 30free )

NEW QUESTION NO: 7
In VRTX the following features are enabled:
1. Server Module Firmware Update
2. Remote syslog
3. iDRAC Single Sign-on.
4. Server configuration
5. Chassis grouping
6. Enclosure level backup
Which license type is required?
A. CMC enterprise license
B. CMC express license
C. iDRAC express license
D. iDRAC enterprise license
Answer: A
Explanation/Reference:
Reference: http://en.community.dell.com/cfs-file/__key/telligent-evolution-components-attachments/13-
4491-00-00-20-40-24-15/VRTX-CMC_5F00_Feature-Guide.pdf?forcedownload=true

NEW QUESTION NO: 8
An engineer responsible for server lifecycle management (e.g. Monitor, Update, Deploy) needs to build a monitoring strategy for a multi-vendor data center. The company has an established third party software as the monitoring and help desk system.
Which option should be used to integrate Dell Server hardware into this monitoring architecture?
A. Configure all Dell iDRACs to send alerts to OME to filter out wanted alerts and forward to the third party console. Build script to do the rest of the Dell server lifecycle management.
B. Configure all Dell iDRACs to send alerts to OME to filter out wanted alerts and forward to the third party console. Use OME to do lifecycle management of Dell servers in the environment.
C. Configure all Dell iDRACs to send alerts to the third party console. Use iDRAC to perform update and deployment.
D. Configure all Dell iDRACs to send alerts to the third party console. Use OME to do the rest of the lifecycle management.
Answer: B

NEW QUESTION NO: 9
An engineer is deploying a chassis with four IOAs and connecting it to the top of rack (ToR) switch. The deployment mandate requires that the switches be presented as one logical unit. Future servers can be added to network with the minimal amount of configuration.
The following steps have been completed:
- IOAs are daisy-chained using ports 9 and 10
- Cabled ports 11 and 12 on IOA 1 to the ToR
- Configured a team on NIC ports 1 and 2 on the server
How should the IOMs be configured?
A. Programmable MUX
B. Stack
C. Full Switch
D. Virtual Link Trunking
Answer: A

NEW QUESTION NO: 10
An engineer is redeploying a blade chassis, and is logged into the CMC web interface. The engineer has configured the iDRACs for the blade servers.
When the engineer tries to log into one of the iDRACs, the connection fails. The engineer can ping the CMC from the engineer's workstation but can NOT ping the iDRACs. The engineer tries to ping the iDRAC IP from the CMC itself using the diagnostic tool, but that also fails.
Which two tasks should the engineer perform? (Choose two.)
A. Confirm subnet mask configuration on iDRAC
B. Disable firewall service on iDRAC
C. Check VLAN settings on the CMC and iDRAC
D. Update DNS servers for iDRAC
E. Enable IPv6 on the CMC and iDRAC
Answer: A,B

NEW QUESTION NO: 11
A VRTX has storage set up as a RAID 10 in a 16-drive disk group. Each drive is 1.6 TB for a total of 12.8 TB space in the disk group. There are currently 14 virtual disks of 600GB each. The engineer needs to create three more virtual disks. The engineer successfully creates two virtual disks but is unable to create the third because there are NO physical disks to choose from.
What must the engineer do to create the final virtual disk?
A. Perform a reconstruct of the physical disk group
B. Create a new disk group with additional physical disks
C. Update the Shared PERC 8 Firmware
D. Recreate the virtual disks with 400GB allocated
Answer: D

NEW QUESTION NO: 12
An engineer is troubleshooting a VRTX with the following configuration:
- Dual Shared PERC Internal cards in a fault tolerant configuration
- Nodes installed in SLOTS 1 and 2
- Virtual adapters set to Multiple Assignment
- Two virtual drives set to Full Access on SLOTS 1 and 2
The OS of the node in SLOT 1 shows more than the two disks assigned to it.
What should the engineer do to fix this issue?
A. Configure MPIO services in the OS of SLOT 1
B. Power cycle the node in SLOT 1 to reset the connections
C. Set the virtual adapters to Single Assignment
D. Set the virtual drives to No Access on SLOT 2
Answer: D

NEW QUESTION NO: 13
An engineer is configuring a new FD332 storage sled into an existing chassis in SLOT 3. The FD332 is NOT being detected by the assigned node.
Which two tasks must an engineer complete so that the FD332 is detected by the node? (Choose two.)
A. Power cycle the node
B. Enable the PERC in storage sled
C. Import the PERC license
D. Verify firmware is up to date
E. Reseat the FD332
Answer: B,D

NEW QUESTION NO: 14

Refer to the exhibit.
An engineer sets up FCoE boot on their server. The server fails during post.
What needs to be added to the NIC settings/option ROM to make booting successful?
A. The WWN of the FIP snooping bridge
B. The WWN of the storage target
C. The WWN of the FC port ID
D. The WWN of the fibre channel switch
Answer: C
Explanation/Reference:

NEW QUESTION NO: 15
Only one of the server nodes in the FX2s chassis can see the FD332.
How should the chassis be configured so that both nodes can see the storage?
A. Set storage mode to split dual host
B. Enable clustering in the CMC
C. Enable shared storage in the CMC
D. Set storage mode to joined dual host
Answer: A

NEW QUESTION NO: 16
An engineer is migrating an existing server node from an M1000E to a VRTX chassis. An error message appears during POST. The system will continue to boot, but can NOT see any of the chassis shared storage or PCIe devices mapped to the server slot. The engineer has already removed the original fabric interfaces in mezzanine slot B and C from the original system configuration.
Which action must the engineer complete to allow the node to see chassis storage and mapped PCIe devices?
A. Enable PCIe Pass-Through in System Setup
B. Install PCIe Pass-Through mezzanine cards
C. Remap chassis storage/PCIe devices
D. Update the CPLD firmware version
Answer: A

NEW QUESTION NO: 17
An engineer is configuring a new FD332 storage sled into an existing chassis in SLOT 3. The engineer is unable to create any RAID arrays although the drives are detected.
Which task should be completed to create RAID volumes?
A. Import the PERC license into the iDRAC
B. Change storage mode to joined in the CMC
C. Enable the PERC in storage sled.
D. Configure RAID in Ctrl+R
Answer: C

NEW QUESTION NO: 6
You have a dataset.
You need to repeatedly split randomly the dataset so that 80 percent of the data is used as a training set and the remaining 20 percent is used as a test set.
Which method should you use?
A. threshold
B. binary classification
C. imputation
D. cross validation
E. pruning
Answer: D
Explanation/Reference:
Explanation:

NEW QUESTION NO: 7
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You need to calculate a measure of central tendency and variability for the variables in a dataset that is grouped by using another categorical variable.
What should you use?
A. the Describe package
B. the rxHistogram function
C. the rxSummary function
D. the rxQuantile function
E. the rxCube function
F. the summary function
G. the rxCrossTabs function
H. the ggplot2 package
Answer: C
Explanation/Reference:
Explanation:

NEW QUESTION NO: 8
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You need to evaluate the significance of coefficients that are produced by using a model that was estimated already.
Which function should you use?
A. rxPredict
B. rxLogit
C. summary
D. rxLinMod
E. rxTweedie
F. stepAic
G. rxTransform
H. rxDataStep
Answer: D
Explanation/Reference:
Explanation:
References: https://docs.microsoft.com/en-us/machine-learning-server/r/how-to-revoscaler-linear-model

NEW QUESTION NO: 9
DRAG DROP
You are using rxPredict for a logistic regression model.
You need to obtain prediction standard errors and confidence intervals.
Which R code segment should you use? To answer, drag the appropriate values to the correct targets.
Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Answer: 

Explanation/Reference:
Explanation:
References: https://docs.microsoft.com/en-us/machine-learning-server/r/how-to-revoscaler-logistic- regression

NEW QUESTION NO: 10
You need to run a large data tree model by using rxDForest. The model must use cross validation.
Which rxDForest option should you use?
A. maxSurrogate
B. maxNumBins
C. maxDepth
D. maxCompete
E. xVal
Answer: E
Explanation/Reference:
Explanation:
References: https://docs.microsoft.com/en-us/machine-learning-server/r/how-to-revoscaler-decision-tree

NEW QUESTION NO: 11
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You need to generate a residual based on two columns. The solution must build a trend indicator.
Which function should you use?
A. rxPredict
B. rxLogit
C. summary
D. rxLinMod
E. rxTweedie
F. stepAic
G. rxTransform
H. rxDataStep
Answer: A
Explanation/Reference:
Explanation:
References:https://docs.microsoft.com/en-us/machine-learning-server/r-reference/revoscaler/rxpredict

NEW QUESTION NO: 12
You have an Apache Hadoop Hive data warehouse. RevoScalerR is not installed.
You need to sort the data according to the variables in the dataset.
What should you do?
A. Connect to the database by using an ODBC connection, and then use the rxSort function.
B. Create a table in the ORC file format.
C. Connect to the database by using an ODBC connection, and then use the rxDataStep function.
D. Execute a Hive query that sorts the data, and then reads the results.
Answer: D
Explanation/Reference:
Explanation:

NEW QUESTION NO: 13
You need to build a model that looks at the probability of an outcome. You must regulate between L1 and L2.
Which classification method should you use?
A. Two-Class Neutral Network
B. Two-Class Support Vector Machine
C. Two-Class Decision Forest
D. Two-Class Logistic Regression
Answer: D
Explanation/Reference:
Explanation:
References: https://msdn.microsoft.com/en-us/library/azure/dn905994.aspx

NEW QUESTION NO: 14
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 sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft SQL Server instance that has R Services (In-Database) installed.
You need to monitor the R jobs that are sent to SQL Server.
Solution: You create an events trace configuration file and place the file in the same directory as the BXLServer process.
Does this meet the goal?
A. Yes
B. No
Answer: B
Explanation/Reference:
Explanation:

NEW QUESTION NO: 15
You have a dataset that has a character variable.
You need to create a bag of counts of n-grams.
Which function should you use?
A. featurizeText()
B. categoricalHash()
C. concat()
D. selectFeatures()
E. categorical()
Answer: A
Explanation/Reference:
Explanation:
References: https://docs.microsoft.com/en-us/machine-learning-server/python-reference/microsoftml/ featurize-text

NEW QUESTION NO: 16
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You need to estimate a model where the outcome variable is continuous, is in the range of [0, inf], and has a substantial mass at an exact value of 0.
Which function should you use?
A. rxPredict
B. rxLogit
C. summary
D. rxLinMod
E. rxTweedie
F. stepAic
G. rxTransform
H. rxDataStep
Answer: F
Explanation/Reference:
Explanation:

NEW QUESTION NO: 9
Your customer wants the Goals and Competency sections of the performance template to be populated based on the Job which is assigned to a worker.
What two options should you use to configure this requirement? (Choose two.)
A. Populate the Job profile with Job-specific Goals and in the performance template section of Goals setup, choose the option of Use Specific Profile and select Job profile.
B. Populate the Job profile with Job-specific Competencies and in the performance template section of Competencies setup, choose the option of Use Specific Profile and select Job profile.
C. Create an eligibility profile based on worker Job and populate worker Goals using the Mass Assign process before the creation of the performance document. In the performance template section of Goals, choose the option of Use Employee's Goals.
D. Create an eligibility profile based on worker Job and populate worker Competencies using the Mass Assign process before the creation of the performance document. In the performance template section of Goals, choose the option of Use Employee's Competencies.
E. Create an eligibility profile based on worker Job and the HR Specialist could mass insert Competencies into already created performance documents using the Mass Assign process.
F. Create an eligibility profile based on worker Job and the HR Specialist could mass insert Goals into already created performance documents using the Mass Assign process.
Answer: A,C

NEW QUESTION NO: 10
Identify three setup tasks required before goals can be managed. (Choose three.)
A. Mass-assign goals.
B. Manage goal library.
C. Manage goal management notification.
D. Manage worker goal setting lookups.
E. Manage value sets (if flexfields are deployed for goals).
Answer: A,C,D

NEW QUESTION NO: 11
Which two statements are true regarding a performance template section? (Choose two.)
A. The Profile Content section can be both rated and weighted.
B. The Overall Summary section can be rated but not weighted.
C. The Manager Final Feedback section can be rated and weighted.
D. The Worker Final Feedback section can be rated and weighted.
E. The Goals section can be weighted but not rated.
Answer: B,C

NEW QUESTION NO: 12
Your customer would like two performance templates. They would like to have a Level 1 approval in one performance template, and no approval in another performance template.
How should you set this up?
A. Create two performance templates and attach these to different process flows where the approval task could be defined.
B. Create two performance documents and attach these with different performance documents. At the performance document level, the approval level could be defined.
C. Create two process flows for the two different performance templates. Then configure the performance template with approval required for one of the templates.
D. This is not possible at Performance Management configuration level. Changes could be made in the BPM work list to implement this requirement.
Answer: B

NEW QUESTION NO: 13
You configure questions and responses in the question library to add to the questionnaire. Identify four question types that can be defined in the question library. (Choose four.)
A. Multiple choice - You provide responses and respondents select one or more responses from the options available.
B. Text - Respondent enters a response in a text field.
C. Single choice - Respondent selects a single choice from selections you provide.
D. No response - It is used to provide additional information or allow respondents to add attachments.
E. Additional response - It is used to provide additional information or add attachments.
Answer: A,B,C,E

NEW QUESTION NO: 14
The Department Manager has created an organization goal "Improve Organization Sales." The goal is assigned to all workers who fall under the organization hierarchy. The goal-setting process is completed across the organization. At the midpoint of the goal period, the Department Manager would like to know if the workers in his or her organization are achieving the goals that are aligned to the organization's goal
"Improve Organization Sales."
How can the Department Manager see the desired information?
A. By viewing the Goal Progress Summary report. The infographics, the pie chart, for each goal on My Organization Goals page will show the summary of aligned goals in different statuses.
B. By viewing the Goal Alignment Summary report.
C. By viewing either the Goal Alignment Summary report or the Goal Progress Summary report.
D. By creating a new dashboard report on the My Goals page.
E. By creating a new dashboard report on the Organization Goals page.
Answer: B

NEW QUESTION NO: 15
You are implementing Oracle Performance Management Cloud with the requirements that during performance evaluation, a manager should be able to allocate rewards to direct reports and also be able to promote them.
How do you meet these requirements?
A. Include the Manager Promotions task in the process flow, but handle rewards separately in compensation management.
B. In the performance process flow setup, include the tasks Allocate Rewards and Manage Promotions.
C. Recommend that the client perform those tasks outside the performance evaluation process in compensation management.
D. Configure the performance document sections to include rewards and promotions.
E. Include the Allocate Rewards subtask in the process flow, but handle promotions separately in core HR.
Answer: A

NEW QUESTION NO: 16
If all tasks and subtasks are included in the Performance flow, except the Set Goals task, can the competencies and goals be added for a worker in his or her performance document?
A. Yes. Only goals can be added in the worker self-evaluation task.
B. Yes. Only competencies can be added in the manager evaluation of worker tasks.
C. Yes. Goals and competencies can be added in the worker self-evaluation task only.
D. Yes. Goals and competencies can be added in the manager evaluation of worker tasks only.
E. No. Without the Set Goals task, goals and competencies cannot be added in the performance document.
F. Yes. Goals and competencies can be added in either the worker self-evaluation or the manager evaluation of worker tasks.
Answer: E

NEW QUESTION NO: 17
Your company's appraisal policy requires that the content of the performance document be added in a collaborative manner.
Implementation requirements include:
- Both the worker and the manager are required to rate the worker.
- Conduct a review meeting for the worker, which the worker must acknowledge.
- Both the manager and the worker should be able to give their comments on the entire evaluation process.
- Workers and managers should start setting goals for the next period.
To meet these requirements, what are the correct tasks and their sequence to be designed in the process flow?
A. Set goals, worker self-evaluation, manager evaluation of worker, provide final feedback, confirm review meeting held, set next period goals.
B. Set next period goals, set goals, first approval, worker self-evaluation, manager evaluation of worker, confirm review meeting held, provide final feedback.
C. Set goals, worker self-evaluation, manager evaluation of worker, share performance document, first approval, confirm review meeting held, provide final feedback.
D. Set goals, manager evaluation of worker, share performance document, confirm review meeting held, provide final feedback.
E. Set goals, worker self-evaluation, manager evaluation of worker, confirm review meeting held, set next period goals.
F. Set goals, first approval, manager evaluation of worker, worker self-evaluation, provide final feedback, second approval, set next period goals.
Answer: C

NEW QUESTION NO: 18
An HR specialist recently created a performance goal plan for his or her organization. Two new hires have joined the organization after the existing goal plan was created and assigned.
- Employee 1 is required to have all the goals in the existing goal plan.
- Employee 2 needs goals A1 and A2 in addition to the goals in the existing goal plan.
- Goals A1 and A2 need to be added to the goal library.
Which statement addresses these requirements?
A. The HR specialist can add the eligibility criteria to new goals (A1 and A2) within the goal plan and assign both the new hires to the existing goal plan.
B. The HR specialist can create a new goal plan with goals from the existing goal plan, add goals A1 and A2 from the goal library, and assign them to both the new hires.
C. The HR specialist can assign Employee 1 to the existing goal plan, create a new goal plan with goals (A1 and A2) from the goal library, and then assign the new goal plan to Employee 2.
D. The HR specialist can add goals A1 and A2 to the goal library, add those goals to the existing goal plan, and then add both the new hires to the goal plan.
Answer: B

NEW QUESTION NO: 19
Identify two correct statements for Goal Plan setup. (Choose two.)
A. The start and end dates of a Goal Plan have to be within the review period.
B. Long-term goals can only be created within long-term goal plans and cannot exist across goal plans.
C. Goal Plan dates are defaulted from review period dates.
D. The review period attached to a Goal Plan restricts the user from creating long-term goals.
E. The performance document attached to a Goal Plan decides the Goal Plan inclusion in a performance document.
Answer: A,E

NEW QUESTION NO: 7
You plan to install a Nano Server on a physical server named Nano1. Nano1 will host several virtual machines that will use live migration. Which package should you install on Nano1?
A. Microsoft-NanoServer-SecureStartup-Package
B. Microsoft-NanoServer-Storage-Package
C. Microsoft-NanoServer-ShieldedVM-Package
D. Microsoft-NanoServer-FailoverCluster-Package
E. Microsoft-NanoServer-Compute-Package
Answer: E

NEW QUESTION NO: 8
You have a failover cluster named Cluster1.
A virtual machine named VM1 is a highly available virtual machine that runs on Cluster1. A custom application named App1 runs on VM1.
You need to configure monitoring on VM1. If App1 adds an error entry to the Application even log, VM1 should be automatically rebooted and moved to another cluster node.
Which tool should you use?
A. Resource Monitor
B. Failover Cluster Manager
C. Server Manager
D. Hyper-V Manager
Answer: B
Explanation/Reference:
Explanation:
Do you have a large number of virtualized workloads in your cluster? Have you been looking for a solution that allows you to detect if any of the virtualized workloads in your cluster are behaving abnormally? Would you like the cluster service to take recovery actions when these workloads are in an unhealthy state? In Windows Server 2012/2016, there is a great new feature, in Failover Clustering called "VM Monitoring", which does exactly that - it allows you monitor the health state of applications that are running within a virtual machine and then reports that to the host level so that it can take recovery actions.
VM Monitoring can be easily configured using the Failover Cluster Manager through the following steps:
Right click on the Virtual Machine role on which you want to configure monitoring

Select "More Actions" and then the "Configure Monitoring" options

You will then see a list of services that can be configured for monitoring using the Failover Cluster

Manager.
References: https://blogs.msdn.microsoft.com/clustering/2012/04/18/how-to-configure-vm-monitoring-in- windows-server-2012/

NEW QUESTION NO: 9
You have two servers named Server1 and Server2 that run Windows Server 2016.
You plan to implement Storage Replica to replicate the contents of volumes on Server1 to Server2.
You need to ensure that the replication traffic between the servers is limited to a maximum of 100 Mbps.
Which cmdlet should you run?
A. Set-NetUDPSetting
B. New-StorageQosPolicy
C. Set-SmbBandwidthLimit
D. Set-NetTCPSetting
E. Set-NetworkController
Answer: C
Explanation/Reference:
Explanation:
PS C:\> Set-SmbBandwidthLimit -Category Default -BytesPerSecond 100MB
This command limits SMB traffic to 100 megabytes per second for traffic that is unrelated to Hyper-V over SMB or Live Migration.
References: https://docs.microsoft.com/en-us/powershell/module/smbshare/set-smbbandwidthlimit?
view=win10-ps

NEW QUESTION NO: 10
Your network contains an Active Directory domain named contoso.com. The domain contains two servers named Server1 and Server2 that run Windows Server 2016. The servers have the same hardware configuration.
You need to asynchronously replicate volume F: from Server1 to Server2.
What should you do?
A. Install the Failover Clustering feature and create a new cluster resource group.
B. Run Set-DfsrServiceConfiguration and specify the -RPCPort parameter.
C. Run New-SRPartnership and specify the -ReplicationMode parameter.
D. Install the Failover Clustering feature and use Cluster Shared Volumes (CSV).
Answer: C
Explanation/Reference:
Explanation:

-ReplicationMode
Specifies the desired mode of replication for this source and destination pair. The acceptable values for this parameter are:
Synchronous or 1. The synchronous mode requires all writes to commit on the destination server and

on the source server, which guarantees data integrity between computers.
Asynchronous or 2. The asynchronous mode writes to the source server without waiting for the

destination server, which allows for replication over high latency, geographic networks. The default value is synchronous.
The default asynchronous recovery point alert time is 5 minutes. You can modify it by using the SetSRPartnership cmdlet. The alert time has no effect on replication behavior, only on reporting.
References:
https://docs.microsoft.com/en-us/powershell/module/storagereplica/new-srpartnership?view=win10-ps
https://msandbu.wordpress.com/2016/05/13/getting-started-with-storage-replica-in-windows-server-2016/
https://www.starwindsoftware.com/blog/how-to-configure-storage-replication-using-windows-server-2016- part-1

NEW QUESTION NO: 11
You are deploying a small network that has 30 client computers. The network uses the 192.168.1.0/24 address space. All computers obtain IP configurations from a DHCP server named Server1.
You install a server named Server2 that runs Windows Server 2016. Server2 has two network adapters named internal and Internet. Internet connects to an Internet service provider (ISP) and obtains the
131.107.0.10 IP address. Internal connects to the internal network and is configured to use the
192.168.1.250 IP address.
You need to provide Internet connectivity for the client computers.
What should you do?
A. On Server2, select the Internet and Internal network adapters and bridge the connections. From the DHCP console on Server1, authorize Server2.
B. On Server1, stop the DHCP server. On the Internal network adapter on Server 2, enable Internet Connection Sharing (ICS).
C. On Server2 run the New-NetNat -Name NAT1 -InternalIPInterfaceAddressPrefix 1 92.168.1.0/24 cmdlet. Configure Server1 to provide the 003 Router option of 1 31.107.0.10.
D. Install the Routing role service on Server2 and configure the NAT routing protocol. Configure Server1 to provide the 003 Router option of 192.168.1.250.
Answer: B
Explanation/Reference:
References: https://en.wikipedia.org/wiki/Internet_Connection_Sharing

NEW QUESTION NO: 12
You have a Hyper-V host named Server1 that runs Windows Server 2016. Server1 has two virtual machines named VM1 and VM2.
You discover that VM1 and VM2 can communicate with Server1 over the network.
You need to ensure that VM1 and VM2 can communicate with each other only. The solution must prevent VM1 and VM2 from communicating with Server1.
Which cmdlet should you use?
A. Enable-VMSwitchExtention
B. Set-NetNeighbor
C. Set-VMSwitch
D. Remove-VMSwitchTeamMember
Answer: C
Explanation/Reference:
The virtual switch needs to be configured as an "Private" switch.
Explanation/Reference: Explanation:
PS C:\> Set-VMSwitch WA -SwitchType Private
This example converts a virtual switch named WA to an Private switch.
-SwitchType
Converts a virtual switch from one type to another. Allowed values are Internal or Private.
The virtual switch needs to be configured as an "Private" switch.

NEW QUESTION NO: 13
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 questions sets might have more than one correct solutions, 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.
You have a Hyper-V host named Server1 that hosts a virtual machine named VM1. Server1 and VM1 run Windows Server 2016. The settings for VM1 are configured as shown in the exhibit below:

You need to ensure that you can use the Copy-VMFile cmdlet on Server1 to copy files from VM1.
Solution: You need to enable the Data Exchange integration service for VM1 Does this meet the goal?
A. Yes
B. No
Answer: B
Explanation/Reference:
Explanation:
Guest Services:
This is a new Integration Services component introduced in Windows Server 2012 R2 that is disabled by default.
Guest Services enables the copying of files to a virtual machine using WMI APIs or using the new Copy- VMFile PowerShell cmdlet

NEW QUESTION NO: 14
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a Hyper-V host named Server1 that runs Windows Server 2016 and a two-node scale-out file server cluster named Cluster1.
A virtual machine named VM1 runs on Server1.
You need to migrate the storage on VM1 to Cluster1.
Which tool should you use?
A. the clussvc.exe command
B. the cluster.exe command
C. the Computer Management snap-in
D. the configurehyperv.exe command
E. the Disk Management snap-in
F. the Failover Cluster Manager snap-in
G. the Hyper-V Manager snap-in
H. the Server Manager app
Answer: G
Explanation/Reference:
Explanation:
Hyper-V in Windows Server 2012 introduces support for moving virtual machine storage without downtime by making it possible to move the storage while the virtual machine remains running.
You can perform this task by using a new wizard in Hyper-V Manager or by using new Hyper-V cmdlets for Windows PowerShell.
References: https://technet.microsoft.com/en-us/library/hh831656(v=ws.11).aspx

NEW QUESTION NO: 15
You have a Hyper-V host named Server1 that runs Windows Server 2016. Server1 hosts a virtual machine named VM1 that runs Windows Server 2016.
You install the Hyper-V server role on VM1.
You need to ensure that the virtual machines hosted on VM1 can communicate with the virtual machines hosted on Server1.
What should you do?
A. On Server1, run the Set-VmNetworkAdapterIsolation cmdlet and specify the -MultiTenantStack Off parameter.
B. On VM1, run the Set-VMNetworkAdapter cmdlet and specify the -MacAddressSpoofing Off parameter.
C. On VM1, run the Set-VmNetworkAdapterIsolation cmdlet and specify the -MultiTenantStack On parameter.
D. On Server1, run the Set-VMNetworkAdapter cmdlet and specify the -MacAddressSpoofing On parameter.
Answer: D

NEW QUESTION NO: 16
You have a server named Server1.
You enable BitLocker Drive Encryption (BitLocker) on Server1.
You need to change the password for the Trusted Platform Module (TPM) chip.
What should you run on Server1?
A. bdehdcfg-exe
B. Initialize-Tpm
C. Import-TpmOwnerAuth
D. repair-bde.exe
Answer: C

NEW QUESTION NO: 17
Active Directory Recycle Bin is enabled. You discover that a support technician accidentally removed 100 users from an Active Directory group named Group1 an hour ago. You need to restore the membership of Group1.
What should you do?
A. Perform tombstone reanimation.
B. Export and import data by using Dsamain.
C. Perform a non-authoritative restore.
D. Recover the items by using Active Directory Recycle Bin.
Answer: B
Explanation/Reference:
Explanation:
A group has been modified. Nothing has been deleted. Therefore, answers A and D will not work. Answer C would work if it was an authoritative restore, but not a non-authoritative restore.
The solution is to recover an earlier copy of the group from a backup or active directory snapshot by using Dsamain.
References:
https://technet.microsoft.com/en-us/library/cc772168(v=ws.11).aspx https://www.briefmenow.org/microsoft/ you-need-to-restore-the-membership-of-group1-15/