70-347 Certification Study Material

Microsoft

70-347

Enabling Office 365 Services

Question: 1

You are the Microsoft Lync administrator for a company that uses Lync Online. The company has mandated that employees may use Lync Online to communicate with contacts from approved external domains. You need to configure Lync Online to allow Lync federation with only three specific domains. You must achieve this goal by using the least amount of administrative effort. Which two actions should you perform? Each correct answer presents part of the solution. 

A. In the Lync admin center, set the External Access option to On except for blocked domains.

B. In the Office 365 admin center, add the three domains to the domain list and set the domain intent for each domain to Lync Online.

C. In the Lync admin center, set the External Access option to Off completely.

D. In the Lync admin center, set the External Access option to On only for allowed domains.

E. In the Lync admin center, configure the Presence Privacy Mode option to display presence information only to the users' contacts.

F. In the Lync admin center, add the three domains to the Blocked Or Allowed Domains list. 

Answer: BC

Question: 2

Your company is planning to migrate to Microsoft Exchange Online. The company employs 1,000 people,

each with a mailbox currently located on Exchange 2010 on-premises. You estimate that it will take a minimum of four weeks to migrate all mailboxes from on-premises Exchange to Exchange Online. The company has the following migration requirements:  • During the migration, do not change the existing Microsoft Outlook profiles and .ost files used by the employees. • Ensure that email messages sent between on-premises mailboxes and online mailboxes during the migration are secure. • Do not send email messages between on-premises mailboxes and online mailboxes over the Internet in plain text. You need to select the migration strategy that meets the requirements.  Which migration strategy should you use? 

A. Cutover migration only

B. IMAP migration only

C. Remote move migration only

D. Staged migration only 

Answer: D

Question: 3

You are the Office 365 administrator for your company. You have been receiving many unsolicited email messages originating from another country. Many of those messages contain foreign-language content. You need to configure Microsoft Exchange Online Protection to filter messages based on the language content and IP addresses of the country or region of origin. Which filters and options should you configure? To answer, drag the appropriate answer choices to the correct targets. Each answer choice 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.

 

Answer:

Question: 4

You are the Office 365 administrator for your company. You manage an on-premises Microsoft Exchange Server 2003 environment that has 500 users and an externally-hosted Exchange environment that has 500 users. The hosted Exchange environment does not allow Outlook Anywhere connectivity. You do not have administrative access to all mailboxes in the hosted environment. You plan to migrate and consolidate both environments into Office 365.  You have the following migration requirements:  • Migrate on-premises mailboxes in batches by department. • Migrate email, calendar, and contact items from the on-premises environment. • Migrate only email from the hosted environment. In the table below, identify the migration type that must be used for each environment. Make only one selection in each column. Each correct selection is worth one point.

 

Answer:

Question: 5

You are the Office 365 administrator for your company's Microsoft Exchange Online environment. The company recently subscribed to the Office 365 Enterprise El plan. The company wants to filter email messages based on the following criteria:  • Reverse DNS lookup • Sender open proxy test • HELO/EHLO analysis • Analysis of spam confidence level (SCL) ratings on email messages from a specific sender You need to filter all email messages. How should you complete the relevant Windows PowerShell script? To answer, select the appropriate command segment from each list in the answer area.

 

Answer:

Question: 6

Your company is planning to migrate to Microsoft Exchange Online. The company employs 5,000 people, each with a mailbox currently located on Exchange Server 2000. The company has the following migration requirements: • Move mailboxes in batches. • Do not migrate calendar or contact items. • Provide migration status reports to administrators. You need to select the appropriate migration strategy.  Which migration strategy should you use? 

A. Staged migration

B. Cutover migration

C. IMAP migration

D. Hybrid migration 

Answer: C

70-346 Certification Test

Microsoft

70-346

Managing Office 365 Identities and Requirements

Question: 1

A company migrates to Office 365. 2,000 active users have valid Office 365 licenses assigned. An additional 5,000 user accounts were created during the migration and testing processes. These users do not have any licenses assigned. You need to remove the Office 365 user accounts that do not have any licenses assigned by using the least amount of administrative effort. Which Windows PowerShell command should you run? 

