Monthly Archives: August 2020

Microsoft

DA-100 Analyzing Data with Microsoft Power BI Exam

Data Analysts enable businesses to maximize the value of their data assets by using Microsoft Power BI. As a subject matter expert, Data Analysts are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations. Data Analysts also collaborate with key stakeholders across verticals to deliver relevant insights based on identified business requirements.

The Data Analyst should have a fundamental understanding of data repositories and data processing both on-premises and in the cloud.
Part of the requirements for: Microsoft Certified: Data Analyst Associate
Related exams: none

Skills measured
The content of this exam will be updated on September 24, 2020. Please download the exam skills outline below to see what will be changing.
Prepare the data (20-25%)
Model the data (25-30%)
Visualize the data (20-25%)
Analyze the data (10-15%)
Deploy and maintain deliverables (10-15%)

Exam DA-100: Analyzing Data with Microsoft Power BI – Skills Measured
This exam will be updated on September 24, 2020. Following the current exam guide, we have included a version of the exam guide with Track Changes set to “On,” showing the changes that will be made to the exam on that date.

Audience Profile
Data Analysts enable businesses to maximize the value of their data assets by using Microsoft Power BI. As a subject matter expert, data analysts are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations. Data analysts also collaborate with key stakeholders across verticals to deliver relevant insights based on identified business requirements.

The Data Analyst should have a fundamental understanding of data repositories and data processing both on-premises and in the cloud.

Skills Measured
NOTE: The bullets that appear below each of the skills measured are intended to illustrate how we are assessing that skill. This list is not definitive or exhaustive.
NOTE: In most cases, exams do NOT cover preview features, and some features will only be added to an exam when they are GA (General Availability).

Prepare the Data (20-25%)
Get data from different data sources
. identify and connect to a data source
. change data source settings
. select a shared dataset or create a local dataset
. select a storage mode
. choose an appropriate query type
. identify query performance issues
. use the Common Data Service (CDS)
. use parameters

Profile the data
. identify data anomalies
. examine data structures
. interrogate column properties
. interrogate data statistics

Clean, transform, and load the data
. resolve inconsistencies, unexpected or null values, and data quality issues
. apply user-friendly value replacements
. identify and create appropriate keys for joins
. evaluate and transform column data types
. apply data shape transformations to table structures
. combine queries
. apply user-friendly naming conventions to columns and queries
. leverage Advanced Editor to modify Power Query M code
. configure data loading
. resolve data import errors

Model the Data (25-30%)
Design a data model
. define the tables
. configure table and column properties
. define quick measures
. flatten out a parent-child hierarchy
. define role-playing dimensions
. define a relationship’s cardinality and cross-filter direction
. design the data model to meet performance requirements
. resolve many-to-many relationships
. create a common date table
. define the appropriate level of data granularity

Develop a data model
. apply cross-filter direction and security filtering
. create calculated tables
. create hierarchies
. create calculated columns
. implement row-level security roles
. set up the Q&A feature

Create measures by using DAX
. use DAX to build complex measures
. use CALCULATE to manipulate filters
. implement Time Intelligence using DAX
. replace numeric columns with measures
. use basic statistical functions to enhance data
. create semi-additive measures

Optimize model performance
. remove unnecessary rows and columns
. identify poorly performing measures, relationships, and visuals
. improve cardinality levels by changing data types
. improve cardinality levels through summarization
. create and manage aggregations

Visualize the Data (20-25%)
Create reports
. add visualization items to reports
. choose an appropriate visualization type
. format and configure visualizations
. import a custom visual
. configure conditional formatting
. apply slicing and filtering
. add an R or Python visual
. configure the report page
. design and configure for accessibility

Create dashboards
. set mobile view
. manage tiles on a dashboard
. configure data alerts
. use the Q&A feature
. add a dashboard theme
. pin a live report page to a dashboard
. configure data classification

Enrich reports for usability
. configure bookmarks
. create custom tooltips
. edit and configure interactions between visuals
. configure navigation for a report
. apply sorting
. configure Sync Slicers
. use the selection pane
. use drillthrough and cross filter
. drilldown into data using interactive visuals
. export report data

Analyze the Data (10-15%)
Enhance reports to expose insights
. apply conditional formatting
. apply slicers and filters
. perform top N analysis
. explore statistical summary
. use the Q&A visual
. add a Quick Insights result to a report
. create reference lines by using Analytics pane
. use the Play Axis feature of a visualization

Perform advanced analysis
. identify outliers
. conduct Time Series analysis
. use groupings and binnings
. use the Key Influencers to explore dimensional variances
. use the decomposition tree visual to break down a measure
. apply AI Insights

Deploy and Maintain Deliverables (10-15%)
Manage datasets
. configure a dataset scheduled refresh
. configure row-level security group membership
. providing access to datasets
. configure incremental refresh settings
. endorse a dataset

Create and manage workspaces
. create and configure a workspace
. recommend a development lifecycle strategy
. assign workspace roles
. configure and update a workspace app
. publish, import, or update assets in a workspace
. apply sensitivity labels to workspace content

Actualkey Microsoft Certified DA-100 exam pdf, Certkingdom Microsoft Certified DA-100 PDF

MCTS Training, MCITP Trainnig

Best Microsoft Certified DA-100 Certification, Microsoft Certified DA-100 Training at certkingdom.com

Uncategorized

MO-300 Microsoft PowerPoint (PowerPoint and PowerPoint 2019)

Exam MO-300: Microsoft PowerPoint (PowerPoint and PowerPoint 2019)
Languages: English, English (Malaysia), German, Spanish, Indonesian (Indonesia), Korean, Dutch, Italian, Russian, French, Portuguese (Brazil), Polish, Greek (Greece), Chinese (Simplified)
Retirement date: none

This exam measures competency to create, edit, and enhance presentations and slideshows, including the ability to create and manage presentations, insert and format shapes and slides, create slide content, apply transitions and animations, and manage multiple presentations. Presentation examples include professional-grade sales presentations, employee training, instructional materials, and kiosk slideshows.

Skills measured
Manage presentations
Manage slides
Insert and format text, shapes, and images
Insert tables, charts, smartArt, 3D models, and media
Apply transitions and animations

MO-300: Microsoft PowerPoint (PowerPoint and PowerPoint 2019) – Skills Measured
NOTE: The bullets that appear below each of the skills measured are intended to illustrate how we are assessing that skill. This list is not definitive or exhaustive.
NOTE: In most cases, exams do NOT cover preview features, and some features will only be added to an exam when they are GA (General Availability).
Manage presentations
Modify slide masters, handout masters, and note masters
. change the slide master theme or background
. modify slide master content
. create slide layouts
. modify slide layouts
. modify the handout master
. modify the notes master

Change presentation options and views
. change slide size
. display presentations in different views
. set basic file properties

Configure print settings for presentations
. print all or part of a presentation
. print notes pages
. print handouts
. print in color, grayscale, or black and white

Configure and present slide shows
. create custom slide shows
. configure slide show options
. rehearse slide show timing
. set up slide show recording options
. present slide shows by using Presenter View

Prepare presentations for collaboration
. mark presentations as final
. protect presentations by using passwords
. inspect presentations for issues
. add and manage comments
. preserve presentation content
. export presentations to other formats

Manage slides
Insert slides
. import Word document outlines
. insert slides from another presentation
. insert slides and select slide layouts
. insert Summary Zoom slides
. duplicate slides

Modify slides
. hide and unhide slides
. modify individual slide backgrounds
. insert slide headers, footers, and page numbers

Order and group slides
. create sections
. modify slide order
. rename sections

Insert and format text, shapes, and images Format text
. apply formatting and styles to text
. format text in multiple columns
. create bulleted and numbered lists

Insert links
. insert hyperlinks
. insert Section Zoom links and Slide Zoom links

Insert and format images
. resize and crop images
. apply built-in styles and effects to images
. insert screenshots and screen clippings

Insert and format graphic elements
. insert and change shapes
. draw by using digital ink
. add text to shapes and text boxes
. resize shapes and text boxes
. format shapes and text boxes
. apply built-in styles to shapes and text boxes
. add alt text to graphic elements for accessibility

Order and group objects on slides
. order shapes, images, and text boxes
. align shapes, images, and text boxes
. group shapes and images
. display alignment tools

Insert tables, charts, smartArt, 3D models, and media Insert and format tables
. create and insert tables
. insert and delete table rows and columns
. apply built-in table styles

Insert and modify charts
. create and insert charts
. modify charts

Insert and format SmartArt graphics
. insert SmartArt graphics
. convert lists to SmartArt graphics
. add and modify SmartArt graphic content

Insert and modify 3D models
. insert 3D models
. modify 3D models

Insert and manage media
. insert audio and video clips
. create and insert screen recordings
. configure media playback options

Apply transitions and animations Apply and configure slide transitions
. apply basic and 3D slide transitions
. configure transition effects

Animate slide content
. animate text and graphic elements
. animate 3D models
. configure animation effects
. configure animation paths
. reorder animations on a slide

Set timing for transitions
. set transition effect duration
. configure transition start and finish options

Actualkey Microsoft MO-300 exam pdf, Certkingdom Microsoft MO-300 PDF

MCTS Training, MCITP Trainnig

Best Microsoft MO-300 Certification, Microsoft MO-300 Training at certkingdom.com

Microsoft Certified: Power Platform App Maker Associate

PL-100 Microsoft Power Platform App Maker (beta)

The app maker builds solutions to simplify, automate, and transform tasks and processes for themselves and their team where they have deep expertise in the solution domain. They are skilled in key technical business analyst tasks such as data modeling, basic UX design, requirements analysis, process analysis, etc.

The app maker creates and enforces business processes, structures digital collection of information, improves efficiency of repeatable tasks, and automates business processes.

The app maker uses the maker tools of Power Platform to solve business problems. They may have experience with Visual Basic for Applications, Excel pivot tables, Teams, and other tools. They should have a basic understanding of data models, user interface, and processes. The app maker is aware of the capabilities and limitations of available tools and understands how to apply them.

The app maker is self-directed, and solution focused. They may not have formal IT training but are comfortable using technology to solve business problems with a personal growth mindset. They understand the operational need and have a vision of the desired outcome. They approach problems with phased and iterative strategies.

Beta exams are not scored immediately because we are gathering data on the quality of the questions and the exam. Learn more about the value and importance of beta exams.

Skills measured
Design solutions (10-15%)
Create solutions (55-60%)
Analyze and visualize data (5-10%)
Implement and manage solutions (15-20%)