A. Get-MsolUser -All -EnabledFilter "DisabledOnly" | Remove-MsolUser -Force

B. Get-MsolUser-EnabledFilter "DisabledOnly" | Remove-MsolUser -Force

C. Get-MsolUser -All -UnlicensedUsersOnly | Remove-MsolUser -Force

D. Get-MsolUser -UnlicensedUsersOnly | Remove-MsolUser –Force 

Answer: A

Question: 2

Litware Inc. has an Office 365 Enterprise El plan. Employees have access to all Office 365 services. Employees in the human resources (HR) department must continue to use the on-premises SharePoint 2013 deployment due to legal requirements. You need to disable access to SharePoint Online for all HR department employees. How should you complete the relevant Windows PowerShell commands? To answer, drag the appropriate Windows PowerShell segment to the correct location or locations in the answer area. Each Windows PowerShell segment 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.

 

Answer:

Question: 3

A company deploys an Office 365 tenant. You prepare to use the bulk add tool to add users to Office 365.  You need to prepare a file to use with the bulk add tool. Which fields must you include in the file? To answer, drag the appropriate response to each field. Each response 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.

 

Answer:

Question: 4

A company has 50 employees that use Office 365. You need to enforce password complexity requirements for all accounts. How should you complete the relevant Windows PowerShell command? To answer, drag the appropriate Windows PowerShell segment to the correct location or locations. Each Windows PowerShell segment 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.

 

Answer:

Question: 5

You are the Office 365 administrator for your company. Your company uses Office 365 for collaboration. You must reset the password for all of the employees in your company. You need to ensure that all employees create a new password the next time they sign in to Office 365. How should you complete the relevant Windows PowerShell command? To answer, drag the appropriate Windows PowerShell segment to the correct location or locations. Each Windows PowerShell segment 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.

Answer:

Question: 6

You are the Office 365 administrator for your company. You must use Windows PowerShell to manage cloud identities in Office 365. You must use a computer that runs Windows 8 to perform the management tasks. You need to ensure that the Windows 8 computer has the necessary software installed.  What should you install first? 

A. Microsoft Office 365 Best Practices Analyzer for Windows PowerShell

B. Windows PowerShell 4.0

C. Remote Server Administration Tools for Windows

D. Microsoft Online Services Sign-in Assistant 

Answer: A

70-489 Exam Course

Microsoft

70-489

Developing Microsoft SharePoint Server 2013 Advanced Solutions

Question: 1

You connect to a front-end web server in a SharePoint farm for a company named Contoso, Ltd. You start the SharePoint Management Shell by using an account that has administrator permissions for the user-profile store. You use Windows PowerShell to create a User Profile property. You add the profile type and sub type to the User Profile property. You run the following Windows PowerShell cmdlets: 

 

How should you complete the relevant Windows PowerShell cmdlets? (To answer, drag the appropriate code segment to the correct location or locations in the answer area. Each code segment 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.)

 

Answer:

Question: 2

You use Visual Studio to design a SharePoint solution for a company that sells wine to customers around the world. The solution must return the total number of cases sold per country. The solution also must allow employees to sort cases of wine that are returned. Employees must sort cases by country, date, and reason for the return. You need to configure the solution to meet the requirements. Which steps should you take? (Each correct answer presents part of the solution. Choose all that apply.)

A. Add a Refinement Web Part to the page.

B. Configure the query for the Content Search Web Part.

C. Add country as a property filter to the Search Results Web Part.

D. Add a Calendar Web Part to the page.

Answer: CD

Question: 3

You develop a SharePoint app by using the client-side object model (CSOM.) On each page of the app, you need to display the user profile picture for the user that is currently logged in. How should you complete the relevant code? (To answer, select the appropriate option from each drop-down list in the answer area.)

 

Answer:

Question: 4

You develop a SharePoint-hosted app. The app includes the following code segment: (Line numbers are included for reference only.)

 