Audience Profile The App Maker builds solutions to simplify, automate, and transform tasks and processes for themselves and their team where they have deep expertise in the solution business domain. They have basic data modeling, user experience design, requirements analysis, and process analysis skills. The App Maker creates and enforces business processes, structures digital collection of information, improves efficiency of repeatable tasks, and automates business processes. The App Maker uses the Maker tools of Power Platform to solve business problems. They may use advanced features of Microsoft apps and third-party productivity tools. The App Maker is aware of the capabilities and limitations of available tools and understands how to apply them. The App Maker is self-directed, and solution focused. They may not have formal IT training but are comfortable using technology to solve business problems with a personal growth mindset. They understand the operational need and have a vision of the desired outcome. They approach problems with phased and iterative strategies.

Skills Measured NOTE: The bullets that appear below each of the skills measured are intended to illustrate how we are assessing that skill. This list is not definitive or exhaustive.

NOTE: In most cases, exams do NOT cover preview features, and some features will only be added to an exam when they are GA (General Availability). Design solutions (10-15%)

Create a high-level design
 collect business requirements
 identify data sources
 describe real-world objects as entities
 describe the user experience
 create a high-level data model

Identify required Power Platform components
 determine required Power Apps
 identify existing resources and licenses
 identify gaps between existing functionality and requirements
 map problem domain to Power Platform tools
 identify required business processes
 evaluate accelerators, Microsoft apps and services, and third-party solutions
 describe connectors including standard, premium, and custom connectors

Design data models
 determine required entities
 identify relationships
 identify fields and data types
 determine requirements for offline access

Design User Interface
 identify opportunities for component reuse
 apply user interface (UI) standards
 design for accessibility
 design for localization

Design output
 define data output requirements
 define requirements for visualizations
 identify repositories for analytical data

Design security, privacy, and compliance
 identify data that must be protected or requires special handling
 identify tools that help ensure compliance with applicable government regulations

Understand Power Platform environments
 understand how to get started building apps
 describe the different types of environments
 describe Common Data Service solutions
 describe other environment creation options

Create solutions (55-60%)

Manage Power Platform development environments
 create a solution
 add existing apps and flows to a solution
 run Solution Checker and interpret results

Create model-driven apps
 create model-driven apps
 create a site map
 create and configure Common Data Service entity forms
 create and configure Common Data Service entity views
 embed model-driven app records in Microsoft Teams channels

Create canvas apps
 create canvas apps within a solution
 connect to data sources in canvas apps
 build canvas apps screens
 configure apps for offline access
 use formulas
 use collections and variables
 describe the implications of design choices on app performance
 interpret App Checker results

Create and Use Controls
 add canvas app assets and components to screens
 build canvas app components

Create and configure data stores
 create a Common Data Service database
 configure a connection
 create Common Data Service entities based on a data model
 link entities by using Common Data Service entity relationships
 load or create data records for testing and development

Create business logic
 create Common Data Service business rules
 create Common Data Service business process flows
 create Common Data Service classic workflows
 create business logic using Power Automate flows
 create Canvas app formulas and events

Create Power Automate flows
 create flows in a solution
 configure triggers
 build scheduled, automated, and instant flows
 configure flow steps
 interpret Flow Checker results
 test a flow
 implement common expressions and loops
 create adaptive cards for Microsoft Teams

Analyze and visualize data (5-10%)

Create Power BI reports
 create Power BI report by using Power BI Desktop
 create Power BI report by using Power BI service

Implement other reports
 merge data from a data source into a Microsoft Word or Excel template
 create model-driven dashboards
 create model-driven charts
 add existing Power BI tile or dashboard to a model-driven dashboard

Describe AI Builder models
 identify model types including prebuilt and custom models
 describe the process for preparing data and training models
 use a model from within Power Automate or Power Apps

Implement and manage solutions (15-20%)

Configure Common Data Service security
 configure security roles
 configure field security

Test apps and flows
 describe the testing process
 implement Power Platform testing tools
 validate accessibility

Secure a solution
 manage data security
 manage app security
 share flows
 share Power BI reports

Deploy the solution
 export solutions
 move individual apps and flows between environments
 support deployment of solutions to testing and production environments

Manage versions of canvas apps
 create new versions of an app
 restore a previous version of an app
 publish a new version of an app

Actualkey Microsoft Certified PL-100 exam pdf, Certkingdom Microsoft Certified PL-100 PDF

MCTS Training, MCITP Trainnig

Best Microsoft Certified PL-100 Certification, Microsoft Certified PL-100 Training at certkingdom.com

Tech

250-447 Administration of Symantec Client Management Suite 8.5

Administration of Symantec Client Management Suite 8.5
The certified candidate will demonstrate an understanding of the planning, designing, deploying and optimization of the Symantec Client Management Suite. This understanding serves as a basis of technical knowledge and competency for the Symantec Client Management Suite 8.5 solution in an enterprise environment.

To achieve this level of certification, candidates must pass the technical exam and accept the Symantec Certification Agreement.

Exam Details:
# of Questions: 65-75
Exam Duration: 90 minutes
Passing Score: 70%
Languages: English
Exam Price: $250 (or your country’s currency equivalent)

Suggested Preparation:

Exam Study Guide
Recommended 3 months regular experience working with Symantec ITMS or CMS, SMS or AMS solutions and products with at least the ability to complete the following:
Create a high-level design of a basic Client Management Suite 8.5 implementation
Install the Client Management Suite 8.5 components, updates and perform post installation tasks
Import and discover endpoint resources
Create/Apply/Manage Filters, Targets & Organizational Views/Groups
Inventory managed computers
Configure the Software Catalog, Portal and Library
Deploy software packages
Download, stage, and deploy software updates
View and use reports to assist with managing computers
Create, configure, and deploy images to managed computers

Recommended Courses:
Instructor-led Training:
Client Management Suite 8.1 or 8.5 Administration
Current Class Schedule
eLearning:
IT Management Suite Fundamentals
Available in the Symantec LearnCentral eLibrary
Optional Instructor-led Courses:
IT Management Suite 8.1 Administration
Current Class Schedule
ITMS 8.1 Diagnostics and Troubleshooting
Current Class Schedule
Asset Management Suite 8.1 or 8.5 Administration
Current Class Schedule

Additional online training is available 24/7 in the Symantec eLibrary.
Note: If you do not have prior experience with this product, it is recommended that you complete an in-person, classroom training or Virtual Academy virtual classroom training class in preparation for the SCS exam. If you have experience with this product, you may find an online course equivalent to be sufficient. Be cautioned that attendance in a training course does not guarantee passage of a certification exam.

Actualkey Symantec 250-447 exam pdf, Certkingdom Symantec 250-447 PDF

MCTS Training, MCITP Trainnig

Best Symantec 250-447 Certification, Symantec 250-447 Training at certkingdom.com

IBM, Tech

P9510-779 IBM PureApplication Technical Sales Mastery Test V2

Number of questions: 30
Number of questions to pass: 23
Time allowed: 60 mins.
Status: Live

This proctored technical mastery test covers the technical knowledge required for the purpose of identifying, managing and closing sales opportunities.

The test is applicable to sales representatives who demonstrate sales and technical knowledge of the software and targets the technical sales professional who can deliver a comprehensive business solution to customers through solution identification, product differentiation, and competitive positioning.

Passing this test counts towards PartnerWorld competency requirements and helps you attain higher membership levels. This test also entitles you to use the mastery qualification title on your business card.

Skill name: IBM PureApplication Technical Sales Professional V2

PartnerWorld skill code:32003008

To register for a test and to locate the test center nearest you, go to Pearson Vue/IBM.

System architecture 67%
Hardware Characteristics
Networking
Cloud Configuration and Security

Workload Patterns 23%
Virtual Systems
Plugin Development Kit

Administration 10%
Management
Maintenance

Actualkey IBM P9510-779 exam pdf, Certkingdom IBM P9510-779 PDF

MCTS Training, MCITP Trainnig

Best IBM P9510-779 Certification, IBM P9510-779 Training at certkingdom.com

IBM, Tech

C1000-103 IBM Cloud Pak for Multicloud Management v1.3 Solution Architect

An IBM Certified Solution Architect – IBM Cloud Pak for Multicloud Management v1.3 is a person who can design, plan and create an architecture with IBM Cloud Pak for Multicloud Management. They can do this with limited assistance from support, documentation or relevant subject matter experts.


This exam consists of the six sections described below. For more detail, please see the study guide on the Exam Preparation tab.

Cloud Pak for Multicloud Management Overview 13%
Describe the benefits and capabilities of IBM Cloud Paks
Understand the benefits and capabilities of the Cloud Pak for Multicloud Management
Articulate the Cloud Pak for Management modules and business benefits

Platform 23%
Understand supported OpenShift Container Platforms and Architecture
Understand the OpenShift HA, DR, Backup and Storage
Articulate the Cloud Pak for Multicloud Management high level architecture
Understand the supported public and private clouds
Understand the Cloud Pak for Multicloud Management add-ons

Management 19%
Articulate how to manage Kubernetes/OpenShift cluster lifecycle
Articulate how to manage policy lifecycle
Articulate how to manage application lifecycle
Articulate how to manage Identity and Access Management of the Cloud Pak
Articulate the different elements of topology diagram

Monitoring 15%
Explain Kubernetes/OpenShift cluster monitoring
Explain the basic concepts of the IBM Cloud Pak for Multicloud Management Monitoring Module
Describe the different event sources and destinations
Describe events, incidents, event polices and incident polices
Describe data retention and summarization capabilities
Describe the different approaches to backing up and restoring monitoring
Describe how to scale the monitoring capabilities in Cloud Pak for Multicloud Management
Describe how to view monitoring results

Automation 13%
Explain different options for infrastructure automation in CP4MCM
Describe how to use the Terraform and service automation module in Cloud Pak for Multicloud Management
Describe how to use automation in Cloud Pak for Multicloud Management
Explain how to achieve automation in Cloud Pak for Multicloud Management

Governance 17%
Understand the governance, risk and compliance requirements
Articulate and design the configuration policy
Articulate and design the mutation and vulnerability policies
Articulate and design the certificate and secret encryption policies
Articulate and design the audit, Identity and Access Management (IAM), and Center for Internet Security (CIS) policies
Articulate and design the placement policies
Describe the management of policies and security findings
 

Actualkey IBM C1000-103 exam pdf, Certkingdom IBM C1000-103 PDF

MCTS Training, MCITP Trainnig

Best IBM C1000-103 Certification, IBM C1000-103 Training at certkingdom.com

IBM, Tech, Uncategorized

C1000-099 IBM Cloud Pak for Applications v4.1 Developer

Number of questions: 60
Number of questions to pass: 42
Time allowed: 90 mins
Status: Live

An IBM Certified Application Developer is a technical professional that understands the concepts essential to modernizing existing applications and developing and deploying new cloud native applications using IBM Cloud Pak for Applications. They have experience configuring products and developing complex high business value solutions using containerized products. This individual is able to perform these tasks with little to no assistance from product documentation, support or peers.