The app must display user profile data for the user that is logged in. The user profile data must include the PreferredName, Department, and WorkPhone properties. You need to ensure that the app displays the required user profile data. Which code segment should you insert at line 12?

A. var a = new SP.UserProfiles.UserProfile();

B. var a = new SP.UserProfiles.SocialFollowingManager (context);

C. var a = SP.UserProfiles.Profileloader.GetProfileLoader(context);

D. var a = new SP.UserProfiles.PeopleManager(context);

Answer: D

Question: 5

You develop a SharePoint app that includes microblog posts and conversations for a company named Contoso, Ltd. You must use various programming object models to determine the number of unread mentions in microblog posts for the current user. You need to call methods for different programming object models. How should you create the method calls? (To answer, drag the appropriate code segments to the correct location or locations in the answer area. Each code segment 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.)

 

Answer:

Question: 6

You create term sets and multi-lingual labels for a site collection. The default locale, language, and culture for the term sets are set to English. You develop a console application to create labels for a term named Memory. The console application uses the English locale. You develop the following labels for the term named Memory.

 

You need to create German labels for the term named Memory. How should you complete the relevant code? (To answer, select the appropriate code segment from each drop-down list in the answer area.)

 

Answer:

Question: 7

A company uses SharePoint to manage a large number of documents. The Document ID Service feature is enabled. You need to create a custom class that generates a unique ID for each document. How should you complete the class definition? (To answer, select the appropriate code segment from each drop-down list in the answer area.).

 

Answer:

Question: 8

You implement eDiscovery in SharePoint to access Exchange Online mailbox data. You need to ensure that users continue to have access to Exchange Online mailbox data after an In-Place Hold is applied. On the Exchange admin center page, which option should you select? (To answer, select the appropriate option in the answer area.)

 

Answer:

Question: 9

You use Visual Studio to design a SharePoint solution for a company that provides computer support services to customers around the world. The solution must list the customer service representatives that resolve the highest number of support requests. The solution also must allow filtering of customer service representatives by region. You need to configure the solution to meet the requirements. Which steps should you take? (Each correct answer presents part of the solution. Choose all that apply.)

A. Add a Recommended Items Web Part to the page.

B. Add and configure a Refinement Web Part to the page.

C. Add regions as property filters to the Search Results Web Part.

D. Configure the query for the Content Search Web Part.

Answer: CD

Question: 10

You develop a SharePoint app that uses the client-side object model (CSOM) to retrieve items from the search index. You need to implement the client-side query code. Which four code segments should you use in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Answer:

1Z0-497 Exam Questions

Oracle

1Z0-497

Oracle Database 12c Essentials

Question: 1

Which statement about CDB architecture is true? 

A. Oracle-supplied metadata resides only in the root container.

B. A seed PDB can sometimes be opened for particular operations.

C. Multiple PDBs with the same name can reside in the same CDB.

D. A CDB can have an infinite number of PDBs.

E. You can create common users in PDBs. 

Answer: A

Explanation: Reference:  http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89235 

Question: 2

As part of your Oracle Database 12c post-installation tasks, you run these commands: Cd $ORACLE_HOME/bin srvctl stop database -d myDb chopt enable dm srvctl start database -d myDb What does this do? 

A. It enables the Oracle Data Mining option in your Oracle binary files.

B. It creates the Fast Recovery Area disk group.

C. It generates Client Static Library.

D. It configures one of the Oracle user accounts.

E. It configures Oracle Net Services.

F. It configures Oracle Messaging Gateway. 

Answer: A

Explanation: Reference:  http://docs.oracle.com/cd/E16655_01/install.121/e17889/postinst.htm#RILIN1049 (see 4.4) 

Question: 3

Exhibit below:

 Which three statements are true about terminating a session? 

A. Without any error, you can terminate the active session by executing: SQL> ALTER SYSTEM KILL SESSIOU '7, 15';

B. You can terminate the active session by executing: SQL> ALTER SYSTEM KILL SESSIOM "7, 15'; But you also get the error message: ORA-00028: your session has been killed