This exam consists of 7 sections described below. For more detail, please see the study guide on the Exam Preparation tab.

Design and develop a Cloud Native solution 18%
Understand the main elements of a cloud native solution
Explain Containers and Container Orchestration
Explain Continuous Integration/Continuous Delivery and DevOps concepts
Design a Microservices application

OpenShift Container Platform Architecture 10%
Understand the OpenShift Container Platform Architecture
Develop and deploy applications on OpenShift 4.x
Utilize Developer Tools in OpenShift 4.x

Cloud Pak for Applications Overview 7%
Understand the Cloud Pak for Applications value proposition
Explain IBM Cloud Pak for Applications components and their value proposition

Develop and deploy new applications 18%
Develop and deploy serverless applications
Understand the capabilities of runtimes
Deploy a new application on OpenShift
Manage applications with Application Navigator

Develop and deploy new applications with Accelerators for Teams 13%
Utilize the available developer tools
Utilize application stacks
Set up a local development environment
Develop on CodeReady
Develop using Codewind as an Integrated Development Environment

Modernize Applications 20%
Describe Application Modernization concepts
Understand the available Application Modernization tools
Evaluate a traditional application using Transformation Advisor
Replatform: Migrate a traditional application to OpenShift
Repackage: Containerize an application to run on OpenShift

Continuous Integration/Continuous Deployment (CI/CD) and the DevOps lifecycle 14%
Understand, utilize and customize OpenShift Pipelines tooling and evolution
Develop pipelines using OpenShift Pipelines
Develop pipelines using Jenkins
Understand and use container registries in OpenShift
Describe at a high level the content and capabilities provided in Cloud DevOps for IBM Cloud Pak for Applications

Related Certification
IBM Certified Developer – Cloud Pak for Applications v4.1
IBM Cloud : Management and Platform
PartnerWorld Code: C0007300

Related Certifications
IBM Certified Developer – Cloud Pak for Applications v4.1

The Sample Exam contains a subset of questions similar to those found on the actual exam

Open Sample Exam PDF
Available Languages English

 

Actualkey IBM C1000-099 exam pdf, Certkingdom IBM C1000-099 PDF

MCTS Training, MCITP Trainnig

Best IBM C1000-099 Certification, IBM C1000-099 Training at certkingdom.com

Microsoft Azure, Uncategorized

DP-900 Microsoft Azure Data Fundamentals Exam

Candidates for this exam should have foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services.

This exam is intended for candidates beginning to work with data in the cloud.
Candidates should be familiar with the concepts of relational and non-relational data, and different types of data workloads such as transactional or analytical.

Azure Data Fundamentals can be used to prepare for other Azure role-based certifications like Azure Database Administrator Associate or Azure Data Engineer Associate, but it’s not a prerequisite for any of them.

Part of the requirements for: Microsoft Certified: Azure Data Fundamentals

Skills measured
Describe core data concepts (15-20%)
Describe how to work with relational data on Azure (25-30%)
Describe how to work with non-relational data on Azure (25-30%)
Describe an analytics workload on Azure (25-30%)

Audience Profile
Candidates for this exam should have foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services.
This exam is intended for candidates beginning to work with data in the cloud.

Candidates should be familiar with the concepts of relational and non-relational data, and different types of data workloads such as transactional or analytical.
Azure Data Fundamentals can be used to prepare for other Azure role-based certifications like Azure Database Administrator Associate or Azure Data Engineer Associate, but it is not a prerequisite for any of them.

Skills Measured
NOTE: The bullets that appear below each of the skills measured are intended to illustrate how we are assessing that skill. This list is not definitive or exhaustive.
NOTE: In most cases, exams do NOT cover preview features, and some features will only be added to an exam when they are GA (General Availability).

Describe core data concepts (15-20%)
Describe types of core data workloads
. describe batch data
. describe streaming data
. describe the difference between batch and streaming data
. describe the characteristics of relational data

Describe data analytics core concepts
. describe data visualization (e.g., visualization, reporting, business intelligence
. describe basic chart types such as bar charts and pie charts
. describe analytics techniques (e.g., descriptive, diagnostic, predictive, prescriptive, cognitive)
. describe ELT and ETL processing
. describe the concepts of data processing

Describe how to work with relational data on Azure (25-30%)
Describe relational data workloads
. identify the right data offering for a relational workload
. describe relational data structures (e.g., tables, index, views)

Describe relational Azure data services
. describe and compare PaaS, IaaS, and SaaS delivery models
. describe Azure SQL Database
. describe Azure Synapse Analytics
. describe SQL Server on Azure Virtual Machine
. describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQL
. describe Azure SQL Managed Instance

Identify basic management tasks for relational data
. describe provisioning and deployment of relational data services
. describe method for deployment including ARM templates and Azure Portal
. identify data security components (e.g., firewall, authentication)
. identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)
. identify query tools (e.g., Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.)

Describe query techniques for data using SQL language
. compare DDL versus DML
. query relational data in PostgreSQL, MySQL, and Azure SQL Database

Describe how to work with non-relational data on Azure (25-30%)
Describe non-relational data workloads
. describe the characteristics of non-relational data
. describe the types of non-relational and NoSQL data
. recommend the correct data store
. determine when to use non-relational data

Describe non-relational data offerings on Azure
. identify Azure data services for non-relational workloads
. describe Azure Cosmos DB APIs
. describe Azure Table storage
. describe Azure Blob storage
. describe Azure File storage