C. You cannot terminate the active session. You have to wait until that session becomes inactive.

D. Without any error, you can terminate the inactive session by executing: SQL> ALTER SYSTEM KILL SESSION '12, 63';

E. When an inactive session is killed, the status of that session remains visible in VSSESSION with status KILLED. The rowf the terminated session is removed from VSSESSION after the user attempts to use the session again.

F. You cannot terminate the inactive session. You have to wait until that session becomes active again. 

Answer: D,E,F

 Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc008.htm#ADMIN11192 

Question: 4

Which two statements are true about shared server sessions? 

A. No Program Global Area (PGA) is allocated for shared server processes.

B. User Global Area is stored in System Global Area (SGA).

C. Shared SQL Area is allocated from Program Global Area (PGA).

D. Private SQL Area is allocated from Library Cache.

E. Large Pool is used for SQL work areas. 

Answer: D

Explanation: Reference:  http://docs.oracle.com/cd/B19306_01/server.102/b14220/memory.htm (see library cache) 

Question: 5

Which targets can be managed by using Enterprise Manager Cloud Control? 

A. Hosts and databases

B. Hosts, databases, and application servers

C. Application servers and web applications

D. Databases, Oracle Management Server (OMS), and Oracle Management Repository (OMR)

E. Databases, application servers, and web applications

F. Hosts, databases, application servers, web applications, OMS, and OMR 

Answer: A

Explanation: Reference:  http://www.oracle.com/technetwork/oem/framework-infra/wp-em12c-security-bestpracticesv2-1493383.pdf (page 3, second bulleted point, last couple of sentences) 

Question: 6

Which two statements are true regarding SQL*Plus? 

A. It has commands for performing database administration operations.

B. It can be used in interactive but not batch mode for SQL commands.

C. It has to be installed separately after the Oracle Database 12c installation.

D. Operating system commands can be executed from the SQL*Plus command prompt. 

Answer: A

Explanation: Reference:  http://docs.oracle.com/cd/B14117_01/server.101/b12170/qstart.htm 

Question: 7

Which two statements about the Process Monitor (PMON) process are true? 

A. PMON performs process recovery when a client process fails.

B. During instance startup, PMON takes care of instance recovery.

C. PMON performs listener registration.

D. PMON restarts background and dispatcher processes when they fail.

E. PMON resolves failures of distributed transactions. 

Answer: A,C

Question: 8

Which statement is true about loading data by using the conventional path of SQL*Loader? 

A. Redo is not generated while performing conventional path loads.

B. Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,

C. No exclusive locks are acquired when the conventional path loads are performed.

D. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.

E. INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load. 

Answer: B

Explanation: Reference:  http://docs.oracle.com/cd/A57673_01/DOC/server/doc/SUT73/ch8.htm#data%20paths(see direct loads, integrity constraints, and triggers) 

Question: 9

Identify three key properties of a transaction in Oracle Database 12c. 

A. durability

B. consistency

C. concurrency

D. isolation

E. scalability

F. manageability 

Answer: A,B,D

Explanation: Reference:  http://docs.oracle.com/cd/E16655_01/server.121/e17633/transact.htm#CNCPT016 

Question: 10

Which type of file system is NOT valid for storing data files, online redo log files, and control files for a pluggable database? 

A. Automatic Storage Management (ASM)

B. OS file system

C. logical volume (LVM)

D. clustered file system

E. RAW 

Answer: E

Question: 11

Which two statements about ADDM are true? 

A. Real-Time ADDM uses AWR snapshots of the last 10 minutes.

B. Real-Time ADDM uses ASH recent activity from SGA data.

C. Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.

D. Regular ADDM uses AWR snapshots that are not yet purged. 

Answer: C

Question: 12

Which two items are key for maintaining data consistency in Oracle Database 12c? 

A. undo data

B. isolation level

C. lock mechanism

D. serializability 

Answer: C

Explanation: Reference:  http://docs.oracle.com/cd/E11882_01/server.112/e25789/consist.htm#CNCPT88969(overview of the oracle database locking mechanism)