Identify basic management tasks for non-relational data
. describe provisioning and deployment of non-relational data services
. describe method for deployment including ARM templates and Azure Portal
. identify data security components (e.g., firewall, authentication)
. identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)
. identify management tools for non-relational data

Describe an analytics workload on Azure (25-30%)
Describe analytics workloads
. describe transactional workloads
. describe the difference between a transactional and an analytics workload
. describe the difference between batch and real time
. describe data warehousing workloads
. determine when a data warehouse solution is needed

Describe the components of a modern data warehouse
. describe Azure data services for modern data warehousing such as Azure Data Lake, Azure Synapse Analytics, Azure Databricks, and Azure HDInsight
. describe modern data warehousing architecture and workload

Describe data ingestion and processing on Azure
. describe common practices for data loading
. describe the components of Azure Data Factory (e.g., pipeline, activities, etc.)
. describe data processing options (e.g., HDI, Azure Databricks, Azure Synapse Analytics, Azure Data Factory)

Describe data visualization in Microsoft Power BI
. describe the role of paginated reporting
. describe the role of interactive reports
. describe the role of dashboards
. describe the workflow in Power BI

QUESTION 1
You need to query a table named Products in an Azure SQL database.
Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.)
NOTE: Each correct selection is worth one point.

A. You must be assigned the Reader role for the resource group that contains the database.
B. You must have SELECT access to the Products table.
C. You must have a user in the database.
D. You must be assigned the Contributor role for the resource group that contains the database.
E. Your IP address must be allowed to connect to the database.

Correct Answer: ACE

QUESTION 2
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.
Which Azure service should you use?

A. Azure HDInsight
B. Azure SQL Database
C. Azure Cosmos DB
D. SQL Server on Azure virtual machines

Correct Answer: B

QUESTION 3
You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.
You need to embed documents and query results into a SQL notebook.
What should you use?

A. Microsoft SQL Server Management Studio (SSMS)
B. Azure Data Studio
C. Azure CLI
D. Azure PowerShell

Correct Answer: B

QUESTION 4
Which command-line tool can you use to query Azure SQL databases?

A. sqlcmd
B. bcp
C. azdata
D. Azure CLI

Correct Answer: D

Actualkey Microsoft DP-900 exam pdf, Certkingdom Microsoft DP-900 PDF

MCTS Training, MCITP Trainnig

Best Microsoft DP-900 Certification, Microsoft DP-900 Training at certkingdom.com

Microsoft Azure

AZ-304 Microsoft Azure Architect Design (beta) Exam

Skills measured
Design monitoring (10-15%)
Design identity and security (25-30%)
Design data storage (15-20%)
Design business continuity (10-15%)
Design infrastructure (25-30%)

Audience Profile
Candidates for this exam should have subject matter expertise in designing and implementing solutions that run on Microsoft Azure, including aspects like compute, network, storage, and security.
Responsibilities for an Azure Solution Architect include advising stakeholders and translating business requirements into secure, scalable, and reliable cloud solutions.
An Azure Solution Architect partners with cloud administrators, cloud DBAs, and clients to implement solutions.
A candidate for this exam should have advanced experience and knowledge of IT operations, including networking, virtualization, identity, security, business continuity, disaster recovery, data platform, budgeting, and governance–this role should manage how decisions in each area affect an overall solution. In addition, this role should have expert-level skills in Azure administration and have experience with Azure development and DevOps processes.

Skills Measured
NOTE: The bullets that appear below each of the skills measured are intended to illustrate how we are assessing that skill. This list is not definitive or exhaustive.
NOTE: In most cases, exams do NOT cover preview features, and some features will only be added to an exam when they are GA (General Availability).

Design Monitoring (10-15%)
Design for cost optimization
• recommend a solution for cost management and cost reporting
• recommend solutions to minimize costs

Design a solution for logging and monitoring
• determine levels and storage locations for logs
• plan for integration with monitoring tools including Azure Monitor and Azure Sentinel
• recommend appropriate monitoring tool(s) for a solution
• choose a mechanism for event routing and escalation
• recommend a logging solution for compliance requirements

Design Identity and Security (25-30%)
Design authentication
• recommend a solution for single-sign on
• recommend a solution for authentication
• recommend a solution for Conditional Access, including multi-factor authentication
• recommend a solution for network access authentication
• recommend a solution for a hybrid identity including Azure AD Connect and Azure AD Connect Health
• recommend a solution for user self-service
• recommend and implement a solution for B2B integration

Design authorization
• choose an authorization approach
• recommend a hierarchical structure that includes management groups, subscriptions and resource groups
• recommend an access management solution including RBAC policies, access reviews, role assignments, physical access, Privileged Identity Management (PIM), Azure AD Identity Protection, Just In Time (JIT) access

Design governance
• recommend a strategy for tagging
• recommend a solution for using Azure Policy
• recommend a solution for using Azure Blueprint

Design security for applications
• recommend a solution that includes KeyVault
o What can be stored in KeyVault
o KeyVault operations
o KeyVault regions
• recommend a solution that includes Azure AD Managed Identities
• recommend a solution for integrating applications into Azure AD

Design Data Storage (15-20%)
Design a solution for databases
• select an appropriate data platform based on requirements
• recommend database service tier sizing
• recommend a solution for database scalability
• recommend a solution for encrypting data at rest, data in transmission, and data in use

Design data integration
• recommend a data flow to meet business requirements
• recommend a solution for data integration, including Azure Data Factory, Azure Data Bricks, Azure Data Lake, Azure Synapse Analytics

Select an appropriate storage account
• choose between storage tiers
• recommend a storage access solution
• recommend storage management tools

Design Business Continuity (10-15%)
Design a solution for backup and recovery
• recommend a recovery solution for Azure hybrid and on-premises workloads that meets recovery objectives (RTO, RLO, RPO)
• design and Azure Site Recovery solution
o recommend a site recovery replication policy
o recommend a solution for site recovery capacity
o recommend a solution for site failover and failback (planned/unplanned)
o recommend a solution for the site recovery network
• recommend a solution for recovery in different regions
• recommend a solution for Azure Backup management
• design a solution for data archiving and retention
o recommend storage types and methodology for data archiving
o identify business compliance requirements for data archiving
o identify requirements for data archiving
o identify SLA(s) for data archiving
o recommend a data retention policy

Design for high availability
• recommend a solution for application and workload redundancy, including compute, database, and storage
• recommend a solution for autoscaling
• identify resources that require high availability
• identify storage types for high availability
• recommend a solution for geo-redundancy of workloads

Design Infrastructure (25-30%)
Design a compute solution
• recommend a solution for compute provisioning
• determine appropriate compute technologies, including virtual machines, App Services, Service Fabric, Azure Functions, Windows Virtual Desktop, and containers
• recommend a solution for containers
o AKS versus ACI and the configuration of each one
• recommend a solution for automating compute management

Design a network solution
• recommend a solution for network addressing and name resolution
• recommend a solution for network provisioning
• recommend a solution for network security
o private endpoints
o Firewalls
o Gateways
• recommend a solution for network connectivity to the Internet, on-premises networks, and other Azure virtual networks
• recommend a solution for automating network management
• recommend a solution for load balancing and traffic routing

Design an application architecture
• recommend a microservices architecture including Event Grid, Event Hubs, Service Bus, Storage Queues, Logic Apps, Azure Functions, and webhooks
• recommend an orchestration solution for deployment of applications including ARM templates, Logic Apps, or Azure Functions
o select an automation method
o choose which resources or lifecycle steps will be automated
o design integration with other sources such as an ITSM solution
o recommend a solution for monitoring automation
• recommend a solution for API integration
o design an API gateway strategy
o determine policies for internal and external consumption of APIs
o recommend a hosting structure for API management
o recommend when and how to use API Keys

Design migrations
• assess and interpret on-premises servers, data, and applications for migration
• recommend a solution for migrating applications and VMs
• recommend a solution for migration of databases
o determine migration scope, including redundant, related, trivial, and outdated data


QUESTION 1
You need to recommend a solution to generate a monthly report of all the new Azure Resource Manager
resource deployments in your subscription.
What should you include in the recommendation?

A. the Change Tracking management solution
B. Application Insights
C. Azure Monitor action groups
D. Azure Activity Log

Correct Answer: D

QUESTION 2
You have an Azure subscription that contains an Azure SQL database named DB1.
Several queries that query the data in DB1 take a long time to execute.
You need to recommend a solution to identify the queries that take the longest to execute.
What should you include in the recommendation?

A. SQL Database Advisor
B. Azure Monitor
C. Performance Recommendations
D. Query Performance Insight

Correct Answer: D

QUESTION 3
You have an on-premises Hyper-V cluster. The cluster contains Hyper-V hosts that run Windows Server 2016
Datacenter. The hosts are licensed under a Microsoft Enterprise Agreement that has Software Assurance.
The Hyper-V cluster contains 30 virtual machines that run Windows Server 2012 R2. Each virtual machine
runs a different workload. The workloads have predictable consumption patterns.
You plan to replace the virtual machines with Azure virtual machines that run Windows Server 2016. The
virtual machines will be sized according to the consumption pattern of each workload.
You need to recommend a solution to minimize the compute costs of the Azure virtual machines.
Which two recommendations should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Configure a spending limit in the Azure account center.
B. Create a virtual machine scale set that uses autoscaling.
C. Activate Azure Hybrid Benefit for the Azure virtual machines.
D. Purchase Azure Reserved Virtual Machine Instances for the Azure virtual machines.
E. Create a lab in Azure DevTest Labs and place the Azure virtual machines in the lab.

Correct Answer: CD

QUESTION 4
A company has a hybrid ASP.NET Web API application that is based on a software as a service (SaaS) offering.
Users report general issues with the data. You advise the company to implement live monitoring and use ad
hoc queries on stored JSON data. You also advise the company to set up smart alerting to detect anomalies in the data.
You need to recommend a solution to set up smart alerting.
What should you recommend?

A. Azure Site Recovery and Azure Monitor Logs
B. Azure Data Lake Analytics and Azure Monitor Logs
C. Azure Application Insights and Azure Monitor Logs
D. Azure Security Center and Azure Data Lake Store

Correct Answer: B

Actualkey Microsoft Azure AZ-304 exam pdf, Certkingdom Microsoft Azure AZ-304 PDF

MCTS Training, MCITP Trainnig

Best Microsoft Azure AZ-304 Certification, Microsoft Azure AZ-304 Training at certkingdom.com

Tech

312-50v8 Certified Ethical Hacker v8 Exam

What is an Ethical Hacker?
To beat a hacker, you need to think like one!

Ethical Hacking is often referred to as the process of penetrating one’s own computer/s or computers to which one has official permission to do so as to determine if vulnerabilities exist and to undertake preventive, corrective, and protective countermeasures before an actual compromise to the system takes place.

Around the world, partners and customers look to EC-Council to deliver the highest quality exams and certifications. EC-Council has developed a number of policies to support the goals of EC-Council certification program, including:

Become a Certified Ethical Hacker
A Certified Ethical Hacker is a skilled professional who understands and knows how to look for weaknesses and vulnerabilities in target systems and uses the same knowledge and tools as a malicious hacker, but in a lawful and legitimate manner to assess the security posture of a target system(s). The CEH credential certifies individuals in the specific network security discipline of Ethical Hacking from a vendor-neutral perspective.

The purpose of the CEH credential is to:
Establish and govern minimum standards for credentialing professional information security specialists in ethical hacking measures.
Inform the public that credentialed individuals meet or exceed the minimum standards.

Reinforce ethical hacking as a unique and self-regulating profession.

Certification Target Audience
The Certified Ethical Hacker certification will fortify the application knowledge of security officers, auditors, security professionals, site administrators, and anyone who is concerned about the integrity of the network infrastructure.

For more information on CEH application process, please click here

Exam Information
The CEH exam (312-50) is available at the ECC Exam Centre and Pearson Vue testing centers.

For VUE, please visit https://www.vue.com/eccouncil. EC-Council reserves the right to revoke the certification status of candidates that do not comply to all EC-Council examination policies found here.
Duration 4 Hours
Questions 125
Hand Book Blue Print
Passing Criteria:

In order to maintain the high integrity of our certifications exams, EC-Council Exams are provided in multiple forms (I.e. different question banks). Each form is carefully analyzed through beta testing with an appropriate sample group under the purview of a committee of subject matter experts that ensure that each of our exams not only have academic rigor but also have “real world” applicability. We also have a process to determine the difficulty rating of each question . The individual rating then contributes to an overall “Cut Score” for each exam form. To ensure each form has equal assessment standards, cut scores are set on a “per exam form” basis. Depending on which exam form is challenged, cut scores can range from 60% to 85%.

Clause: Age Requirements and Policies Concerning Minors

The age requirement for attending the training or attempting the exam is restricted to any candidate that is at least 18 years old.

If the candidate is under the age of 18, they are not eligible to attend the official training or eligible to attempt the certification exam unless they provide the accredited training center/EC-Council a written consent of their parent/legal guardian and a supporting letter from their institution of higher learning. Only applicants from nationally accredited institution of higher learning shall be considered.

Disclaimer: EC-Council reserves the right to impose additional restriction to comply with the policy. Failure to act in accordance with this clause shall render the authorized training center in violation of their agreement with EC-Council. EC-Council reserves the right to revoke the certification of any person in breach of this requirement.

QUESTION 1
Jimmy, an attacker, knows that he can take advantage of poorly designed input validation routines to create or alter SQL commands to gain access to private data or execute commands in the database. What technique does Jimmy use to compromise a database?

A. Jimmy can submit user input that executes an operating system command to compromise a target system
B. Jimmy can gain control of system to flood the target system with requests,preventing legitimate users from gaining access
C. Jimmy can utilize an incorrect configuration that leads to access with higher-than expected privilege of the database
D. Jimmy can utilize this particular database threat that is an SQL injection technique to penetrate a target system

Answer: D

QUESTION 2
This IDS defeating technique works by splitting a datagram (or packet) into multiple fragments and the IDS will not spot the true nature of the fully assembled datagram. The datagram is not reassembled until it reaches its final destination. It would be a processor-intensive task for IDS to reassemble all fragments itself, and on a busy system the packet will slip through the IDS onto the network. What is this technique called?

A. IP Routing or Packet Dropping
B. IDS Spoofing or Session Assembly
C. IP Fragmentation or Session Splicing
D. IP Splicing or Packet Reassembly

Answer: C

QUESTION 2
This type of Port Scanning technique splits TCP header into several packets so that the packet filters are not able to detect what the packets intends to do.

A. UDP Scanning
B. IP Fragment Scanning
C. Inverse TCP flag scanning
D. ACK flag scanning

Answer: B

QUESTION 3
Joel and her team have been going through tons of garbage, recycled paper, and other rubbish in order to find some information about the target they are attempting to penetrate. How would you call this type of activity?

A. Dumpster Diving
B. Scanning
C. CI Gathering
D. Garbage Scooping

Answer: A

QUESTION 4
Anonymizer sites access the Internet on your behalf, protecting your personal information from disclosure. An anonymizer protects all of your computer’s identifying information while it surfs for you, enabling you to remain at least one step removed from the sites you visit.
You can visit Web sites without allowing anyone to gather information on sites visited by you. Services that provide anonymity disable pop-up windows and cookies, and conceal visitor’s IP
address.
These services typically use a proxy server to process each https: request. When the user requests a Web page by clicking a hyperlink or typing a URL into their browser, the service retrieves and displays the information using its own server. The remote server (where the requested Web page resides) receives information on the anonymous Web surfing service in place of your information.
In which situations would you want to use anonymizer? (Select 3 answers)

A. Increase your Web browsing bandwidth speed by using Anonymizer
B. To protect your privacy and Identity on the Internet
C. To bypass blocking applications that would prevent access to Web sites or parts of sites that you want to visit.
D. Post negative entries in blogs without revealing your IP identity

Answer: B,C,D

Actualkey ECCouncil 312-50v8 exam pdf, Certkingdom ECCouncil 312-50v8 PDF

MCTS Training, MCITP Trainnig

Best ECCouncil 312-50v8 Certification, ECCouncil 312-50v8 Training at certkingdom.com